flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Mine Price over the past 90 days
princefarzam
Mine Price over the past 90 days
Updated 2022-02-10
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
AS
day
,
avg
(
price_usd
)
AS
MINE_PRICE
from
terra
.
oracle_prices
where
symbol
=
'MINE'
and
day
::
DATE
>=
CURRENT_DATE
-
INTERVAL
'90 days'
GROUP
BY
1
ORDER
BY
1
Results
Run a query to Download Data