SYMBOL_IN

--,SYMBOL_OUT

,case

when BLOCK_TIMESTAMP::date>='2023-02-21' and BLOCK_TIMESTAMP::date<'2023-02-28' then 'ONE WEEK BEFORE UNITY ANNOUNCE'

when BLOCK_TIMESTAMP::date>='2023-02-28' and BLOCK_TIMESTAMP::date<='2023-03-06' then 'ONE WEEK AFTER UNITY ANNOUNCE'

end as time_period

,sum(AMOUNT_IN_USD) as sell_volume

--,sum(AMOUNT_OUT_USD) as buy_volume

,count(distinct ORIGIN_FROM_ADDRESS) as swappers

,count(distinct TX_HASH) as swap_count

from ethereum.core.ez_dex_swaps

where SYMBOL_IN in ('SLP','ENJ','ILV','SAND','UOS','GALA','GALA','AXS','MANA')

--where SYMBOL_OUT in ('SLP','ENJ','ILV','SAND','UOS','GALA','GALA','AXS','MANA')

and BLOCK_TIMESTAMP::date>='2023-02-21'

and ORIGIN_TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'

and AMOUNT_IN_USD is not null

and time_period is not null

group by 1,2