yasmin-n-d-r-htop lp
Updated 2023-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT DISTINCT
(ez.delegator),
SUM(ez.amount) AS volume_flow_token
FROM
flow.core.ez_staking_actions AS ez
JOIN flow.core.fact_transactions AS ft ON ez.tx_id = ft.tx_id
WHERE
ez.action IN ('DelegatorTokensCommitted', 'TokensCommitted')
AND ez.tx_succeeded = 'TRUE'
AND ft.PROPOSER = '0x55ad22f01ef568a1'
AND ft.PAYER = '0x55ad22f01ef568a1'
AND ez.block_timestamp >= '2023-01-01'::TIMESTAMP
GROUP BY
ez.delegator
ORDER BY
volume_flow_token DESC
LIMIT
5;
Run a query to Download Data