Total Liquidators | Total Borrowers | Total Volume USD Liquidated | |
|---|---|---|---|
1 | 31 | 378 | 2454994.2472682 |
datavortexTotal Liquidators
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
›
⌄
WITH liquidation_data AS (
SELECT
liquidator,
borrower,
collateral_token_symbol AS "Collateral Token Symbol",
amount
FROM
gnosis.defi.ez_lending_liquidations
),
price_data AS (
SELECT
symbol,
max(price) AS avg_price
FROM
gnosis.price.ez_prices_hourly
GROUP BY
symbol
)
SELECT
COUNT(DISTINCT ld.liquidator) AS "Total Liquidators",
COUNT(DISTINCT ld.borrower) AS "Total Borrowers",
SUM(ld.amount * pd.avg_price) AS "Total Volume USD Liquidated"
FROM
liquidation_data ld
JOIN
price_data pd
ON
ld."Collateral Token Symbol" = pd.symbol;
Last run: 19 days ago
1
26B
8s