block_timestamp,

tx_hash,

ORIGIN_FROM_ADDRESS as borrower,

event_inputs:fraction/1e18 as borrow_amount

from flipside_prod_db.ethereum_core.fact_event_logs

where contract_address = lower('0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1')

and event_name = 'LogAddAsset'),

total_borrowed as (select borrower, sum(borrow_amount) as sum_borrow

from borrow_actions

group by borrower),

repay_actions as (select

block_timestamp,

tx_hash,

ORIGIN_FROM_ADDRESS as borrower,

event_inputs:fraction/1e18 as repay_amount

from flipside_prod_db.ethereum_core.fact_event_logs

where contract_address = lower('0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1')

and event_name = 'LogRemoveAsset'),

total_repay as (select borrower, sum(repay_amount) as sum_repay

from repay_actions

group by borrower),

net_borrowings as (

select * from total_borrowed

left join total_repay using (borrower)

),

final_net_borrowings as (select *,

iff(sum_repay is null, 0, sum_repay) as new_sum_repay,

sum_borrow - new_sum_repay as net_borrow