flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Osmo price on
Josh956
Osmo price on
Updated 2022-11-02
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
date_trunc
(
'day'
,
recorded_at
)
as
day
,
symbol
,
avg
(
price
)
as
Price
from
osmosis
.
core
.
dim_prices
where
symbol
like
'%OSMO%'
and
day
>
current_date
-
60
group
by
1
,
2
Results