flipside

    General
    Afonso_DiazGeneral
    Updated 2025-05-22
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    swapper,
    platform,
    nvl(amount_in_usd, amount_out_usd) as amount_usd,
    symbol_in,
    symbol_out,
    token_in,
    token_out
    from
    aptos.defi.ez_dex_swaps
    where
    amount_usd < 1e6
    )

    select
    platform,
    count(distinct tx_hash) as swaps,
    count(distinct swapper) as swappers,
    sum(amount_usd) as volume_usd,
    avg(amount_usd) as average_amount_usd
    from main
    group by 1

    Last run: 11 days ago
    PLATFORM
    SWAPS
    SWAPPERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    		hippo2136900166677285907337.19857387.250184383
    2
    		cetus1257962153383711915.130772.041031124
    3
    		tsunami874824051207584.43781373138.041202311
    4
    		auxexchange2169519154231229670061.30331879.567659967
    5
    		pancake132081626991311400643233.4962982.754034578
    6
    		liquidswap2253014913999102860684993.82378100.949862264
    7
    		batswap2850742811414254865.39101643.809361834
    8
    		sushi2309096171728580387552.639064235.621675645
    9
    		animeswap14415521336677341873.206812533.491783659
    10
    		cellana142735506142794355774603.76051241.912122361
    11
    		thala88162956348323914200509.99026304.047879417
    11
    624B
    13s