flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
opti nft pr
Hessish
opti nft pr
Updated 2022-08-03
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
hour
::
date
as
date
,
avg
(
PRICE
)
as
pr
from
optimism
.
core
.
fact_hourly_token_prices
where
hour
::
date
>=
CURRENT_DATE
-
45
and
TOKEN_ADDRESS
=
'0x4200000000000000000000000000000000000042'
GROUP
by
1
Results
Run a query to Download Data