alitaslimiCross Chain Swaps Overview
    Updated 2024-10-08
    with
    ------------------------- Arbitrum -------------------------
    arbitrum as (
    select
    block_timestamp,
    tx_hash,
    origin_from_address as swapper,
    event_index,
    platform as dex,
    pool_name,
    token_in,
    token_out,
    symbol_in,
    symbol_out,
    amount_in,
    amount_out,
    amount_in_usd,
    amount_out_usd,
    (amount_in_usd + amount_out_usd) / 2 as amount_usd
    from
    arbitrum.defi.ez_dex_swaps
    ),
    ------------------------- Avalanche -------------------------
    avalanche as (
    select
    block_timestamp,
    tx_hash,
    origin_from_address as swapper,
    event_index,
    platform as dex,
    pool_name,
    token_in,
    token_out,
    symbol_in,
    symbol_out,
    amount_in,
    Auto-refreshes every 6 hours
    QueryRunArchived: QueryRun has been archived