iboo-jbj2MVStt price
Updated 2022-03-17
9
1
2
3
4
5
6
7
›
⌄
select
DATE_TRUNC('day', block_timestamp) as day,
avg(msg_value:execute_msg:swap:belief_price) as STT_price
from terra.msgs
where msg_value:contract = 'terra1m95udvvdame93kl6j2mk8d03kc982wqgr75jsr'
and msg_value:execute_msg:swap is not null and tx_status='SUCCEEDED' and block_timestamp >= CURRENT_DATE-60
group by 1
Run a query to Download Data