Updated 5 days ago
    SELECT
    SUM(AMOUNT_IN_USD) AS total_volume_usd,
    COUNT(*) AS total_swaps,
    COUNT(DISTINCT SWAPPER) AS unique_swappers
    FROM
    aptos.defi.ez_dex_swaps
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
    Last run: 5 days ago
    TOTAL_VOLUME_USD
    TOTAL_SWAPS
    UNIQUE_SWAPPERS
    1
    32455611.2145161133805014881
    1
    34B
    2s