flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Luna price over past 30 days
strawbetty
Luna price over past 30 days
Updated 2022-05-12
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
as
dt
,
avg
(
price_usd
)
as
lunaprice
from
terra
.
oracle_prices
where
symbol
=
'LUNA'
and
block_timestamp
>=
'2022-04-10'
and
block_timestamp
<
'2022-05-10'
group
by
1
Results
Run a query to Download Data