fb3ce38c-7bfe-475c-bca8-3f1e44ae80a6DimensionX Sales Aggregates_Day
    Updated 2024-09-03
    SELECT
    BLOCK_TIMESTAMP::DATE AS date,
    SUM(PRICE) AS total_sales,
    COUNT(DISTINCT TX_ID ) AS sales_volume,
    SUM(Price)/COUNT(DISTINCT TX_ID) Avg_sale_price,
    COUNT(DISTINCT BUYER) unique_wallet_buyers,
    COUNT(DISTINCT SELLER) unique_wallet_sellers
    FROM flow.nft.ez_nft_sales

    WHERE NFT_COLLECTION ='A.e3ad6030cbaff1c2.DimensionX'
    AND date >'2022-09-07'
    GROUP BY date

    ORDER BY date DESC

    QueryRunArchived: QueryRun has been archived