SpiltadavidNew Wallets
Updated 2022-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH joindate as (
SELECT
TX_SIGNER,
min(date_trunc('day',BLOCK_TIMESTAMP)) as min_date
FROM near.core.fact_transactions
GROUP BY 1 ORDER by 2
)
SELECT
-- min_date as "Join date",
COUNT(TX_SIGNER) as "New Wallets"
FROM
joindate
WHERE min_date >= '2022-11-01'
Run a query to Download Data