main as (

select

tx_hash,

block_timestamp,

least(amount_in_usd, amount_out_usd) as amount_usd,

swapper,

symbol_in,

symbol_out

from

aptos.defi.ez_dex_swaps

where

platform = 'sushi'

),

first_swaps as (

select

swapper,

min(block_timestamp) as first_swap_time

from

main

group by

swapper

),

new_swappers as (

select

m.swapper,

m.block_timestamp

from

main m

join first_swaps f on m.swapper = f.swapper and m.block_timestamp = f.first_swap_time