(

select * from terra.core.ez_transfers

where currency='uluna'

qualify(row_number() over (partition by sender order by block_timestamp desc)) = 1

),

last_in as

(

select * from terra.core.ez_transfers

where currency='uluna'

qualify(row_number() over (partition by RECEIVER order by block_timestamp desc)) = 1

),

comb as

(

select lin.* from last_in lin right join last_out lout

on lin.RECEIVER=lout.sender and lin.block_timestamp>lout.block_timestamp

)

select sum(amount)/1e6 as t from comb