flipside

    Aerodrome Comp Vol
    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