SELECT

block_timestamp::date as date,

case

when date>= '2022-11-08' then 'After FTX & Alameda collapse'

when date < '2022-11-08' then 'Before FTX & Alameda collapse'

end as timespan,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT origin_from_address) as swappers,

sum(amount_in_usd) as usd_volume,

avg(amount_in_usd) as average_usd_volume

FROM ethereum.core.ez_dex_swaps

WHERE event_name = 'Swap'

AND platform like '%uniswap%'

and block_timestamp >= CURRENT_DATE - 60

and (symbol_out = 'WETH' and symbol_in in ('USDC','USDT','DAI','BUSD','USDP','TUSD','USDD','USDN','GUSD'))

group by date

select timespan , avg(swaps) as avg_swaps , avg(swappers) as avg_swappers , avg(usd_volume) as avg_usd_volume

from tab1 where date != CURRENT_DATE group by timespan