flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Price:MKR
Abbas_ra21
Price:MKR
Updated 2023-03-08
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date_trunc
(
'Day'
,
BLOCK_TIMESTAMP
)
::
DATE
AS
DAY
,
sum
(
BORROWED_USD
)
AS
"BORROWED AMOUNT (USD)"
,
avg
(
TOKEN_PRICE
)
AS
"Price (USD)"
from
ethereum
.
aave
.
ez_borrows
where
SYMBOL
in
(
'MKR'
)
and
AAVE_VERSION
=
'Aave V2'
group
by
1
Results
Run a query to Download Data