flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
borr count growth
0-MID
borr count growth
Updated 2023-04-13
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
date_trunc
(
'month'
,
BLOCK_TIMESTAMP
)
as
month
,
count
(
distinct
TX_HASH
)
as
borrow_count
,
sum
(
borrow_count
)
over
(
order
by
month
)
as
borrow_count_growth
from
ethereum
.
compound
.
ez_borrows
where
month
>=
'2019-05-01'
group
by
1
order
by
1
Results
Run a query to Download Data