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_swaps as (

select

block_timestamp,

tx_hash,

origin_from_address as swapper,

case platform