Lordkingluna159
    Updated 2023-05-02
    select
    sum (amount) as FLOW,
    count (distinct tx_id) as TRXS,
    delegator,
    case when action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn') then 'Unstake'
    end as TYPE
    from flow.core.ez_staking_actions
    where tx_succeeded = 'TRUE' AND TYPE IS NOT NULL
    group by TYPE , delegator
    order by 1 desc limit 10
    Run a query to Download Data