flipside

    dex volume by including originator
    theericstonedex volume by including originator
    Updated 2024-01-29
    select
    swaps.platform,
    coalesce(labs.label,'direct') as router,
    count(distinct(origin_from_address)) as n_users,
    sum(coalesce(amount_in_usd,0)) as volume_usd
    from ethereum.defi.ez_dex_swaps swaps
    left join ethereum.core.dim_labels labs
    on swaps.sender = labs.address
    where
    block_timestamp > current_date - 7
    group by platform, router
    order by n_users desc;

    Last run: about 1 year ago
    PLATFORM
    ROUTER
    N_USERS
    VOLUME_USD
    1
    		uniswap-v2uniswap117618347044190.71
    2
    		uniswap-v3uniswap896081489075061.29
    3
    		uniswap-v2direct41812366556417.65
    4
    		uniswap-v3direct242064148488160.44
    5
    		uniswap-v21inch2293828877007.96
    6
    		uniswap-v31inch22102104066822.29
    7
    		uniswap-v20x2040431492431.14
    8
    		uniswap-v30x14633105516951.43
    9
    		sushiswap1inch60473255864.1
    10
    		sushiswapdirect520037223001.6
    11
    		curvedirect41251053304492.94
    12
    		pancakeswap-v3pancakeswap217728643536.03
    13
    		balancerdirect2176298242985.88
    14
    		pancakeswap-v3direct2108143973220.36
    15
    		sushiswap0x20051924884.53
    16
    		uniswap-v2paraswap196511511174.54
    17
    		sushiswapsushiswap10774209597.68
    18
    		shibaswapdirect8482873385.16
    19
    		dodo-v2direct79439985833.83
    20
    		dodo-v20x715471443.75
    ...
    134
    5KB
    8s