shahdadi-9ptm8YUntitled Query
    Updated 2022-02-11
    select
    date_trunc('month',block_timestamp) as monthly,
    sum(msg_value:coins[0]:amount) / 1e6 as ust_deposited,
    sum(ust_deposited) over (order by monthly) as cumulative_ust_deposited
    from terra.msgs
    where msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'
    and msg_value:execute_msg:deposit_stable IS NOT NULL
    and tx_status = 'SUCCEEDED'
    AND block_timestamp >= '2021-09-01'
    group by monthly

    Run a query to Download Data