SOLANA_FIRST_TX | NEW_WALLETS | |
---|---|---|
1 | 2024-02-08 00:00:00.000 | 80081 |
2 | 2024-02-07 00:00:00.000 | 80293 |
3 | 2024-02-06 00:00:00.000 | 48506 |
4 | 2024-02-05 00:00:00.000 | 62439 |
5 | 2024-02-04 00:00:00.000 | 64034 |
6 | 2024-02-03 00:00:00.000 | 61402 |
7 | 2024-02-02 00:00:00.000 | 88047 |
8 | 2024-02-01 00:00:00.000 | 83549 |
9 | 2024-01-31 00:00:00.000 | 92565 |
10 | 2024-01-30 00:00:00.000 | 93079 |
11 | 2024-01-29 00:00:00.000 | 126560 |
12 | 2024-01-28 00:00:00.000 | 84419 |
13 | 2024-01-27 00:00:00.000 | 84060 |
14 | 2024-01-26 00:00:00.000 | 63056 |
15 | 2024-01-25 00:00:00.000 | 67814 |
16 | 2024-01-24 00:00:00.000 | 45595 |
17 | 2024-01-23 00:00:00.000 | 47438 |
18 | 2024-01-22 00:00:00.000 | 51854 |
19 | 2024-01-21 00:00:00.000 | 52193 |
20 | 2024-01-20 00:00:00.000 | 60827 |
LTirrellNew Solana Wallets copy
Updated 2024-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH solana_wallets AS (
SELECT
signers[0] as wallets,
min(date(block_timestamp)) as solana_first_tx
FROM solana.core.fact_transactions
GROUP BY 1
),
solana_new_wallets AS (
SELECT
solana_first_tx,
count(distinct wallets) as new_wallets
FROM solana_wallets
WHERE solana_first_tx between CURRENT_DATE()-30 and current_date()-1
GROUP BY 1 )
select * from solana_new_wallets
order by solana_first_tx desc
Last run: 12 months ago
30
1022B
1088s