validator_address,

validator_label as validator_name,

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

count(distinct tx_id) as redelegates_count,

count(distinct delegator_address) as redelegators_count,

sum(amount) as volume,

row_number() over (partition by timespan order by volume desc) as rank

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

and action = 'Redelegate'

group by 1, 2, 3

qualify rank <= 5

order by timespan, rank