boomer77GP Pylon
Updated 2021-11-03
9
1
2
3
4
›
⌄
select date_trunc('day', block_timestamp) as dt, sum(msg_value:execute_msg:send:amount/1e6) as amount_deposit, sum(amount_deposit) over (order by dt ROWS BETWEEN unbounded preceding and current row) as cumulative_deposit
from terra.msgs
where msg_value:contract::string = 'terra126zhrrpkckjs82elgutz5qmqa4zjndfwk5dr2t' and tx_status = 'SUCCEEDED'
group by 1
Run a query to Download Data