,SYMBOL_OUT

,case

when date>='2023-02-16' and date<='2023-02-22' then 'ONE WEEK BEFORE COINBASE ANNOUNCE'

when date>='2023-02-23' and date<='2023-03-01' then 'ONE WEEK AFTER COINBASE ANNOUNCE' end as time_period

,sum(AMOUNT_OUT_USD) as swap_volume

,count(distinct ORIGIN_FROM_ADDRESS) as swappers

,count(distinct TX_HASH) as swap_count

from optimism.core.ez_dex_swaps

where date>='2023-02-16'

and SYMBOL_OUT in('SONNE','VELO','OPX','PERP','OP')

and time_period is not null

group by 1,2,3