connorhCompound Liquidators
    Updated 2022-07-04
    -- 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