Guest User

Untitled

a guest
Aug 20th, 2019
66
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM Market WHERE AssetPairId = '1' AND [Time] BETWEEN '1565521380' AND '1566334368'
  2.  
  3. Volume, High, Low, [Open], [Close], Time
  4.  
  5. select convert(date, timestampcol) as dte, sum(col1), . . .
  6. from t
  7. group by convert(date, timestampcol)
  8. order by convert(date, timestampcol);
RAW Paste Data