KeyrockUnique Wallets Staking Overtime -- SEI
Updated 2024-05-30
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
32
33
34
35
36
›
⌄
WITH Staking_CTE AS (
SELECT
date_trunc('day', BLOCK_TIMESTAMP) AS day,
COUNT(DISTINCT TX_CALLER_ADDRESS) AS stakers_count,
SUM(
CASE
WHEN ACTION = 'delegate' THEN amount / 10e6
ELSE 0
END
) AS delegate_sei,
- SUM(
CASE
WHEN ACTION = 'undelegate' THEN amount / 10e6
ELSE 0
END
) AS undelegate_sei
FROM
sei.gov.fact_staking
WHERE
TX_SUCCEEDED = TRUE
GROUP BY
date_trunc('day', BLOCK_TIMESTAMP)
)
SELECT
day,
stakers_count,
delegate_sei,
undelegate_sei,
SUM(delegate_sei + undelegate_sei) OVER (
ORDER BY
day ASC
) as total_sei,
(total_sei / 10e9) * 100 as pct_stake_total_supply,
SUM(stakers_count) OVER (ORDER BY day) AS cumulative_stakers_count
FROM
Staking_CTE
QueryRunArchived: QueryRun has been archived