LTirrellnew_wallet_comparison
Updated 2022-11-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH solana_wallets AS (
SELECT
signers [0] AS address,
MIN(DATE(block_timestamp)) AS creation_date
FROM
solana.core.fact_transactions
GROUP BY
address
)
SELECT
count(address) as new_users,
DATE_TRUNC(
week,
creation_date
) AS week
FROM
solana_wallets
WHERE
week = '2022-09-19'
GROUP BY
week
Run a query to Download Data