messariSolana NFT mints & initial sales
Updated 2023-01-15
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
30
31
32
33
34
35
36
›
⌄
with
base as (
select
date(block_timestamp) as date,
program_id,
mint,
mint_currency,
mint_price,
purchaser
from
solana.core.fact_nft_mints
where
succeeded = TRUE
and date < DATE('2023-01-01')
and date >= DATE('2022-01-01')
)
select
date,
case
when program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ' then 'candyV2'
when program_id = 'CndyV3LdqHUfDLmE5naZjVN8rBZz4tqhdefbAnjHG3JR' then 'candyV3'
when program_id = 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ' then 'candyV1'
when program_id = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s' then 'metadata'
when program_id = '5WTCguyGQDrFosVn8M9JynwdoRpQJUPuzaembMwug35r' then 'unkown old candy machine'
when program_id = 'HWeQ1ntizxmbMwVHemf9zncf2h6RTTfLiuzbjD9wAN9e' then 'unkown program'
else program_id
end as program_id,
case
when mint_currency = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
when mint_currency = 'So11111111111111111111111111111111111111111' then 'SOL'
else 'not_labeled'
end as mint_currency,
sum(mint_price) as primary_volume,
count(purchaser) as mints,
count(distinct purchaser) as unique_minters,
count(distinct mint) as unique_collections
Run a query to Download Data