andurilMetaplex Wallet Activity - 7/21
Updated 2022-09-13
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
›
⌄
with metaplex_txs as (
select
tx_id,
program_id
from solana.core.fact_events
where
date(block_timestamp) >= current_date()-90 and
succeeded = 'TRUE' and
program_id IN
(
'qntmGodpGkrM42mN68VCZHXnKqDCT8rdY23wFcXCLPd',
'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a',
'faircnAB9k59Y4TXmLabBULeuTLgV7TkGMGNkjnA15j',
'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk',
'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ',
'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ')
),
solana_txs as (
select * from
solana.core.fact_transactions
where date(block_timestamp) >= current_date()-90
),
program_split as (
select
t.signers[0] as wallet,
count(distinct m.program_id) as program_count,
count(distinct t.tx_id) as txs
from solana_txs t
inner join metaplex_txs m
on t.tx_id = m.tx_id
group by wallet
)
Run a query to Download Data