LTirrellNew user issue!!
Updated 2022-11-29
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_wallets AS (
SELECT
signers [0] AS address,
MIN(DATE(block_timestamp)) AS creation_date
FROM
solana.core.fact_transactions
GROUP BY
address
),
solana_new_wallets AS (
SELECT
address,
creation_date
FROM
solana_wallets
WHERE
creation_date = '2022-11-17'
)
SELECT
DISTINCT e.program_id AS program_id,
t.signers [0] :: STRING 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
)
WHERE
e.block_timestamp :: DATE = '2022-11-17'
AND e.program_id = 'TokenVbSaLatYMStMWat8wXSi4tZg6uSnm8foP9zA2V'
AND t.signers [0]::string IN (
SELECT
address
FROM
solana_new_wallets
Run a query to Download Data