flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Anchor Borrows in Last 3 Months
Crazy_Kid
Anchor Borrows in Last 3 Months
Updated 2022-02-21
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
sender
as
borrowers
,
COUNT
(
tx_id
)
as
no_of_borrows
,
currency
,
sum
(
amount
)
as
amount_borrowed
FROM
anchor
.
borrows
WHERE
date
(
block_timestamp
)
BETWEEN
'2021-11-01'
AND
'2022-01-31'
GROUP
BY
borrowers
,
currency
ORDER
BY
amount_borrowed
DESC
Results
Run a query to Download Data