BLOCK_TIMESTAMP::DATE AS Date

, COUNT(*) AS "Trades number"

, SUM(AMOUNT_USD) AS "Trading volume"

, SUM(FEE_AMOUNT) AS "Fee"

, SUM("Trading volume") OVER (ORDER BY DATE) AS "Total trading volume"

, SUM("Fee") OVER (ORDER BY DATE) AS "Total fee"

, SUM("Trades number") OVER (ORDER BY DATE) AS "Total trades"

blast.blitz.ez_perp_trades

GROUP BY 1

ORDER BY 1 DESC