0xaimanRestore Earth
Updated 2021-12-22
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('day',block_timestamp) as date, count(msg_value:sender) as n_sender, sum(msg_value:coins[0]:amount/1000000) as tot_UST_donated,
sum(tot_UST_donated) OVER(ORDER BY date asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS UST_raised_cum
from terra.msgs
where --tx_id='ADE45473E6DAEF9F8FF9D16782367D56BB3F3F1C7FF7C5B86A5EA18EF1EC6C69' and
msg_value:contract='terra19cevhng6nunl7gmc90sph0syuqyvtqn7mlhwz0' and
msg_value:coins[0]:denom='uusd'
group by 1 order by 1
limit 100
Run a query to Download Data