alitaslimiSwaps Daily
    Updated 2025-02-19
    with
    -------------------- Prices --------------------
    prices as (
    select
    hour::date as day,
    avg(price) as price
    from
    crosschain.price.ez_prices_hourly
    where
    symbol = 'BTC.b'
    and hour::date between (current_date - 31) and (current_date - 1)
    group by
    day
    ),
    -------------------- Arbitrum --------------------
    arbitrum as (
    select
    block_timestamp::date as date,
    count(distinct tx_hash) as transactions,
    count(distinct sender) as swappers,
    sum(amount_out_usd) as volume
    from
    arbitrum.defi.ez_dex_swaps
    where
    block_timestamp::date between (current_date - 31) and (current_date - 1)
    and token_out = '0x2297aebd383787a160dd0d9f71508148769342e3'
    group by
    date
    ),
    -------------------- Avalanche --------------------
    avalanche as (
    select
    block_timestamp::date as date,
    count(distinct tx_hash) as transactions,
    count(distinct sender) as swappers,
    sum(amount_out_usd) as volume
    Last run: 25 days ago
    Date
    Blockchain
    Swaps
    Swappers
    Volume
    1
    2025-02-18 00:00:00.000Arbitrum55127243.26
    2
    2025-02-18 00:00:00.000Avalanche47785112913240.41
    3
    2025-02-17 00:00:00.000Arbitrum78112263.71
    4
    2025-02-17 00:00:00.000Avalanche42874719089182.59
    5
    2025-02-16 00:00:00.000Arbitrum269754.37
    6
    2025-02-16 00:00:00.000Avalanche43384512518526.67
    7
    2025-02-15 00:00:00.000Arbitrum20820439.6
    8
    2025-02-15 00:00:00.000Avalanche29614210718122.56
    9
    2025-02-14 00:00:00.000Arbitrum39102097.29
    10
    2025-02-14 00:00:00.000Avalanche38545112836497.4
    11
    2025-02-13 00:00:00.000Arbitrum3593038.9
    12
    2025-02-13 00:00:00.000Avalanche34154313921207.59
    13
    2025-02-12 00:00:00.000Arbitrum541267038.04
    14
    2025-02-12 00:00:00.000Avalanche45585018324330.9
    15
    2025-02-11 00:00:00.000Arbitrum34102042.65
    16
    2025-02-11 00:00:00.000Avalanche35974614556927.9
    17
    2025-02-10 00:00:00.000Arbitrum4012108487.11
    18
    2025-02-10 00:00:00.000Avalanche37004816908843.47
    19
    2025-02-09 00:00:00.000Arbitrum511357504.29
    20
    2025-02-09 00:00:00.000Avalanche33524311989630.42
    62
    3KB
    22s