Lordkingluna159
Updated 2023-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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