date_trunc('day', block_timestamp) as date,

case

when date between '2023-01-07' and '2023-01-13' then 'A week before'

when date = '2023-01-14' then 'Announce day'

when date between '2023-01-15' and '2023-01-21' then 'A week after'

else 'Other' end as type,

count(distinct TX_ID) as txs,

count(distinct DELEGATOR_ADDRESS) as users,

sum(AMOUNT) as volume

from terra.core.ez_staking

where date between '2023-01-07' and '2023-01-21'

and tx_succeeded = 'TRUE'

and ACTION= 'Delegate'

group by 1,2

order by 1 asc