mariyaUnique buyer growth rate
    Updated 2022-04-23
    select
    date_trunc('week',block_timestamp) as weekly ,
    case when program_id in ('cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ','cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
    then 'minted via Metaplex Candy Machine'
    else 'other'
    end as type ,
    count ( DISTINCT purchaser ) as unique_purchasers
    from solana.fact_nft_mints

    where block_timestamp::date >= '2021-12-01'
    and succeeded = true
    group by 1,2