andurilSolana New Wallet Activity
Updated 2023-01-30
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
›
⌄
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 >= '2023-01-01'
GROUP BY 1 )
--marketplaces and nft sales/transfers
--defi programs
--other programs/top programs
--transfers
--
Run a query to Download Data