select

tx_hash,

block_timestamp,

old_owner_id as sender_address,

amount_raw as sent_amount,

token_id as sent_token

from near.defi.fact_intents

where log_event = 'mt_transfer'

and RECEIPT_SUCCEEDED = TRUE

qualify row_number() over (partition by tx_hash, log_index order by log_event_index desc) = 1

),

swap_details as (

select

tx_hash,

block_timestamp,

sender_address,

sent_amount,

split(sent_token, ':')[1] :: string as input_token

from sender_transactions

),

token_metadata as (

select *

from $query('64f376d0-8a1f-4ccf-8516-cae9c8067b49')

),

adjusted_swaps as (

select

s.tx_hash,

s.block_timestamp,

s.sender_address,

s.input_token,

t.symbol as input_symbol,

s.sent_amount / pow(10, t.decimal) as adjusted_input

from swap_details s,

lateral (select * from token_metadata where token = s.input_token) t

),