flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Angel HALO token Daily Price
nits
Angel HALO token Daily Price
Updated 2022-03-16
Copy Reference
Fork
9
1
2
3
4
›
⌄
SELECT
date
(
block_timestamp
)
as
day
,
avg
(
msg_value
:
execute_msg
:
swap
:
belief_price
)
as
avg_price
from
terra
.
msgs
where
msg_value
:
contract
=
'terra1yjg0tuhc6kzwz9jl8yqgxnf2ctwlfumnvscupp'
and
contains
(
msg_value
,
'swap'
)
GROUP
by
1
Results
Run a query to Download Data