date_trunc('day', block_timestamp) as date,

COUNT(DISTINCT tx_hash) AS transaction_count,

COUNT(DISTINCT trader) AS unique_trader_count,

COUNT(DISTINCT symbol) AS unique_token_count,

SUM(amount_usd) AS transaction_volume,

AVG(transaction_count) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS MA_7_transactions,

AVG(transaction_count) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS MA_30_transactions,

AVG(transaction_volume) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS MA_7_volume,

AVG(transaction_volume) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS MA_30_volume,

AVG(unique_trader_count) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS MA_7_traders,

SUM(transaction_count) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tx_count,

SUM(transaction_volume) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tx_volume

FROM

blast.blitz.ez_perp_trades

WHERE

trader != '0x0000000000000000000000000000000000000000'

group by date