BORROWER | TOTAL LIQUIDATED USD | TOTAL BORROWED USD | TOTAL DEPOSITED USD | REMAINING DEBT (USD) | |
|---|---|---|---|---|---|
1 | 0x2cf7f3dd0023670958ceb0d4d97373ceb8a98aa3 | 521543.67 | 0 | 811565.1 | -521543.67 |
2 | 0x241d2a8fea32e5e055e1a686f3d1581b4e8ba0e1 | 182814.08 | 0 | 354273.93 | -182814.08 |
3 | 0xd97beffdf558b269257feba5df111ab718b71e24 | 171816.8 | 118994.44 | 4357421.55 | -52822.36 |
4 | 0x202300000753cc083302a8d9795170ac909d0e52 | 99207.49 | 0 | 0 | -99207.49 |
5 | 0x4a03c2a9f3a11b1fc154c8bc9b825e0ff503b028 | 66345.12 | 0 | 544087.78 | -66345.12 |
6 | 0xfb04df5bc87a78ebcfaa207847da146bd2a7d390 | 55582.72 | 0 | 570664.76 | -55582.72 |
7 | 0x9ef55ded74dbae11639fbe51c58ebd4e1b8b757b | 48423.45 | 0 | 0 | -48423.45 |
8 | 0x45323d50a3e1ca8fdf24df0a323fc9e38fd6b01c | 46401.63 | 0 | 157173.16 | -46401.63 |
9 | 0xd0ef1730e650179edcf753c8332f23ad58dab407 | 45223.25 | 0 | 280154.19 | -45223.25 |
10 | 0x7cc672080e0f3a1e28c281d352fce350fd20dd86 | 32577.29 | 0 | 262312.8 | -32577.29 |
datavortexremianing debt
Updated 2025-04-16
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 liquidation_data AS (
SELECT
borrower,
SUM(amount_usd) AS liquidated_amount_usd,
collateral_token_symbol AS token_symbol
FROM
gnosis.defi.ez_lending_liquidations
GROUP BY
borrower, collateral_token_symbol
),
borrow_data AS (
SELECT
borrower,
SUM(amount_usd) AS borrowed_amount_usd,
token_symbol
FROM
gnosis.defi.ez_lending_borrows
GROUP BY
borrower, token_symbol
),
deposit_data AS (
SELECT
depositor AS borrower,
SUM(amount_usd) AS deposited_amount_usd,
token_symbol
FROM
gnosis.defi.ez_lending_deposits
GROUP BY
depositor, token_symbol
)
SELECT
l.borrower AS BORROWER,
COALESCE(l.liquidated_amount_usd, 0) AS "TOTAL LIQUIDATED USD",
COALESCE(b.borrowed_amount_usd, 0) AS "TOTAL BORROWED USD",
COALESCE(d.deposited_amount_usd, 0) AS "TOTAL DEPOSITED USD",
Last run: 23 days ago
10
776B
7s