SELECT * FROM Market WHERE AssetPairId = '1' AND [Time] BETWEEN '1565521380' AND '1566334368'

Volume, High, Low, [Open], [Close], Time

select convert(date, timestampcol) as dte, sum(col1), . . .
from t
group by convert(date, timestampcol)
order by convert(date, timestampcol);