DATE | TOTAL_LIQUADATIONS | TOTAL_LIQUIDATION_VALUE_USD | |
|---|---|---|---|
1 | 2025-03-23 00:00:00.000 | 73 | 2352.19 |
2 | 2025-03-24 00:00:00.000 | 13 | 4233.79 |
3 | 2025-03-25 00:00:00.000 | 829 | 23769.88 |
4 | 2025-03-26 00:00:00.000 | 205 | 56934.26 |
5 | 2025-03-27 00:00:00.000 | 20 | 1572.17 |
6 | 2025-03-28 00:00:00.000 | 71 | 1590206.88 |
7 | 2025-03-29 00:00:00.000 | 118 | 776405.51 |
8 | 2025-03-30 00:00:00.000 | 147 | 1540723.78 |
9 | 2025-03-31 00:00:00.000 | 62 | 128504.41 |
10 | 2025-04-01 00:00:00.000 | 20 | 160497.73 |
11 | 2025-04-02 00:00:00.000 | 127 | 1308464.92 |
12 | 2025-04-03 00:00:00.000 | 209 | 1817396.24 |
13 | 2025-04-04 00:00:00.000 | 246 | 154947.16 |
14 | 2025-04-05 00:00:00.000 | 247 | 4348.57 |
15 | 2025-04-06 00:00:00.000 | 2055 | 64773760.13 |
16 | 2025-04-07 00:00:00.000 | 1755 | 77971955.14 |
17 | 2025-04-08 00:00:00.000 | 559 | 56487.73 |
18 | 2025-04-09 00:00:00.000 | 622 | 3620359.64 |
19 | 2025-04-10 00:00:00.000 | 155 | 483590.33 |
20 | 2025-04-11 00:00:00.000 | 37 | 47954.28 |
gihankumarLiquidation events (Last 30 Days)
Updated 2025-04-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp)as date,
COUNT(*) AS total_liquadations,
SUM(amount_usd) AS total_liquidation_value_usd
FROM
ethereum.defi.ez_lending_liquidations
WHERE
block_timestamp >= current_date - interval '30 days'
AND amount_usd IS NOT NULL
GROUP BY 1
ORDER BY 1
Last run: about 2 months ago
31
1KB
2s