flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Algorand mega 3
IBC_insider
Algorand mega 3
Updated 2023-01-03
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
avg
(
CLOSE
)
as
price
,
date_trunc
(
'day'
,
RECORDED_HOUR
)
as
date
from
crosschain
.
core
.
fact_hourly_prices
where
ID
=
'flow'
group
by
date
Results
Run a query to Download Data