flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
mo115
Untitled Query
Updated 2022-06-19
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
Date_trunc
(
'day'
,
HOUR
)
as
date
,
(
sum
(
PRICE
)
/
count
(
price
)
)
as
CRO
from
ethereum
.
core
.
fact_hourly_token_prices
where
SYMBOL
=
'CRO'
group
by
1
Results
Run a query to Download Data