HDKf7
Updated 2023-06-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
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 block_timestamp::date >= '2023-05-01'
AND
TYPE IS NOT NULL
group by
TYPE,
delegator
order by
1 desc
limit
10
Run a query to Download Data