BORROWER | Total Deposited USD | Total Liquidated USD | Total Borrowed After Liquidation | Liquidation Count | Percentage Liquidated | |
|---|---|---|---|---|---|---|
1 | 0x5ead411fc6c417689ebb1cf827f6169abf2feed8 | 9905090.28 | 175.98 | 47499.7 | 1 | 0.001776662252 |
2 | 0x2374da9a66e6321612fb9cca715359db1ae5ee8a | 9174796.91 | 20015.53 | 269019.73 | 1 | 0.2181577445 |
3 | 0x472e624a8a210dba4f8e0aaa4ad2ed9a68f43860 | 4588758.73 | 7843.98 | 3407172 | 1 | 0.1709390374 |
4 | 0xd97beffdf558b269257feba5df111ab718b71e24 | 4389079.48 | 171816.8 | 1135899.15 | 4 | 3.914643168 |
5 | 0xa8a29bc8816e19d2b41cdaae48bd602180b0ff3e | 3597254.66 | 0.88 | 683550.91 | 1 | 0.00002446309987 |
6 | 0x4ffad6ac852c0af0aa301376f4c5dea3a928b120 | 2531265.34 | 607.63 | 0 | 1 | 0.02400499033 |
7 | 0x78358ae7cfe9094a0e7c6d4573ab23e0ba68b3aa | 1890046.45 | 9.25 | 323362.55 | 5 | 0.0004894059614 |
8 | 0x9c7cc69ed41ee7991b3a691a9680cccc966f25bf | 1625673.8 | 122.95 | 0 | 1 | 0.00756301787 |
9 | 0x6c1172f3beefbcce75e3c61ce8981d05d100e7ea | 1565483.5 | 0 | 0 | 1 | 0 |
10 | 0x329c54289ff5d6b7b7dae13592c6b1eda1543ed4 | 1444630.39 | 2864.25 | 0 | 1 | 0.1982687073 |
11 | 0x2cf7f3dd0023670958ceb0d4d97373ceb8a98aa3 | 1413709.62 | 521543.67 | 0 | 1011 | 36.891852656 |
12 | 0xfb04df5bc87a78ebcfaa207847da146bd2a7d390 | 1067342.18 | 55582.72 | 629810.63 | 2 | 5.207582071 |
13 | 0x4a03c2a9f3a11b1fc154c8bc9b825e0ff503b028 | 940088.22 | 66345.12 | 12449.93 | 4 | 7.057329152 |
14 | 0xde467125b64a64c504b303079681c775ced7274a | 752962.42 | 0.96 | 455409.1 | 1 | 0.0001274964028 |
15 | 0x334f12afb7d8740868be04719639616533075234 | 741369.12 | 0.1 | 0 | 1 | 0.00001348855749 |
16 | 0x91fea319ed45c7b12683c8c25e741151fbfee24b | 599187.08 | 51745.21 | 126685.25 | 7 | 8.635902163 |
17 | 0x34113c84f95717b34d9818dd47821c42e095bf59 | 511521.64 | 0.11 | 0 | 1 | 0.00002150446656 |
18 | 0xd0ef1730e650179edcf753c8332f23ad58dab407 | 462436.95 | 45223.25 | 0 | 1 | 9.779333161 |
19 | 0x45323d50a3e1ca8fdf24df0a323fc9e38fd6b01c | 442411.64 | 46401.63 | 65778.55 | 1 | 10.488338417 |
20 | 0x241d2a8fea32e5e055e1a686f3d1581b4e8ba0e1 | 401380.29 | 182814.08 | 99496.4 | 1 | 45.546352064 |
datavortexdebt liquidity and deposit
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 total_liquidated_usd,
COUNT(DISTINCT tx_hash) AS liquidation_count
FROM
gnosis.defi.ez_lending_liquidations
GROUP BY
borrower
),
deposit_data AS (
SELECT
depositor AS borrower,
SUM(amount_usd) AS total_deposited_usd
FROM
gnosis.defi.ez_lending_deposits
GROUP BY
depositor
),
borrow_data AS (
SELECT
borrower,
SUM(amount_usd) AS total_borrowed_usd
FROM
gnosis.defi.ez_lending_borrows
WHERE
block_timestamp > (
SELECT MAX(block_timestamp)
FROM gnosis.defi.ez_lending_liquidations
WHERE gnosis.defi.ez_lending_liquidations.borrower = gnosis.defi.ez_lending_borrows.borrower
)
GROUP BY
Last run: 22 days ago
...
478
35KB
8s