andurilCandy Machine v2 Deployers
Updated 2024-11-02
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
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
/*
Token entangler - qntmGodpGkrM42mN68VCZHXnKqDCT8rdY23wFcXCLPd
Gumdrop - gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a
Fair launch - faircnAB9k59Y4TXmLabBULeuTLgV7TkGMGNkjnA15j
Auction House - hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk
Candy Machine V1 - cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ
Candy Machine V2 - cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ
*/
with cndy_v2_deployers as
(
select
t.signers[0] as wallets,
min(date(t.block_timestamp)) as cmv2_first_tx
from solana.core.fact_events e
inner join solana.core.fact_transactions t
on e.tx_id = t.tx_id
where
date(t.block_timestamp) between '2022-01-01' and '2022-06-01'
and e.program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ'
and e.succeeded = 'TRUE'
--and log_messages::string like '%Program log: Instruction: InitializeCandyMachine%'
and t.instructions[0]:parsed:info:owner = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ'
group by 1
),
cmv2_new_users AS (
SELECT
cmv2_first_tx,
count(distinct wallets) as "CMV2 New Wallets",
sum("CMV2 New Wallets") over (order by cmv2_first_tx) as "CMV2 Cumulative"
FROM cndy_v2_deployers
QueryRunArchived: QueryRun has been archived