flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Daily $AAVE Price
Sbhn_NP
Daily $AAVE Price
Updated 2023-03-01
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date_trunc
(
'day'
,
hour
)
as
date
,
avg
(
price
)
as
usdprice
from
ethereum
.
core
.
fact_hourly_token_prices
where
symbol
=
'AAVE'
and
date
>=
CURRENT_DATE
-
{
{
Date
}
}
group
by
1
Results
Run a query to Download Data