mariyaMore Mints
Updated 2022-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date_trunc('week',block_timestamp) as dt,
count(distinct MINT) as total_mint,
count(distinct PURCHASER) as unqpur
from solana.fact_nft_mints
--where PROGRAM_ID in ('cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ','cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
where block_timestamp>='2021-12-01'
and SUCCEEDED='TRUE'
group by 1
Run a query to Download Data