flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-05-17 10:09 AM
sepehrmhz8
2023-05-17 10:09 AM
Updated 2023-05-19
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc
(
week
,
recorded_hour
)
as
date
,
token
,
avg
(
close
)
as
"PRICE($)"
from
flow
.
core
.
fact_hourly_prices
where
recorded_hour
>=
'2022-01-01'
group
by
1
,
2
order
by
1
Results
Run a query to Download Data