with swap_txns as (

select

tx_id,

signers [0] trader,

block_timestamp :: date date,

from

eclipse.core.fact_events

where

program_id = '4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12'

and SUCCEEDED = true

),

indexes as (

select

tx_id,

CAST(index || '.' || inner_index AS FLOAT) combined_index

from

swap_txns

left join eclipse.core.fact_transfers using (tx_id)

),

min_max_index as (

select

tx_id,

min (combined_index) min_index,

max (combined_index) max_index

from

indexes

group by 1

),

swap_from as (

select

tx_id,

trader,