flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Luna Price Before and After Nov Burnt
fat3meh
Luna Price Before and After Nov Burnt
Updated 2022-04-25
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc
(
'day'
,
block_timestamp
)
as
day
,
avg
(
price_usd
)
as
"Luna Price"
from
terra
.
oracle_prices
where
symbol
=
'LUNA'
and
block_timestamp
>=
'2021-10-01'
and
block_timestamp
<
'2022-01-01'
group
by
day
Results
Run a query to Download Data