andurilNFT Mints Primary vs Secondary
Updated 2022-10-09
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
29
›
⌄
⌄
select
'CMV2 Primary Mints' as type,
--date(block_timestamp) as date,
count(distinct tx_id) as mints,
l.label as label
FROM solana.core.fact_nft_mints m
left join solana.core.dim_labels l
on m.mint = l.address
WHERE mint_currency = 'So11111111111111111111111111111111111111111'
AND block_timestamp::DATE >= '2022-01-01'
and program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ'
--and label is not null
group by label
order by mints desc
/*
union
select
'CMV2 Secondary Mints' as type,
date(block_timestamp) as date,
count(distinct tx_id) as mints
FROM solana.core.fact_nft_mints
WHERE mint_currency <> 'So11111111111111111111111111111111111111111'
AND block_timestamp::DATE >= '2022-06-01'
and program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ'
group by date
*/
Run a query to Download Data