thejoycegenerous-sapphire
    Updated 2024-11-17
    SELECT
    PLATFORM_NAME,
    COUNT(*) AS total_nft_sales,
    SUM(PRICE) AS total_sales_volume_near,
    SUM(PRICE_USD) AS total_sales_volume_usd,
    COUNT(DISTINCT BUYER_ADDRESS) AS unique_buyers
    FROM
    near.nft.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE)
    GROUP BY
    PLATFORM_NAME
    ORDER BY
    total_sales_volume_usd DESC;