andurilTop compression deployers
Updated 2023-03-23
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 compression_txs as
(
select
distinct tx_id
from
solana.core.fact_events
where
date(block_timestamp) >= '2023-03-10'
and program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
)
select
signers[0] as fee_payer,
count(distinct tx_id) as mints
from solana.core.fact_transactions
inner join compression_txs
using(tx_id)
where
date(block_timestamp) >= '2023-03-10'
and (log_messages[1] = 'Program log: Instruction: MintToCollectionV1'
OR log_messages[1] = 'Program log: Instruction: MintV1'
)
group by 1
order by 2 desc
Run a query to Download Data