andurilMetaplex Active users and txs
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 metaplex_txs as (
select
distinct tx_id,
program_id
from solana.core.fact_events
where
date(block_timestamp) between current_date()-91 and current_date()-1 and
succeeded = 'TRUE' and
program_id IN
(
'qntmGodpGkrM42mN68VCZHXnKqDCT8rdY23wFcXCLPd',
'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a',
'faircnAB9k59Y4TXmLabBULeuTLgV7TkGMGNkjnA15j',
'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk',
'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ',
'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ')
)
select
date(t.block_timestamp) as date,
count (distinct t.signers[0]) as wallets,
count (distinct t.tx_id) as txs,
case when m.program_id = 'qntmGodpGkrM42mN68VCZHXnKqDCT8rdY23wFcXCLPd' then 'Token Entangler'
when m.program_id = 'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a' then 'Gumdrop'
when m.program_id = 'faircnAB9k59Y4TXmLabBULeuTLgV7TkGMGNkjnA15j' then 'Fair Launch'
QueryRunArchived: QueryRun has been archived