(SELECT *

FROM terra.msgs

WHERE msg_type = 'wasm/MsgExecuteContract'

AND (msg_value:contract::string = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

OR msg_value:execute_msg:send:contract::string ='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s')

AND (msg_value:execute_msg:deposit_stable IS NOT NULL

OR msg_value:execute_msg:send:msg:redeem_stable IS NOT NULL)

AND TX_STATUS = 'SUCCEEDED' ),

deposits AS

(SELECT to_date(block_timestamp) AS date,

'Deposit' AS TYPE,

SUM(msg_value:coins[0]:amount::float / POW(10, 6)) AS amount

FROM anchor_deposits_withdraws

WHERE msg_value:execute_msg:deposit_stable IS NOT NULL

GROUP BY 1) ,

stable_redeems AS

(SELECT to_date(block_timestamp) AS date,

'Withdrawal' AS TYPE,

SUM(msg_value:execute_msg:send:amount::float / POW(10, 6)) AS amount

FROM anchor_deposits_withdraws

WHERE msg_value:execute_msg:send:msg:redeem_stable IS NOT NULL

GROUP BY 1)

SELECT *

(SELECT date, SUM(net_amount) OVER (

ORDER BY date) AS total_deposits

FROM

(SELECT dp.date,

dp.amount - sr.amount AS net_amount

FROM deposits dp

JOIN stable_redeems sr ON dp.date = sr.date))

order by date