swaps as (

select

block_timestamp,

tx_hash,

origin_from_address as swapper,

event_index,

case platform

when 'balancer' then 'Balancer'

when 'curve' then 'Curve'

when 'fraxswap' then 'Fraxswap'

when 'gmx' then 'GMX'

when 'hashflow' then 'Hashflow'

when 'kyberswap-v1' then 'KyberSwap'

when 'kyberswap-v2' then 'KyberSwap'

when 'pangolin' then 'Pangolin'

when 'platypus' then 'Platypus'

when 'sushiswap' then 'Sushiswap'

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,

split_part(pool_name, ' ', 1) as 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

avalanche.defi.ez_dex_swaps