case

when BLOCK_TIMESTAMP>='2023-03-01' and BLOCK_TIMESTAMP<='2023-03-10' then 'TEN DAYS BEFORE LAUNCHE'

when BLOCK_TIMESTAMP>='2023-03-11' and BLOCK_TIMESTAMP<='2023-03-20' then 'TEN DAYS AFTER LAUNCHE' end as t_period

,case

when AMOUNT_OUT_USD>0 and AMOUNT_OUT_USD<=10 then 'Below 10 $'

when AMOUNT_OUT_USD>10 and AMOUNT_OUT_USD<=100 then '10~100 $'

when AMOUNT_OUT_USD>100 and AMOUNT_OUT_USD<=1000 then '100~1K $'

when AMOUNT_OUT_USD>1000 and AMOUNT_OUT_USD<=10000 then '1K~10K $'

when AMOUNT_OUT_USD>10000 and AMOUNT_OUT_USD<=100000 then '10K~100K $'

when AMOUNT_OUT_USD>100000 and AMOUNT_OUT_USD<=1000000 then '100K~1M $'

when AMOUNT_IN_USD>1000000 then 'Up To 1M $' end as dis_buy_volume

,count(distinct TX_HASH) as tx_count

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP>='2023-01-01'

and TOKEN_OUT='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

and PLATFORM in ('uniswap-v2','uniswap-v3')

and t_period is not null

and dis_buy_volume is not null

group by 1,2