select ORIGIN_FROM_ADDRESS

,sum(AMOUNT_IN_USD) as sell_volume

,rank()over(order by sell_volume ) as rank

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP>='2023-03-01' and BLOCK_TIMESTAMP<='2023-03-10'

and TOKEN_IN='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

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

and AMOUNT_IN_USD is not null

group by 1

order by 2 desc

limit 20),

tab2 as (

select ORIGIN_FROM_ADDRESS

,sum(AMOUNT_IN_USD) as sell_volume

,rank()over(order by sell_volume ) as rank

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP>='2023-03-10' and BLOCK_TIMESTAMP<='2023-03-20'

and TOKEN_IN='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

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

and AMOUNT_IN_USD is not null

group by 1

order by 2 desc

limit 20)

select 'Ten Days Before Launche' as t_period

,sum(sell_volume) as total_sell_volume

from tab1

group by 1

union all

select 'Ten Days After Launche' as t_period

,sum(sell_volume) as total_sell_volume

from tab2

group by 1