mariyaNumber of NFTs minted in the last week
Updated 2022-04-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 mints as ( select
case when program_id in ('cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ','cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
then 'minted via Metaplex Candy Machine'
else 'other'
end as type ,
count ( mint) as mints
from solana.fact_nft_mints
where block_timestamp::date >= CURRENT_DATE - 7
and succeeded = true
group by 1
),
total_mints as (
select
count ( mint) as mints
from solana.fact_nft_mints
where block_timestamp::date >= CURRENT_DATE - 7
and succeeded = true
),
all_ as (
select * from mints
UNION
select 'total' as type, * from total_mints
)
select * from all_
Run a query to Download Data