with deposits as (select

date_trunc('hour', block_timestamp) as date,

sum(msg_value:coins[0]:amount/POW(10,6)) as deposit

from terra.msgs

where msg_value:contract::string = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

and msg_value:execute_msg:deposit_stable IS NOT NULL

and tx_status = 'SUCCEEDED'

group by 1 )

select

date,

sum(deposit) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) as deposits

from deposits

order by 1 asc