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'

when 'woofi' then 'WOOFi'

else platform

end as dex,

pool_name,

token_in as from_token,

token_out as to_token,

symbol_in as from_symbol,

symbol_out as to_symbol,

case

when amount_in_usd - amount_out_usd > 100 then amount_out_usd

when amount_in_usd - amount_out_usd < -100 then amount_in_usd

else (amount_in_usd + amount_out_usd) / 2

end as amount_usd,

iff(amount_in_usd - amount_out_usd between -10 and 10, (amount_out_usd - amount_in_usd) / amount_out_usd * 100, 0) as slippage

from

avalanche.defi.ez_dex_swaps

where

token_in in (

'0xc891eb4cbdeff6e073e859e987815ed1505c2acd', -- EURC

'0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0b', -- VEUR

'0x228a48df6819ccc2eca01e2192ebafffdad56c19' -- VCHF

)

or