nitsMore Mints- 2
Updated 2022-04-25
9
1
2
3
4
5
›
⌄
SELECT week(block_timestamp) as wk, count(DISTINCT tx_id) as unique_mints, sum(unique_mints) over (order by wk) as cumulative_unique_mints from solana.fact_nft_mints
where (program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ' or program_id = 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
and succeeded = 'TRUE' and block_timestamp >= '2021-12-01'
GROUP by 1
-- LIMIT 10
Run a query to Download Data