LTirrell2023-06-01 09:44 PM
Updated 2023-06-01
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 solana_new_wallets AS (
SELECT
signer as address,
first_tx_date as creation_date
FROM
solana.core.ez_signers
WHERE
creation_date = '2023-05-31'
)
SELECT
e.block_timestamp :: DATE AS "Date",
e.program_id,
COUNT(DISTINCT e.tx_id) AS tx_count,
COUNT(DISTINCT s.value) AS signers
FROM
solana.core.fact_events e
JOIN solana.core.fact_transactions t
ON (
e.tx_id = t.tx_id
AND e.block_timestamp :: DATE = t.block_timestamp :: DATE
),
lateral flatten(t.signers) as s
WHERE
e.block_timestamp :: DATE = '2023-05-31'
AND s.value IN (
SELECT
address
FROM
solana_new_wallets
)
GROUP BY
program_id,
"Date"
ORDER BY
signers
Run a query to Download Data