Updated 2023-08-02

    SELECT
    COUNT(*) AS Txn_Volume,
    SUM(price) AS Net_Sales,
    DATE_TRUNC('month', block_timestamp) block_timestamp,
    COUNT(DISTINCT Buyer) total_buyers,
    COUNT(DISTINCT Seller)total_sellers
    FROM
    flow.core.ez_nft_sales

    WHERE NFT_COLLECTION ='A.329feb3ab062d289.UFC_NFT'
    GROUP BY
    DATE_TRUNC('month', block_timestamp)
    ORDER BY
    DATE_TRUNC('month', block_timestamp) DESC;






    Run a query to Download Data