Deebs-DeFi-j9fRbz$OSMO Top Borrow Positions copy
Updated 2023-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from 9461578a-7efe-44b9-b392-4a00c763c31a
WITH borrowing as (
SELECT
Sender as Borrower,
Currency,
ACTION,
CASE
WHEN ACTION = 'borrow' THEN AMOUNT/POW(10,6)
WHEN ACTION = 'repay' THEN -AMOUNT/POW(10,6)
END as NEW_AMOUNTS,
CASE
WHEN Currency='uosmo'THEN 'OSMO'
END as SYMBOL
FROM osmosis.mars.ez_redbank_actions
WHERE Currency='uosmo'
AND ACTION IN ('borrow','repay')
)
SELECT
b.Borrower,
sum(b.NEW_AMOUNTS) AS BORROW_POSITION,
b.Symbol,
SUBSTRING(b.Borrower, 38, 43) as short_address
FROM borrowing b
GROUP BY 1,4,3
ORDER BY 2 DESC
LIMIT 10;
Run a query to Download Data