victor-sanzcapdetDaily platform fees (USD)
    Updated 3 days ago
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DAY,
    SUM(PLATFORM_FEE_USD) AS DAILY_PLATFORM_FEES
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    PROJECT_NAME = 'The Loonies'
    AND block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
    GROUP BY
    DAY
    ORDER BY
    DAY;

    Last run: 3 days ago
    DAY
    DAILY_PLATFORM_FEES
    1
    2024-12-31 00:00:00.000110.015388633
    2
    2025-01-01 00:00:00.00053.9177535
    3
    2025-01-02 00:00:00.000176.2108545
    4
    2025-01-03 00:00:00.00046.684305
    5
    2025-01-04 00:00:00.00040.97342025
    6
    2025-01-05 00:00:00.00069.320424
    7
    2025-01-06 00:00:00.00059.009367
    8
    2025-01-07 00:00:00.00026.410241898
    8
    317B
    3s