DATE | NEW_STAKERS | TOTAL_UNIQUE_STAKERS_CUMULATIVE | |
|---|---|---|---|
1 | 2025-04-21 00:00:00.000 | 3 | 221 |
2 | 2025-04-14 00:00:00.000 | 1 | 218 |
3 | 2025-04-07 00:00:00.000 | 3 | 217 |
4 | 2025-03-31 00:00:00.000 | 3 | 214 |
5 | 2025-03-24 00:00:00.000 | 5 | 211 |
6 | 2025-03-17 00:00:00.000 | 7 | 206 |
7 | 2025-03-10 00:00:00.000 | 3 | 199 |
8 | 2025-02-24 00:00:00.000 | 5 | 196 |
9 | 2025-02-17 00:00:00.000 | 8 | 191 |
10 | 2025-02-10 00:00:00.000 | 10 | 183 |
11 | 2025-02-03 00:00:00.000 | 8 | 173 |
12 | 2025-01-27 00:00:00.000 | 1 | 165 |
13 | 2025-01-20 00:00:00.000 | 3 | 164 |
14 | 2025-01-13 00:00:00.000 | 4 | 161 |
15 | 2025-01-06 00:00:00.000 | 3 | 157 |
16 | 2024-12-30 00:00:00.000 | 4 | 154 |
17 | 2024-12-23 00:00:00.000 | 4 | 150 |
18 | 2024-12-16 00:00:00.000 | 4 | 146 |
19 | 2024-12-09 00:00:00.000 | 12 | 142 |
20 | 2024-12-02 00:00:00.000 | 7 | 130 |
adriaparcerisasankrEVM staking pool 2
Updated 7 minutes ago
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
›
⌄
WITH all_stakers AS (
-- Get all staking transactions along with the staker's address and the staking date
SELECT
from_address AS staker,
TRUNC(block_timestamp, 'week') AS date
FROM flow.core_evm.fact_transactions
WHERE origin_function_signature = '0xac76d450'
AND lower(to_address) = lower('0xFE8189A3016cb6A3668b8ccdAC520CE572D4287a')
),
-- Rank each staker by the first time they appeared (their first staking date)
first_stake AS (
SELECT
staker,
MIN(date) AS first_stake_date
FROM all_stakers
GROUP BY staker
),
-- Count the daily new stakers and the cumulative unique stakers over time
daily_new_stakers AS (
SELECT
first_stake_date AS date,
COUNT(DISTINCT staker) AS new_stakers
FROM first_stake
GROUP BY first_stake_date
)
-- Final query to get daily new stakers and cumulative unique stakers
SELECT
d.date,
COALESCE(d.new_stakers, 0) AS new_stakers,
SUM(COALESCE(d.new_stakers, 0)) OVER (ORDER BY d.date) AS total_unique_stakers_cumulative
FROM daily_new_stakers d
ORDER BY d.date desc
Last run: 7 minutes ago
33
1KB
1s