SHARE
TWEET

Untitled

a guest Aug 20th, 2019 63 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top