flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
price_ether
sakineh5021-nIQRzB
price_ether
Updated 2022-03-23
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
avg
(
price
)
as
PRi
,
symbol
,
cast
(
hour
as
date
)
from
ethereum
.
token_prices_hourly
where
cast
(
hour
as
date
)
=
'2022-03-21'
and
(
Symbol
=
'DAI'
or
Symbol
=
'MIM'
or
Symbol
=
'ETH'
)
group
by
2
,
3
limit
20
Results
Run a query to Download Data