0-MIDTop pools waps
    Updated 2024-02-17

    select POOL_NAME
    ,sum((AMOUNT_IN_USD+AMOUNT_OUT_USD)/2) as swap_volume
    ,count(distinct ORIGIN_FROM_ADDRESS) as swappers
    ,count(distinct TX_HASH) as swaps
    from arbitrum.defi.ez_dex_swaps
    where PLATFORM in ('camelot-v2','camelot-v3')
    and BLOCK_TIMESTAMP::date>=current_date-30
    and AMOUNT_IN_USD is not null
    and AMOUNT_OUT_USD is not null
    group by 1
    order by 4 desc
    limit 5





    Last run: about 1 year ago
    POOL_NAME
    SWAP_VOLUME
    SWAPPERS
    SWAPS
    1
    WETH-USDC421093760.8730050197395
    2
    GRAIL-WETH4467215.031388385326
    3
    WETH-ARB216391015.4451042463347
    4
    ARB-USDC75602700.07328645010
    5
    PENDLE-WETH58808115.64176438408
    5
    193B
    2s