bachiangel - restore earth
Updated 2021-12-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
⌄
/*select
date_trunc('hour', block_timestamp) as date, count(tx_id) as tran_count,
sum(msg_value:coins[0]:amount/POW(10,6)) as volume_uusd,
sum(volume_uusd) over (order by date asc rows between unbounded preceding and current row) as running
From terra.msgs
where msg_value:contract = 'terra19cevhng6nunl7gmc90sph0syuqyvtqn7mlhwz0'
and tx_status = 'SUCCEEDED'
and msg_value:execute_msg:zap_into_strategy is not null
and block_timestamp > CURRENT_DATE - 45
group by 1
order by 1 desc*/
select
msg_value:sender::string as sender,
sum(msg_value:coins[0]:amount/Pow(10,6)) as volume_ust,
sum(msg_value:coins[0]:amount) as volume_uusd,
date(block_timestamp) as date
from terra.msgs
WHERE msg_value:contract = 'terra19cevhng6nunl7gmc90sph0syuqyvtqn7mlhwz0' --angel charity wallet
--AND block_timestamp >= CURRENT_DATE - 360
and tx_status = 'SUCCEEDED'
group by 1,4
--SELECT * FROM terra.msgs WHERE msg_value:contract = 'terra19cevhng6nunl7gmc90sph0syuqyvtqn7mlhwz0' limit 500
Run a query to Download Data