aureasarsanedesice blue 3
    Updated 2025-02-11
    SELECT
    PLATFORM_NAME,
    COUNT(*) AS sales_count,
    SUM(TOTAL_PRICE_USD) AS total_volume_usd
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    PROJECT_NAME = 'Ice Blue' AND BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
    GROUP BY
    PLATFORM_NAME
    ORDER BY
    total_volume_usd DESC
    Last run: 3 months ago
    PLATFORM_NAME
    SALES_COUNT
    TOTAL_VOLUME_USD
    1
    Mercato29255.825214942
    2
    Wapal652.07738
    2
    51B
    2s