Query editor
with borrows_openTrove as (select"_LUSDAmount"/1e18 as amount,call_block_timefrom liquity."BorrowerOperations_call_openTrove"where call_success = true),borrows_adjustTrove as (select"_LUSDChange"/1e18 as amount,call_block_timefrom liquity."BorrowerOperations_call_adjustTrove"where call_success = trueand "_LUSDChange" > 0and "_isDebtIncrease"= true),borrows as (select * from borrows_openTroveunionselect * from borrows_adjustTrove),weekly_borrows as (selectdate_trunc('week', "call_block_time") as week,sum(amount) as borrowedfrom borrowsgroup by weekorder by week),troveDebts as (select_borrower,evt_block_time,_debt/1e18 as _debtfrom liquity."BorrowerOperations_evt_TroveUpdated"where operation in (0,2)order by evt_block_time desc),repays_closeTrove as (select(select _debt from troveDebts td where td._borrower = tc._borrower limit 1) as amount,evt_block_time as call_block_timefrom liquity."BorrowerOperations_evt_TroveUpdated" tcwhere tc.operation = 1),repays_adjustTrove as (select"_LUSDChange"/1e18 as amount,call_block_timefrom liquity."BorrowerOperations_call_adjustTrove"where call_success = trueand "_LUSDChange" > 0and "_isDebtIncrease"= false),repays as (select * from repays_closeTroveunionselect * from repays_adjustTrove