connorhCompound Liquidators
Updated 2022-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- When a borrower becomes insolvent they can be liquidated by other users
--- The liquidator paid of a portion of the loan and are able to seize a portion of the borrower's collatoral at a discount
--- For more details see https://compound.finance/docs/ctokens#liquidate-borrow
--- This query tallies up the most active liquidators over the past 60 days
SELECT
liquidator,
SUM(ctokens_seized) AS ctokens_seized,
COUNT(DISTINCT ctoken) AS markets_involved,
SUM(liquidation_amount_usd) AS amount_seized_usd,
COUNT(DISTINCT borrower) AS addresses_taken_from
FROM
compound.liquidations
WHERE block_timestamp >= CURRENT_DATE - 60
GROUP BY 1
ORDER BY amount_seized_usd DESC
Run a query to Download Data