select tx_hash

from kaia.defi.ez_dex_swaps

where (token_in = '0x976232eb7eb92287ff06c5d145bd0d1c033eca58' or token_out ='0x976232eb7eb92287ff06c5d145bd0d1c033eca58')

group by 1

),

swap_event_indexes as (

select tx_hash ,

min (event_index) min_index,

max(event_index) max_index

from kaia.defi.ez_dex_swaps

where tx_hash in (select * from swap_txns )

group by 1

),

swap_from as (

select

tx_hash,

BLOCK_TIMESTAMP::date date ,

SYMBOL_IN ,

AMOUNT_IN,

AMOUNT_IN_USD,

PLATFORM,

ORIGIN_FROM_ADDRESS trader

from kaia.defi.ez_dex_swaps left join swap_event_indexes using (tx_hash)

where event_index = min_index

and tx_hash in (select * from swap_txns )

),

swap_to as (

select

tx_hash,

SYMBOL_OUT ,

AMOUNT_OUT,

AMOUNT_OUT_USD,

from kaia.defi.ez_dex_swaps left join swap_event_indexes using (tx_hash)

where event_index = max_index

and tx_hash in (select * from swap_txns )