mariyaNumber of NFTs minted in the last week
    Updated 2022-04-23
    with mints as ( select
    case when program_id in ('cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ','cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
    then 'minted via Metaplex Candy Machine'
    else 'other'
    end as type ,
    count ( mint) as mints
    from solana.fact_nft_mints
    where block_timestamp::date >= CURRENT_DATE - 7
    and succeeded = true
    group by 1
    ),
    total_mints as (
    select
    count ( mint) as mints
    from solana.fact_nft_mints
    where block_timestamp::date >= CURRENT_DATE - 7

    and succeeded = true
    ),
    all_ as (
    select * from mints
    UNION
    select 'total' as type, * from total_mints

    )
    select * from all_
    Run a query to Download Data