bachiaurory NFT sales
    Updated 2022-07-20
    with aurory_nfts as (select * from solana.core.dim_nft_metadata where project_name = 'Aurory'
    and contract_name = 'Aurory' and Token_name = 'Aurory')

    select date(block_timestamp) as day,
    count (distinct tx_id) as no_of_sales,
    count (distinct purchaser) as no_of_buyers,
    count (distinct seller) as no_of_sellers,
    round(sum(sales_amount),2) as total_volume
    from solana.core.fact_nft_sales
    where SUCCEEDED = 'TRUE'
    and mint in (select mint from aurory_nfts)
    AND sales_amount > 0 and sales_amount is not null
    group by day
    order by day desc
    Run a query to Download Data