LTirrell2023-05-05 01:46 PM
Updated 2023-05-05
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
›
⌄
with first_tx as (
select
signers[0] as wallet,
min(date(block_timestamp)) as first_tx_date
from
solana.core.fact_events
where
program_id = '3Kr1RcL41pWL7qzAA5tCTTKcqjbG3RNRsFaDGMd82iW4'
group by
1
),
new_wallets AS (
SELECT
first_tx_date,
count(distinct wallet) as new_wallets
FROM
first_tx
WHERE
first_tx_date between CURRENT_DATE() - 61 and current_date() - 1
GROUP BY
1
)
select
*
from
new_wallets
Run a query to Download Data