SELECT

DATE_TRUNC('day',block_timestamp) as block_date,

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

FROM terra.msgs

WHERE

tx_status='SUCCEEDED'

AND

msg_value:contract::string='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

AND

msg_value:execute_msg::string='{"deposit_stable":{}}'

AND

block_timestamp >= CURRENT_DATE - 90

GROUP BY 1

ORDER BY 1),

withdraws as (

SELECT

date_trunc('day',block_timestamp) as block_date,

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

FROM terra.msgs

WHERE

tx_status='SUCCEEDED'

AND

block_timestamp>=CURRENT_DATE-90

AND

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

AND

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

GROUP BY 1

ORDER BY 1)

deposits.block_date,

amount_deposited,

-amount_withdrawn,

amount_deposited-amount_withdrawn as net_deposits