flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
aave arc1
bachi
aave arc1
Updated 2021-09-02
Copy Reference
Fork
9
1
2
›
⌄
select
date_trunc
(
day
,
block_timestamp
)
as
date
,
sum
(
token_price
)
as
total_price
,
avg
(
token_price
)
as
average_price
from
aave
.
deposits
where
symbol
=
'USDC'
and
date
>
dateadd
(
month
,
-
3
,
getdate
(
)
)
group
by
date
order
by
date
;
Results
Run a query to Download Data