flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Algo Price Chart (May 4th and 19th)
fat3meh
Algo Price Chart (May 4th and 19th)
Updated 2022-06-05
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
block_hour
as
date
,
avg
(
price_usd
)
as
Algo_price
from
algorand
.
prices_swap
where
asset_id
=
'0'
and
block_hour
::
date
BETWEEN
'2022-05-04'
AND
'2022-05-19'
group
by
date
Results
Run a query to Download Data