MLDZMNtop_nfts2
Updated 2023-04-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
SIGNERS[0] as deployer,
count(distinct tx_id) as no_mints,
count(distinct INSTRUCTION:accounts[1]) as no_minter,
no_mints/no_minter as average_mint_minter,
no_mints/count(distinct date_trunc(day, block_timestamp)) as average_mint_day,
no_minter/count(distinct date_trunc(day, block_timestamp)) as average_minter_day
from solana.core.fact_events
where PROGRAM_ID ='BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
and SUCCEEDED ='TRUE'
and BLOCK_TIMESTAMP>='2023-04-06'
group by 1
order by 3 desc
limit 10
Run a query to Download Data