date_trunc('day', block_timestamp) as date,

COUNT(DISTINCT tx_hash) AS transaction_count,

COUNT(DISTINCT origin_from_address) AS unique_trader_count,

SUM(amount_in_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

arbitrum.defi.ez_dex_swaps

where date >= '2024-01-01'

group by date