SELECT

msg_value:sender as s1,

sum(msg_value:execute_msg:lock_collateral:collaterals[0][1]) as amt1

FROM terra.msgs

WHERE msg_value:execute_msg:lock_collateral:collaterals[0][0] LIKE 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'

GROUP BY 1

), tab2 as (

SELECT

msg_value:sender as s2,

sum(msg_value:execute_msg:unlock_collateral:collaterals[0][1]) as amt2

FROM terra.msgs

WHERE msg_value:execute_msg:unlock_collateral:collaterals[0][0] LIKE 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'

GROUP BY 1

), tab3 as (

SELECT

s1,

CASE WHEN not amt1 - amt2 is null THEN amt1 - amt2 ELSE amt1 END

FROM tab1 LEFT outer join tab2 on tab1.s1 = tab2.s2

), tab4 as (

SELECT

sum(CASE WHEN msg_value:execute_msg:borrow_stable is not NULL THEN msg_value:execute_msg:borrow_stable:borrow_amount / 100000 WHEN msg_value:execute_msg:repay_stable is not NULL THEN msg_value:coins[0]['amount'] / -100000 end) as this1,

date_trunc('week', block_timestamp) as cd

FROM terra.msgs

WHERE msg_value:contract LIKE 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

AND msg_value:sender in (SELECT s1 FROM tab3)

GROUP BY 2

SELECT

cd,

SUM (this1) OVER (ORDER BY cd) AS RunningAgeTotal

FROM tab4