victor-sanzcapdetTop Associated Platforms by Trading Volume for GUI
    Updated 2025-04-18
    SELECT
    platform,
    SUM(et.amount_in_usd) AS total_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 = 'GUI'
    AND et.block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
    GROUP BY
    platform
    ORDER BY
    total_volume_usd DESC
    LIMIT 5;

    Last run: 10 days ago
    PLATFORM
    TOTAL_VOLUME_USD
    1
    pancake60650.223160158
    2
    thala1745.563030025
    3
    cellana1514.094355181
    4
    liquidswap939.752847211
    5
    animeswap0.00000452
    5
    135B
    2s