mohammadh2) The Unstakeeeeers (re-delegate)
    Updated 2022-07-17
    select count(distinct TX_ID),sum(AMOUNT/1e6) as sum_amount ,LABEL
    from osmosis.core.fact_staking join osmosis.core.dim_labels on osmosis.core.fact_staking.VALIDATOR_ADDRESS=osmosis.core.dim_labels.ADDRESS
    where block_timestamp>= '2022-01-01'
    and ACTION ='redelegate'
    and DELEGATOR_ADDRESS in (select DELEGATOR_ADDRESS from osmosis.core.fact_staking where block_timestamp>= '2022-05-01' and ACTION ='undelegate')
    group by LABEL
    order by sum_amount desc
    Run a query to Download Data