mariyaSolana NFT Project Feature
    Updated 2022-07-20
    with collection as (select * from solana.core.dim_nft_metadata where CONTRACT_NAME = 'Thugbirdz')
    select
    block_timestamp::date,
    min(sales_amount),
    max(sales_amount),
    avg(sales_amount),
    sum(sales_amount),
    count(distinct purchaser),
    count(distinct seller),
    count(tx_id)
    from solana.core.fact_nft_sales sales
    inner join collection on sales.mint = collection.mint
    group by block_timestamp::date
    order by block_timestamp::date asc
    Run a query to Download Data