flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
LAVA price
adriaparcerisas
LAVA price
Updated 2024-12-05
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
trunc
(
hour
,
'day'
)
as
date
,
avg
(
price
)
as
price_usd
from
lava
.
price
.
ez_prices_hourly
where
symbol
=
'LAVA'
and
hour
>
'2024-10-20'
group
by
1
order
by
1
desc
Results
QueryRunArchived: QueryRun has been archived