DATE_TRUNC('week', block_timestamp) AS date,

SUM(amount_usd) AS volume,

SUM(SUM(amount_usd)) OVER (ORDER BY date) AS cum_volume,

COUNT(DISTINCT tx_hash) AS Num_Transaction,

SUM(COUNT(DISTINCT tx_hash)) OVER (ORDER BY date) AS Cum_Num_Transaction,

COUNT(DISTINCT trader) AS Num_Users,

AVG(SUM(amount_usd)) OVER (ORDER BY date) AS avg_volume,

FROM blast.blitz.ez_perp_trades

is_taker = 'TRUE'

GROUP BY

date

ORDER BY

date DESC