select trader

,sum(FROM_AMOUNT/1e6) as "Sell Volume of $Luna"

,rank()over(order by "Sell Volume of $Luna") as rank

from terra.core.ez_swaps

where BLOCK_TIMESTAMP>='2023-01-07' and BLOCK_TIMESTAMP<='2023-01-13'

and TX_SUCCEEDED='TRUE'

and FROM_CURRENCY='uluna'

group by 1

order by 2 desc

limit 20),

tab2 as (

select trader

,sum(FROM_AMOUNT/1e6) as "Sell Volume of $Luna"

,rank()over(order by "Sell Volume of $Luna") as rank

from terra.core.ez_swaps

where BLOCK_TIMESTAMP>='2023-01-14' and BLOCK_TIMESTAMP<='2023-01-20'

and TX_SUCCEEDED='TRUE'

and FROM_CURRENCY='uluna'

group by 1

order by 2 desc

limit 20)

select 'One Week Before Announce' as t_type

,sum("Sell Volume of $Luna") as volume

from tab1

group by 1

union all

select 'One Week After Announce' as t_type

,sum("Sell Volume of $Luna") as volume

from tab2

group by 1