select ORIGIN_FROM_ADDRESS--BLOCK_TIMESTAMP::date as date

,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

,sum(AMOUNT) as transfer_volume

,count(distinct TX_HASH) as transfer_count

from ethereum.core.ez_token_transfers

where CONTRACT_ADDRESS='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

and BLOCK_TIMESTAMP>='2023-01-01'

and t_period is not null

group by 1,2)

select t_period

,avg(transfer_volume) as avg_volume

,avg(transfer_count) as avg_count

from tab1

group by 1