DATE | NEW_STAKERS | CUMULATIVE_STAKERS | |
|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 68 | 68 |
2 | 2025-01-02 00:00:00.000 | 217 | 285 |
3 | 2025-01-03 00:00:00.000 | 112 | 397 |
4 | 2025-01-04 00:00:00.000 | 95 | 492 |
5 | 2025-01-05 00:00:00.000 | 102 | 594 |
6 | 2025-01-06 00:00:00.000 | 101 | 695 |
7 | 2025-01-07 00:00:00.000 | 80 | 775 |
8 | 2025-01-08 00:00:00.000 | 77 | 852 |
9 | 2025-01-09 00:00:00.000 | 88 | 940 |
10 | 2025-01-10 00:00:00.000 | 97 | 1037 |
11 | 2025-01-11 00:00:00.000 | 72 | 1109 |
12 | 2025-01-12 00:00:00.000 | 63 | 1172 |
13 | 2025-01-13 00:00:00.000 | 76 | 1248 |
14 | 2025-01-14 00:00:00.000 | 74 | 1322 |
15 | 2025-01-15 00:00:00.000 | 73 | 1395 |
16 | 2025-01-16 00:00:00.000 | 89 | 1484 |
17 | 2025-01-17 00:00:00.000 | 86 | 1570 |
18 | 2025-01-18 00:00:00.000 | 64 | 1634 |
19 | 2025-01-19 00:00:00.000 | 52 | 1686 |
20 | 2025-01-20 00:00:00.000 | 54 | 1740 |
theericstonelikely-turquoise
Updated 2025-03-31
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
›
⌄
WITH daily_new_stakers AS (
SELECT
DATE_TRUNC('day', block_timestamp) as date,
provider_address,
MIN(DATE_TRUNC('day', block_timestamp)) OVER (PARTITION BY provider_address) as first_stake_date
FROM solana.marinade.ez_liquid_staking_actions
WHERE action_type = 'deposit'
AND block_timestamp >= '2025-01-01'
AND block_timestamp <= CURRENT_DATE
),
cumulative_stakers AS (
SELECT
date,
COUNT(DISTINCT provider_address) as new_stakers,
SUM(COUNT(DISTINCT provider_address)) OVER (ORDER BY date) as cumulative_stakers
FROM daily_new_stakers
WHERE date = first_stake_date
GROUP BY date
)
SELECT
date,
new_stakers,
cumulative_stakers
FROM cumulative_stakers
ORDER BY date;
Last run: 27 days ago
89
3KB
2s