select tx_hash ,

min (event_index) min_index,

max(event_index) max_index

from kaia.defi.ez_dex_swaps

where block_timestamp::date >= '2024-01-01'

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

),

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

),

final as (

select

tx_hash ,

date BLOCK_TIMESTAMP,

SYMBOL_IN ,

SYMBOL_OUT ,

AMOUNT_IN,