BLOCK_TIMESTAMP::DATE AS Date

, SYMBOL

, TRADE_TYPE

, COUNT(*) AS "Trades number"

, COUNT(DISTINCT TRADER) AS "Traders"

, 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"

blast.blitz.ez_perp_trades

GROUP BY 1,2,3