fb3ce38c-7bfe-475c-bca8-3f1e44ae80a62023-02-22 04:24 PM copy
    Updated 2023-02-23

    SELECT COUNT(*) total_volume,
    SUM(price) gross_sales,
    DATE_TRUNC('month',block_timestamp) block_timestamp

    FROM flow.core.ez_nft_sales

    WHERE nft_collection ='A.0b2a3299cc857e29.TopShot'
    GROUP BY DATE_TRUNC('month',block_timestamp)
    ORDER BY DATE_TRUNC('month',block_timestamp) DESC
    LIMIT 100;


    Run a query to Download Data