case when action='Borrow' then amount_usd

when action ='Repay' then -amount_usd

end as total_loan,

case when sum(total_loan) over(partition by origin_from_address, lending_pool, symbol order by block_timestamp) <= 0 then 0

else sum(total_loan) over(partition by origin_from_address, lending_pool, symbol order by block_timestamp ) end as current_loan,

row_number () over(partition by origin_from_address, lending_pool, symbol order by block_timestamp) as event_index

from ethereum.sushi.ez_borrowing

group by origin_from_address,symbol,total_loan,block_timestamp,lending_pool,tx_hash,action)

select *

from outstanding