CryptoLionRecovery
Updated 2021-06-14
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
›
⌄
WITH a as (
SELECT
date_trunc('day',block_timestamp) as day,
borrower,
liquidation_amount_usd
FROM compound.liquidations
WHERE block_timestamp >= '2021-05-19' AND block_timestamp <= '2021-05-22'
ORDER BY 1),
b as (
SELECT
date_trunc('day',block_timestamp) as day,
supplier,
supplied_base_asset_usd
FROM compound.deposits d
INNER JOIN a on a.borrower = d.supplier
WHERE block_timestamp >= '2021-05-22'
ORDER BY 1),
c as (
SELECT
date_trunc('day',block_timestamp) as day,
d.borrower,
loan_amount_usd
FROM compound.borrows d
INNER JOIN a on a.borrower = d.borrower
WHERE block_timestamp >= '2021-05-22'
ORDER BY 1
)
SELECT
ROUND(count(distinct supplier)/count(distinct a.borrower)*100,2) as re_suppliers,
ROUND(count(distinct c.borrower)/count(distinct a.borrower)*100,2) as re_borrowers,
ROUND(SUM(loan_amount_usd)/SUM(liquidation_amount_usd)*100,2) as re_borrowed_of_liquidated,
ROUND(SUM(supplied_base_asset_usd)/SUM(liquidation_amount_usd)*100,2) as re_supplied_of_liquidated
FROM b
JOIN c
JOIN a
Run a query to Download Data