REDELEGATE_SOURCE_VALIDATOR_ADDRESS as validator_from_address,

validator_address as validator_to_address,

count(distinct tx_id) as redelegates_count,

count(distinct delegator_address) as redelegators_count,

sum(amount) as volume

from osmosis.core.fact_staking

where block_timestamp > current_date - interval '6 months'

and tx_succeeded = 1

and action = 'redelegate'

group by 1, 2

order by redelegates_count desc

limit 10