LTirrellUntitled Query
Updated 2022-11-06
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
›
⌄
WITH solana_new_wallets AS (
SELECT
*
FROM
solana.core.ez_signers
WHERE
first_tx_date = '2022-08-23'
)
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-08-23'
AND e.program_id = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo'
AND t.signers [0]::string IN (
SELECT
signer
FROM
solana_new_wallets
)
Run a query to Download Data