feyikemiAerodrome Comp Vol
    Updated 2025-05-16
    SELECT
    INITCAP(REGEXP_REPLACE(platform, '-(v[1-3]|slipstream)$', '')) AS DEXs,
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS unique_addresses,
    COUNT(DISTINCT TX_HASH) AS trades,
    SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS total_volume
    FROM
    base.defi.ez_dex_swaps
    GROUP BY 1
    ORDER BY 4 DESC
    Last run: 13 days ago
    DEXS
    UNIQUE_ADDRESSES
    TRADES
    TOTAL_VOLUME
    1
    Aerodrome208137879329144202024385040.96
    2
    Uniswap133495002455464037185429318196.05
    3
    Pancakeswap18789965050469319402697391.07
    4
    Baseswap82684172785976934792820.72
    5
    Maverick1284716108214145636494903.15
    6
    Sushiswap1280510159414504872806695.85
    7
    Baseswap-Basex1141549171897594194718307.83
    8
    Woofi2505909692442176528373.98
    9
    Balancer4665312150253978633328.12
    10
    Dackieswap3435162637152737503504.39
    11
    Dexalot50240270635324777081.83
    12
    Swapbased2037881095260210263547.88
    13
    Alienbase3964272530677208282947.39
    14
    Curve81428332624152766533.78
    15
    Voodoo173834393192039885.26
    15
    640B
    153s