shahdadi-9ptm8YUntitled Query
Updated 2022-02-11
99
1
2
3
4
5
6
7
8
9
10
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