DATE | Cumulative Unique Stakers | |
|---|---|---|
1 | 2025-02-19 00:00:00.000 | 484 |
2 | 2025-02-20 00:00:00.000 | 2054 |
3 | 2025-02-21 00:00:00.000 | 3896 |
4 | 2025-02-22 00:00:00.000 | 7268 |
5 | 2025-02-23 00:00:00.000 | 16683 |
6 | 2025-02-24 00:00:00.000 | 26108 |
7 | 2025-02-25 00:00:00.000 | 54869 |
8 | 2025-02-26 00:00:00.000 | 136850 |
9 | 2025-02-27 00:00:00.000 | 174231 |
10 | 2025-02-28 00:00:00.000 | 207538 |
11 | 2025-03-01 00:00:00.000 | 235591 |
12 | 2025-03-02 00:00:00.000 | 278424 |
13 | 2025-03-03 00:00:00.000 | 305306 |
14 | 2025-03-04 00:00:00.000 | 379015 |
15 | 2025-03-05 00:00:00.000 | 424266 |
16 | 2025-03-06 00:00:00.000 | 465307 |
17 | 2025-03-07 00:00:00.000 | 509580 |
18 | 2025-03-08 00:00:00.000 | 536909 |
19 | 2025-03-09 00:00:00.000 | 562547 |
20 | 2025-03-10 00:00:00.000 | 601666 |
MrftishMONAD users
Updated 2025-05-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
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Magma users copy @ https://flipsidecrypto.xyz/studio/queries/173f17cb-c16a-489a-b73c-bd0aa902611b
WITH database AS (
SELECT
a.BLOCK_TIMESTAMP,
a.TX_HASH,
a.ORIGIN_FROM_ADDRESS AS "Staker"
FROM
monad.testnet.fact_event_logs a
JOIN monad.testnet.fact_transactions b ON a.tx_hash = b.tx_hash
WHERE
a.CONTRACT_ADDRESS = lower ('0x3a98250f98dd388c211206983453837c8365bdc1')
and a.ORIGIN_TO_ADDRESS = lower ('0x3a98250f98dd388c211206983453837c8365bdc1')
and a.ORIGIN_FUNCTION_SIGNATURE = '0x6e553f65'
and a.TX_SUCCEEDED = 'TRUE'
),
first_time_stakers AS (
SELECT
"Staker",
MIN(DATE(BLOCK_TIMESTAMP)) AS "First Staking Date" -- Get the first staking date for each staker
FROM database
GROUP BY "Staker"
),
daily_unique_stakers AS (
SELECT
"First Staking Date" AS date,
COUNT("Staker") AS "New Unique Stakers" -- Count new unique stakers per day
FROM first_time_stakers
GROUP BY "First Staking Date"
)
SELECT
date,
SUM("New Unique Stakers") OVER (ORDER BY date) AS "Cumulative Unique Stakers" -- Calculate cumulative unique stakers
FROM daily_unique_stakers
where date > '2025-02-18 00:00:00.000 '
Last run: about 2 months ago
...
102
4KB
331s