Updated 5 days ago
    SELECT
    PLATFORM_NAME,
    COUNT(*) AS sales_count,
    SUM(TOTAL_PRICE_USD) AS total_volume_usd
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    PROJECT_NAME = 'Amnis Draconian' AND BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
    GROUP BY
    PLATFORM_NAME
    ORDER BY
    total_volume_usd DESC


    Last run: 5 days ago
    PLATFORM_NAME
    SALES_COUNT
    TOTAL_VOLUME_USD
    1
    Wapal19270.90025
    2
    Mercato120.252232
    2
    48B
    1s