victor-sanzcapdetVolume Impact by Platform
    Updated 2024-12-23
    SELECT
    platform,
    DATE(et.block_timestamp) AS date,
    SUM(et.amount_in_usd) AS daily_volume_usd
    FROM
    aptos.defi.ez_dex_swaps AS et
    JOIN
    aptos.core.dim_tokens AS dt ON et.token_in = dt.token_address
    WHERE
    dt.symbol = 'doodoo'
    AND et.block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
    GROUP BY
    platform, date
    ORDER BY
    date, daily_volume_usd DESC;