main as (

select

tx_hash,

block_timestamp,

amount_in_usd,

amount_out_usd,

least(amount_in_usd, amount_out_usd) as amount_usd,

swapper,

symbol_in,

symbol_out

from

aptos.defi.ez_dex_swaps

where

platform = 'sushi'

),

swapper_migration as (

select

swapper,

platform,

count(distinct tx_hash) as swap_count

from

aptos.defi.ez_dex_swaps

where

platform != 'sushi'

group by

swapper, platform

),

multi_platform_swappers as (

select

m.swapper,

count(distinct s.platform) as platform_count

from