TX_COUNT | |
|---|---|
1 | 23405 |
andurilMetaplex Total Txs - 90 Days
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
›
⌄
with metaplex_txs as
(
select
tx_id,
program_id
from solana.core.fact_events
where
date(block_timestamp) between current_date()-90 and current_date()-1
and
succeeded = 'TRUE' and
program_id IN
(
'qntmGodpGkrM42mN68VCZHXnKqDCT8rdY23wFcXCLPd',
'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a',
'faircnAB9k59Y4TXmLabBULeuTLgV7TkGMGNkjnA15j',
'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk',
'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ',
'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ')
)
select count(distinct t.tx_id) tx_count
from
solana.core.fact_transactions t
inner join metaplex_txs m
on t.tx_id = m.tx_id
where
date(t.block_timestamp) between current_date()-91 and current_date()-1
Last run: about 2 months ago
1
9B
473s