flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
top_10_borrowers
Diako999
top_10_borrowers
Updated 2023-03-02
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
distinct
sender
,
tx_id
,
date_trunc
(
'day'
,
block_timestamp
)
as
date
,
amount
,
currency
,
action
from
osmosis
.
mars
.
ez_redbank_actions
where
action
=
'borrow'
group
by
date
,
tx_id
,
action
,
currency
,
amount
,
sender
order
by
amount
desc
limit
10
Results
Run a query to Download Data