andurilGMv2 New Users
Updated 2023-05-31
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 GMv2_users AS (
select
t.signers[0] as wallets,
min(date(t.block_timestamp)) as GMv2_first_tx
from
solana.core.fact_transactions t
inner join solana.core.fact_events e
on e.tx_id = t.tx_id
where
date(t.block_timestamp) between '2022-07-21' and current_date()-1 and
e.succeeded = 'TRUE' and
e.program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'
group by 1
),
GMv2_new_users AS (
SELECT
GMv2_first_tx,
count(distinct wallets) as "GMv2 New Wallets",
sum("GMv2 New Wallets") over (order by GMv2_first_tx) as "GMv2 Cumulative"
FROM GMv2_users
WHERE GMv2_first_tx between '2022-07-21' and current_date()-1
GROUP BY 1 )
select * from GMv2_new_users
Run a query to Download Data