sagharkariTop 10 FLOW Delegators With Most Number of UnStakes
Updated 2023-05-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with maintable as (
select delegator,
case when action in ('DelegatorTokensCommitted','TokensCommitted') then 'Stake'
when action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn') then 'Unstake'
when action in ('DelegatorRewardTokensWithdrawn','RewardTokensWithdrawn') then 'Claim Reward' end as action_type,
count (distinct tx_id) as TX_Count,
count (distinct delegator) as Users_Count,
sum (amount) as Total_Volume,
avg (amount) as Average_Volume,
median (amount) as Median_Volume,
min (amount) as Min_Volume,
max (amount) as Max_Volume
from flow.core.ez_staking_actions
where tx_succeeded = 'TRUE'
group by 1,2)
select delegator,
tx_count,
total_volume
from maintable
where action_type = 'Unstake'
order by 2 DESC
limit 10
Run a query to Download Data