validator_address,

count(distinct tx_id) as unstaked_count,

sum(amount/1e6) as unstaked_volume,

count(distinct delegator_address) as unstakers_count

from osmosis.core.fact_staking

where action = 'undelegate'

and tx_succeeded = 1

and block_timestamp > current_date - interval '6 months'

group by 1

order by unstaked_count desc

limit 10