KaskoazulSolana New Users - Most common first transaction
Updated 2022-02-12
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
›
⌄
WITH FIRST_TRANSACTION AS(
SELECT
tx_from_address as new_user,
min(block_timestamp) as creation_date
FROM
solana.transactions
WHERE tx_to_address != '' AND succeeded = 'TRUE'
GROUP BY 1
),
FIRST_PROGRAM AS(
SELECT
FIRST_TRANSACTION.new_user,
FIRST_TRANSACTION.creation_date,
t.program_id
FROM
FIRST_TRANSACTION
INNER JOIN solana.transactions t
ON t.tx_from_address = FIRST_TRANSACTION.new_user AND t.block_timestamp = FIRST_TRANSACTION.creation_date
WHERE
creation_date >= '2022-02-01'
)
SELECT
program_id,
CASE program_id
WHEN 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL' THEN 'USDT Token account'
WHEN '11111111111111111111111111111111' THEN 'WrappedSOL'
WHEN 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA' THEN 'Unknown Token account'
WHEN 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW' THEN 'Unknown - no public name'
WHEN 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' THEN 'Jupiter Aggregator v2'
WHEN 'vau1zxA2LbssAUEF7Gpw91zMM1LvXrvpzJtmZ58rPsn' THEN 'Metaplex Token Vault'
WHEN 'EhhTKczWMGQt46ynNeRX1WfeagwwJd7ufHvCDjRxjo5Q' THEN 'Raydium Stake'
WHEN '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' THEN 'Serum DEX V3'
END AS Program_name,
count (program_id)
Run a query to Download Data