Updated 12 hours ago
    SELECT
    PLATFORM_NAME,
    SUM(TOTAL_PRICE_USD) AS total_volume_usd,
    COUNT(*) AS total_sales,
    SUM(PLATFORM_FEE_USD) AS total_platform_fees
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
    GROUP BY
    PLATFORM_NAME
    ORDER BY
    total_volume_usd DESC
    Last run: about 12 hours ago
    PLATFORM_NAME
    TOTAL_VOLUME_USD
    TOTAL_SALES
    TOTAL_PLATFORM_FEES
    1
    Wapal6521.480224418147597.82219805
    2
    Mercato2277.859784754201130.674362312
    3
    BlueMove29.94015695780.7432648965
    4
    Topaz2.963767448140.1862709004
    4
    167B
    5s