flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2024-03-09 02:24 PM
spacebar
2024-03-09 02:24 PM
Updated 2024-03-09
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc
(
'day'
,
hour
)
as
date
,
AVG
(
price
)
as
price
from
crosschain
.
price
.
ez_prices_hourly
where
blockchain
=
'ethereum'
and
token_address
=
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
and
hour
>=
TIMESTAMP
'2024-02-29'
group
by
1
;
Results
QueryRunArchived: QueryRun has been archived