tx_hash,

block_timestamp,

nvl(amount_in_usd, amount_out_usd) as amount_usd,

origin_from_address as swapper,

case

when platform ilike 'kyberswap%' then 'kyberswap'

when platform ilike 'pancakeswap%' then 'pancakeswap'

when platform ilike 'trader-joe%' then 'trader-joe'

when platform ilike 'hashflow%' then 'hashflow'

when platform ilike 'dodo%' then 'dodo'

else platform

end as platform

from ethereum.defi.ez_dex_swaps

where amount_usd <= 1e6

and platform not ilike 'uniswap%'

),

uniswap_users as (

select distinct origin_from_address as swapper from ethereum.defi.ez_dex_swaps

where (

tx_hash IN (

SELECT DISTINCT tx_hash

FROM ethereum.core.ez_decoded_event_logs

WHERE origin_to_address in ('0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad', '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b')

)

),

fee_applied_users as (

select distinct origin_from_address as swapper from ethereum.defi.ez_dex_swaps

where block_timestamp >= '2023-10-17'

AND (

tx_hash IN (