iff(block_timestamp::date >= '2023-01-14', 'After Announcement', 'Before Announcement') as timespan,

action,

count(distinct tx_id) as stakes_count,

count(distinct delegator_address) as stakers_count,

count(distinct validator_address) as validators_count,

sum(amount) as volume

from terra.core.ez_staking

where block_timestamp between date('2023-01-14') - interval '1 week' and date('2023-01-14') + interval '1 week'

and tx_succeeded = 1

group by 1, 2

order by 2, 1