0xaimanMonthly Aurorian NFT Purchase Volume
    Updated 2023-04-13

    with raw as (with k as (select mint -- count(distinct CONTRACT_ADDRESS)
    from solana.core.dim_nft_metadata

    where project_name ='Aurory')

    select block_timestamp, purchaser, k.mint from solana.core.fact_nft_sales m inner join k on m.mint=k.mint)


    select date_trunc('month',block_timestamp) as date, count(distinct mint ) as volume
    from raw
    group by 1 order by 1
    limit 100
    Run a query to Download Data