alitaslimiSwaps Over Time
    Updated 8 hours ago
    with
    -------------------- Avalanche --------------------
    avalanche_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'
    else platform
    end as dex,
    pool_name,
    symbol_in,
    symbol_out,
    case
    when amount_in_usd is null then amount_out_usd
    when amount_out_usd is null then amount_in_usd
    else (amount_in_usd + amount_out_usd) / 2
    end as amount_usd
    from
    avalanche.defi.ez_dex_swaps
    where
    token_in = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'
    or token_out = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'
    ),
    -------------------- Ethereum --------------------
    ethereum_swaps as (
    select
    block_timestamp,
    tx_hash,
    origin_from_address as swapper,
    case platform
    Last run: about 8 hours agoAuto-refreshes every 12 hours
    Date
    Blockchain
    Swaps
    Swappers
    Volume
    1
    2025-03-14 00:00:00.000Avalanche7525322166.42
    2
    2025-03-14 00:00:00.000Ethereum116621411307.225
    3
    2025-03-13 00:00:00.000Avalanche7833799831.665
    4
    2025-03-13 00:00:00.000Ethereum187772986398.13
    5
    2025-03-12 00:00:00.000Avalanche13128391019.75
    6
    2025-03-12 00:00:00.000Ethereum161781502363.2
    7
    2025-03-11 00:00:00.000Avalanche19642366720.33
    8
    2025-03-11 00:00:00.000Ethereum170822527904.635
    9
    2025-03-10 00:00:00.000Avalanche13227351700.915
    10
    2025-03-10 00:00:00.000Ethereum177863243582.69
    11
    2025-03-09 00:00:00.000Avalanche9618169379.645
    12
    2025-03-09 00:00:00.000Ethereum8650670347.265
    13
    2025-03-08 00:00:00.000Avalanche631631987.895
    14
    2025-03-08 00:00:00.000Ethereum81393776276.93
    15
    2025-03-07 00:00:00.000Avalanche13735310681.16
    16
    2025-03-07 00:00:00.000Ethereum159752401035.23
    17
    2025-03-06 00:00:00.000Avalanche17435376154.34
    18
    2025-03-06 00:00:00.000Ethereum149722217548.985
    19
    2025-03-05 00:00:00.000Avalanche18655335434.035
    20
    2025-03-05 00:00:00.000Ethereum174812953210.235
    62
    3KB
    4s