shenronWhales median % borrowed
Updated 2021-05-03
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
›
⌄
WITH deposits AS (
SELECT supplier
, SUM(supplied_base_asset_usd) AS deposits
FROM compound.deposits
GROUP BY 1
HAVING SUM(supplied_base_asset_usd) > 0
)
, borrows AS (
SELECT borrower
, SUM(loan_amount_usd) AS loans
FROM compound.borrows
GROUP BY 1
)
, whales as (SELECT supplier
, deposits
, loans
, ROUND(loans*1.0/deposits,5) AS pct_borrowed
FROM deposits d JOIN borrows b ON d.supplier = b.borrower
WHERE supplier in (
'0x2cc308d515a73690ba58ed637d1b20b4b7324fcd'
,'0xa6b7dd64c2f19d90c3111183a7a7d10823b91982'
,'0xa9c8adafb744c56e9ed3a7b82ec92207b21c4f0c'
,'0x83239023282221e114abd100f92467cae1c1ba6e'
,'0x4c81ac8a069122d2a7146b08818fbaddcb2ff1f0'
,'0x742fb193517619eecd6595ff106fce2f45488ebf'
,'0xe4bed3988b25eb625466102f2d0bea1c9fafcd86'
Run a query to Download Data