flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Terra Bounty-Luna Price (52) Distributions
amirkhannorii
Terra Bounty-Luna Price (52) Distributions
Updated 2022-07-07
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
DATE_trunc
(
'day'
,
block_timestamp
)
as
block_day
,
Avg
(
PRICE_USD
)
as
price
from
terra
.
oracle_prices
where
LUNA_EXCHANGE_RATE
=
1
And
block_timestamp
>=
current_date
-
45
group
by
block_day
Results
Run a query to Download Data