alitaslimiSwaps DEXs Over Time
    Updated 5 days ago
    with
    -------------------- Swaps --------------------
    swaps as (
    select
    block_timestamp,
    tx_hash,
    origin_from_address as swapper,
    case platform
    when 'balancer' then 'Balancer'
    when 'curve' then 'Curve'
    when 'trader-joe-v1' then 'Trader Joe'
    when 'trader-joe-v2' then 'Trader Joe'
    when 'uniswap-v3' then 'Uniswap'
    when 'woofi' then 'WOOFi'
    else platform
    end as dex,
    pool_name,
    token_in as from_token,
    token_out as to_token,
    symbol_in as from_symbol,
    symbol_out as to_symbol,
    case
    when amount_in_usd - amount_out_usd > 100 then amount_out_usd
    when amount_in_usd - amount_out_usd < -100 then amount_in_usd
    else (amount_in_usd + amount_out_usd) / 2
    end as amount_usd,
    iff(amount_in_usd - amount_out_usd between -10 and 10, (amount_out_usd - amount_in_usd) / amount_out_usd * 100, 0) as slippage
    from
    avalanche.defi.ez_dex_swaps
    where
    token_in in (
    '0xc891eb4cbdeff6e073e859e987815ed1505c2acd', -- EURC
    '0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0b', -- VEUR
    '0x228a48df6819ccc2eca01e2192ebafffdad56c19' -- VCHF
    )
    or
    Last run: 5 days ago
    Date
    DEX
    Swaps
    Swappers
    Volume
    1
    2025-03-03 00:00:00.000Trader Joe8111181377828
    2
    2025-03-03 00:00:00.000pharaoh-v25261051150181
    3
    2025-03-03 00:00:00.000Balancer66916605
    4
    2025-03-03 00:00:00.000Uniswap541
    5
    2025-02-24 00:00:00.000Trader Joe54779830182
    6
    2025-02-24 00:00:00.000pharaoh-v221157194574
    7
    2025-02-24 00:00:00.000Balancer46109262
    8
    2025-02-24 00:00:00.000Uniswap1913641
    9
    2025-02-24 00:00:00.000WOOFi111
    10
    2025-02-17 00:00:00.000Trader Joe50967724907
    11
    2025-02-17 00:00:00.000pharaoh-v229849387128
    12
    2025-02-17 00:00:00.000Balancer3776512
    13
    2025-02-17 00:00:00.000Uniswap3314
    14
    2025-02-10 00:00:00.000pharaoh-v236347347707
    15
    2025-02-10 00:00:00.000Trader Joe1435318364
    16
    2025-02-10 00:00:00.000Balancer3894583
    17
    2025-02-10 00:00:00.000Uniswap225
    18
    2025-02-03 00:00:00.000pharaoh-v21363640845
    19
    2025-02-03 00:00:00.000Trader Joe1946228339
    20
    2025-02-03 00:00:00.000Balancer85196380
    ...
    278
    14KB
    5s