fb3ce38c-7bfe-475c-bca8-3f1e44ae80a6Cryptoys Sales Aggregates_Day
    Updated 2022-12-19
    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.core.ez_nft_sales

    WHERE NFT_COLLECTION ='A.ca63ce22f0d6bdba.Cryptoys'

    GROUP BY date

    ORDER BY date DESC