date_trunc('day', block_timestamp) as day,

CASE WHEN block_timestamp > '2022-11-08' THEN 'Post FTX Event' ELSE 'Pre FTX Event' END as time_period,

count(DISTINCT tx_hash) as transactions,

sum(amount_in_usd) as volume,

avg(amount_in_usd) as avg_swap,

COUNT(DISTINCT sender) as users

FROM ethereum.core.ez_dex_swaps

WHERE block_timestamp > CURRENT_DATE - {{day_timeframe}}

AND amount_in_usd < 1000000000

GROUP BY 1,2