headitmanagerunique wallet purchases chart
    Updated 2022-03-29
    with degods_mint as
    (
    select distinct mint from solana.dim_nft_metadata where token_name='DeGods'
    )
    , degods_purchaser as
    (
    select sum(sales_amount) as amount,purchaser
    from
    solana.fact_nft_sales
    inner join degods_mint
    on solana.fact_nft_sales.mint=degods_mint.mint
    where
    block_timestamp::date >= '2022-01-01'
    and program_id in ('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    group by purchaser
    )

    select * from degods_purchaser




    Run a query to Download Data