flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
flow 02
mz0111
flow 02
Updated 2023-05-19
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'week'
,
RECORDED_HOUR
)
as
date
,
TOKEN
,
avg
(
CLOSE
)
as
USD_Price
from
flow
.
core
.
fact_hourly_prices
where
date
>=
current_date
-
{
{
period
}
}
and
token
=
'Flow'
group
by
1
,
2
Results
Run a query to Download Data