Liquidations - Token Terminal Docs

In progress. This table is not served yet. The page documents it as it lands.

facts.lending_market_liquidations combines the liquidation events of every lending protocol we decode into one table: one row per liquidation. A liquidation repays part of an undercollateralized borrower’s debt and takes their collateral at a discount. lending_market_id keys each row to the debt market in the Registry.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Time of the block containing the liquidation. Partition column.
`block_number`	`INT64`	Number of the block containing the liquidation.
`transaction_hash`	`STRING`	Hash of the transaction that emitted the liquidation event.
`log_index`	`INT64`	Position of the liquidation event in the block.
`unique_id`	`INT64`	Row key: fingerprint of `chain_id`, `block_number`, `transaction_hash`, `log_index`.
`chain_id`	`STRING`	Chain the liquidation happened on.
`lending_market_id`	`STRING`	Market of the debt repaid; joins `dimensions.lending_markets`.
`project_id`	`STRING`	Protocol operating the market, such as `aave`.
`debt_token_id`	`STRING`	Token of the debt repaid: `{token_address}-{chain_id}`.
`debt_token_address`	`STRING`	Contract address of the debt token.
`collateral_token_id`	`STRING`	Token of the collateral taken: `{token_address}-{chain_id}`.
`collateral_token_address`	`STRING`	Contract address of the collateral token.
`borrower_address`	`STRING`	Account that was liquidated.
`liquidator_address`	`STRING`	Account that performed the liquidation.
`debt_amount_raw`	`STRING`	Debt repaid as text, in the debt token.
`collateral_amount_raw`	`STRING`	Collateral taken as text, in the collateral token.

Sample queries

The table is partitioned on block_timestamp. Bound that column in every query; without a bound the query reads the whole table.

Largest liquidations
One market, one day

Rank the largest liquidations in a window by debt repaid in USD. USD comes from Prices.

select
    liquidations.block_timestamp,
    liquidations.transaction_hash,
    liquidations.borrower_address,
    liquidations.liquidator_address,
    round(cast(liquidations.debt_amount_raw as bignumeric) / pow(10, tokens.decimals) * prices.price) as debt_repaid_usd
from `facts.lending_market_liquidations` as liquidations
join `dimensions.tokens` as tokens
    on tokens.token_id = liquidations.debt_token_id
join `metrics.tokens_prices_daily` as prices
    on prices.token_id = liquidations.debt_token_id
    and prices.timestamp = timestamp_trunc(liquidations.block_timestamp, day)
where liquidations.block_timestamp >= timestamp('2026-08-01')
  and liquidations.block_timestamp < timestamp('2026-08-08')
order by debt_repaid_usd desc
limit 20

Read one market’s liquidations on a single day.

select
    liquidations.block_timestamp,
    liquidations.transaction_hash,
    liquidations.borrower_address,
    cast(liquidations.debt_amount_raw as bignumeric) / pow(10, tokens.decimals) as debt_repaid
from `facts.lending_market_liquidations` as liquidations
join `dimensions.lending_markets` as markets
    using (lending_market_id)
join `dimensions.tokens` as tokens
    on tokens.token_id = liquidations.debt_token_id
where markets.project_id = 'aave'
  and markets.underlying_symbol = 'WETH'
  and markets.chain_id = 'ethereum'
  and liquidations.block_timestamp >= timestamp('2026-08-01')
  and liquidations.block_timestamp < timestamp('2026-08-02')
limit 100

⌘I