redelegate_source_validator_address as validator_from_address,

validator_address as validator_to_address,

count(distinct tx_id) as redelegates_count,

sum(amount/1e6) as volume,

count(distinct delegator_address) as redelegators_count

from osmosis.core.fact_staking

where action = 'redelegate'

and block_timestamp > current_date - interval '6 months'

and tx_succeeded = 1

group by 1, 2

order by volume desc

limit 10