andurilMinting Activity
Updated 2022-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--break down by mint program
select
date(m.block_timestamp) as date,
case when l.label = 'metaplex' then 'Metaplex'
when m.program_id = 'CMZYPASGWeTz7RNGHaRJfCq2XQ5pYK6nDvVQxzkH51zb' then 'Magic Eden'
else 'Other' end as program,
count(distinct m.tx_id) as txs,
count(distinct m.purchaser) as minter_wallets
from solana.core.fact_nft_mints m
left join solana.core.dim_labels l
on m.program_id = l.address
where date(block_timestamp) between current_date()-91 and current_date()-1
group by date,program
--select * from solana.core.fact_nft_mints where date(block_timestamp) > '2022-07-20' and program_id = 'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk' limit 4
--select * from solana.core.dim_labels where address = 'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk'
Run a query to Download Data