bachiFlow NFT Sales
    Updated 2022-09-25
    SELECT
    date(block_timestamp) as day,
    COUNT(DISTINCT nft_id) as no_of_sales,
    round(sum(price),2) as total_sales_volume,
    round(avg(price),2) as average_sales_volume,
    COUNT(DISTINCT buyer) as no_of_buyers,
    count(distinct seller) as no_of_sellers
    FROM flow.core.ez_nft_sales
    where tx_succeeded = true
    GROUP BY day
    order by day desc
    Run a query to Download Data