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,

sum(fee_amount) as protocol_fee,

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,

SUM(protocol_fee) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_protocol_fee

FROM

arbitrum.vertex.ez_perp_trades

WHERE

is_taker = TRUE and date >= '2024-01-01'

group by date