ola12 movement between dexs
    Updated 2024-07-17
    with t1 as (

    (SELECT
    block_timestamp,
    'Ethereum' as chain,
    case
    when platform ilike '%hashflow%' then 'hashflow'
    when platform ilike '%kyberswap%' then 'kyberswap'
    when platform ilike '%joe%' then 'trader joe'
    when platform ilike '%uniswap%' then 'uniswap'
    when platform ilike '%pancakeswap%' then 'pancakeswap'
    when platform ilike '%dodo%' then 'dodo'
    else platform
    end as dex,
    origin_from_address,
    amount_in_usd
    from
    avalanche.defi.ez_dex_swaps
    )

    union all

    (SELECT
    block_timestamp,
    'Arbitrum' as chain,
    case
    when platform ilike '%camelot%' then 'camelot'
    when platform ilike '%dodo%' then 'dodo'
    when platform ilike '%hashflow%' then 'hashflow'
    when platform ilike '%kyberswap%' then 'kyberswap'
    when platform ilike '%joe%' then 'trader joe'
    when platform ilike '%uniswap%' then 'uniswap'
    when platform ilike '%zyberswap%' then 'zyberswap'
    else platform
    end as dex,
    origin_from_address,
    QueryRunArchived: QueryRun has been archived