BLOCK_TIMESTAMP::date as date

,case

when date>='2023-01-07' and date<='2023-01-13' then 'ONE WEEK BEFORE ANNOUNCE'

when date>='2023-01-14' and date<='2023-01-20' then 'ONE WEEK AFTER ANNOUNCE' end as time_period

,count(distinct DELEGATOR_ADDRESS) as "STAKING USER"

,count(distinct TX_ID)as "STAKING COUNT"

,count(distinct VALIDATOR_ADDRESS) as "VALIDATOR COUNT"

,sum(AMOUNT) as "STAKING VOLUME"

from terra.core.ez_staking

where date>='2023-01-07'

and time_period is not null

group by 1