LTirrellUntitled Query
Updated 2022-10-19
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
›
⌄
WITH solana_wallets AS (
SELECT
signers [0] AS address,
MIN(DATE(block_timestamp)) AS creation_date,
MAX(DATE(block_timestamp)) AS last_use
FROM
solana.core.fact_transactions
GROUP BY
address
),
solana_new_wallets AS (
SELECT
distinct address,
creation_date,
last_use
FROM
solana_wallets
WHERE
creation_date = '2022-09-21'
)
SELECT
*
FROM
solana_new_wallets
Run a query to Download Data