mariyaMore Mints
    Updated 2022-04-22
    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