WEEK | # of All Users | # of New Users | Total New Users | |
|---|---|---|---|---|
1 | 2023-10-30 00:00:00.000 | 2491 | 1992 | 12436 |
2 | 2023-08-14 00:00:00.000 | 1300 | 1133 | 4294 |
3 | 2023-01-16 00:00:00.000 | 59 | 34 | 542 |
4 | 2024-09-30 00:00:00.000 | 2602 | 1717 | 152186 |
5 | 2024-01-15 00:00:00.000 | 2617 | 1769 | 73189 |
6 | 2024-11-25 00:00:00.000 | 11020 | 8883 | 189287 |
7 | 2024-02-05 00:00:00.000 | 3511 | 2700 | 83335 |
8 | 2024-07-22 00:00:00.000 | 3918 | 2708 | 129840 |
9 | 2023-06-05 00:00:00.000 | 53 | 27 | 1159 |
10 | 2024-03-25 00:00:00.000 | 1683 | 1214 | 95058 |
11 | 2023-10-09 00:00:00.000 | 532 | 251 | 9074 |
12 | 2023-07-24 00:00:00.000 | 419 | 291 | 2710 |
13 | 2023-01-23 00:00:00.000 | 49 | 26 | 568 |
14 | 2024-10-07 00:00:00.000 | 5860 | 3312 | 155498 |
15 | 2024-11-18 00:00:00.000 | 10623 | 8077 | 180404 |
16 | 2023-12-11 00:00:00.000 | 5271 | 3710 | 61533 |
17 | 2022-12-26 00:00:00.000 | 29 | 9 | 463 |
18 | 2024-10-14 00:00:00.000 | 5281 | 2727 | 158225 |
19 | 2025-01-06 00:00:00.000 | 6853 | 5055 | 232370 |
20 | 2024-10-28 00:00:00.000 | 4459 | 2786 | 163590 |
ArioWeekly # of Stakers and New Stakers over time
Updated 2025-02-01
999
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 deposit_sol as (
select
block_timestamp,
'Deposit Sol' as type,
TX_ID,
SIGNERS [0] as User_address
from
solana.core.fact_events a
cross join TABLE(FLATTEN(inner_instruction :instructions)) b
where
program_id = 'SPoo1Ku8WFXoNDMHPsrGSTSG1Y47rzgn41SLUNakuHy'
and b.value:parsed:info:lamports is not null
and b.value:programId :: string = '11111111111111111111111111111111'
and b.value:parsed:type = 'transfer'
and SUCCEEDED = 'true'
AND CONTAINS(
a.INSTRUCTION:accounts,
'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn' :: variant
)
group by
1,
2,
3,
4
),
deposit_stake as (
select
block_timestamp,
'Deposit Stake' as type,
TX_ID,
SIGNERS [0] as User_address
from
solana.core.fact_events a
cross join TABLE(FLATTEN(inner_instruction :instructions)) b
cross join table(flatten(inner_instruction:instructions)) c
where
Last run: 2 months ago
...
119
5KB
64s