datavortexTop Delegators By Volume Staked
Updated 2024-12-05
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
26
27
28
29
30
31
›
⌄
WITH DelegatorStake AS (
SELECT
delegator_address AS "Delegator",
SUM(
CASE
WHEN action = 'delegate' THEN amount / 1000000
ELSE 0
END
) AS "Total Delegated SEI"
FROM
sei.gov.fact_staking
WHERE
tx_succeeded = TRUE
AND block_timestamp >= DATEADD(month, -3, CURRENT_DATE)
AND block_timestamp < CURRENT_DATE
AND action = 'delegate'
GROUP BY
delegator_address
HAVING
"Total Delegated SEI" > 0
)
SELECT
d."Delegator",
d."Total Delegated SEI"
FROM
DelegatorStake d
ORDER BY
d."Total Delegated SEI" DESC
LIMIT 5;
QueryRunArchived: QueryRun has been archived