DAY | WALLET_COUNT | CUMU_WALLET_COUNT | |
|---|---|---|---|
1 | 2024-01-30 00:00:00.000 | 44587 | 1687181 |
2 | 2024-01-29 00:00:00.000 | 126504 | 1642594 |
3 | 2024-01-28 00:00:00.000 | 84263 | 1516090 |
4 | 2024-01-27 00:00:00.000 | 83862 | 1431827 |
5 | 2024-01-26 00:00:00.000 | 63053 | 1347965 |
6 | 2024-01-25 00:00:00.000 | 67479 | 1284912 |
7 | 2024-01-24 00:00:00.000 | 45625 | 1217433 |
8 | 2024-01-23 00:00:00.000 | 47264 | 1171808 |
9 | 2024-01-22 00:00:00.000 | 51881 | 1124544 |
10 | 2024-01-21 00:00:00.000 | 52264 | 1072663 |
11 | 2024-01-20 00:00:00.000 | 60741 | 1020399 |
12 | 2024-01-19 00:00:00.000 | 44147 | 959658 |
13 | 2024-01-18 00:00:00.000 | 52338 | 915511 |
14 | 2024-01-17 00:00:00.000 | 55218 | 863173 |
15 | 2024-01-16 00:00:00.000 | 76329 | 807955 |
16 | 2024-01-15 00:00:00.000 | 50941 | 731626 |
17 | 2024-01-14 00:00:00.000 | 39302 | 680685 |
18 | 2024-01-13 00:00:00.000 | 37101 | 641383 |
19 | 2024-01-12 00:00:00.000 | 43622 | 604282 |
20 | 2024-01-11 00:00:00.000 | 45695 | 560660 |
RayyykSolana user adoption 1
Updated 2024-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with new_user as (select min(block_timestamp) as initial_transaction,
signers[0] as new_users
from solana.core.fact_transactions
where succeeded = 'TRUE'
group by 2
having initial_transaction >= current_date - 30),
table_1 as (select date_trunc('day', initial_transaction) as day,
count(distinct(new_users)) as wallet_count,
sum(wallet_count) over (order by day) as cumu_wallet_count
from new_user
group by 1)
select day,
wallet_count,
cumu_wallet_count
from table_1
order by 1 desc
Last run: over 1 year ago
31
1KB
892s