Liquidations - Token Terminal Docs

One row per liquidation, with the collateral seized and the debt repaid on the same row. collateral_amount is the tokens seized and borrow_amount the debt cleared.

Columns

Column	Type	Description
`block_timestamp`	TIMESTAMP	Time of the block containing the liquidation. Partition column.
`block_number`	INTEGER	Number of the block containing the liquidation.
`transaction_hash`	STRING	Hash of the transaction that emitted the liquidation event.
`log_index`	INTEGER	Position of the liquidation event in the block.
`unique_id`	INTEGER	Row key: fingerprint of `chain_id`, `block_number`, `transaction_hash`, `log_index`.
`event_type`	STRING	Constant `liquidations`; stacking key across the lending facts.
`project_id`	STRING	Protocol operating the market, such as `aave`.
`app_id`	STRING	Deployment of the protocol the market belongs to.
`chain_id`	STRING	Chain the liquidation happened on.
`lending_market_id`	STRING	Market holding the debt that was repaid; joins `dimensions.lending_markets`.
`lending_market_contract_address`	STRING	Contract the market lives on; not a key.
`lending_position_id`	STRING	The liquidated position: one borrower inside one market.
`collateral_lending_market_reserve_id`	STRING	Reserve the seized collateral sat in; joins `dimensions.lending_market_reserves`.
`collateral_lending_market_reserve_position_id`	STRING	The borrower’s holding in that collateral reserve.
`collateral_receipt_token_address`	STRING	Receipt token whose balance moved on the collateral side; null where positions are not tokenised.
`borrow_lending_market_reserve_id`	STRING	Reserve the repaid debt sat in; joins `dimensions.lending_market_reserves`.
`borrow_lending_market_reserve_position_id`	STRING	The borrower’s debt in that reserve.
`borrow_receipt_token_address`	STRING	Debt token whose balance moved on the borrow side; null where debt is not tokenised.
`liquidator_address`	STRING	Account that repaid the debt and took the collateral.
`borrower_address`	STRING	Account that was liquidated; the position key across the lending facts.
`collateral_token_id`	STRING	Collateral token seized: `{token_address}-{chain_id}`.
`collateral_token_address`	STRING	Contract address of the collateral token.
`collateral_token_symbol`	STRING	Symbol of the collateral token.
`collateral_token_decimals`	INTEGER	Decimals of the collateral token.
`borrow_token_id`	STRING	Debt token repaid: `{token_address}-{chain_id}`.
`borrow_token_address`	STRING	Contract address of the debt token.
`borrow_token_symbol`	STRING	Symbol of the debt token.
`borrow_token_decimals`	INTEGER	Decimals of the debt token.
`collateral_to_liquidator_amount_raw`	BIGNUMERIC	Share of the seized collateral paid to the liquidator, in the token’s stored unit, exact integer.
`collateral_to_liquidator_amount`	BIGNUMERIC	`collateral_to_liquidator_amount_raw` decimal-corrected into whole tokens.
`collateral_to_treasury_amount_raw`	BIGNUMERIC	Share of the seized collateral kept by the protocol, in the token’s stored unit, exact integer.
`collateral_to_treasury_amount`	BIGNUMERIC	`collateral_to_treasury_amount_raw` decimal-corrected into whole tokens.
`collateral_amount_raw`	BIGNUMERIC	Collateral seized in total, exact integer; the liquidator share and the treasury share add up to it.
`collateral_amount`	BIGNUMERIC	`collateral_amount_raw` decimal-corrected into whole tokens.
`borrow_amount_raw`	BIGNUMERIC	Debt repaid in the token’s stored unit, exact integer.
`borrow_amount`	BIGNUMERIC	`borrow_amount_raw` decimal-corrected into whole tokens.

Sample queries

This table is large and split by day. Bound block_timestamp and filter chain_id on every query, or you read the whole table and the whole table is billed to you.

One day, one app
Most liquidated collateral
Collateral kept by the protocol

Each row has two token legs: the collateral seized and the debt repaid. borrower_address is the position that was closed and liquidator_address the account that closed it.

select
    events.block_timestamp,
    events.collateral_token_symbol,
    events.collateral_amount,
    events.borrow_token_symbol,
    events.borrow_amount,
    events.borrower_address,
    events.liquidator_address
from `facts_lending_markets.liquidations` as events
where events.block_timestamp >= timestamp('2026-09-01')
  and events.block_timestamp < timestamp('2026-09-02')
  and events.chain_id = 'ethereum'
  and events.app_id = 'aave-v3'
limit 100

Counting rows counts liquidation events; summing collateral_amount totals the tokens taken. Both are per collateral token, since the amounts are in each token’s own units.

select
    events.collateral_token_symbol,
    count(*) as liquidations,
    sum(events.collateral_amount) as collateral_seized
from `facts_lending_markets.liquidations` as events
where events.block_timestamp >= timestamp('2026-08-01')
  and events.block_timestamp < timestamp('2026-09-01')
  and events.chain_id = 'ethereum'
group by events.collateral_token_symbol
order by liquidations desc
limit 25

A liquidation splits the seized collateral between the liquidator’s bonus and the protocol’s cut. The two columns are those shares, and they add up to collateral_amount.

select
    date(events.block_timestamp) as day,
    events.app_id,
    sum(events.collateral_to_liquidator_amount) as to_liquidator,
    sum(events.collateral_to_treasury_amount) as to_treasury
from `facts_lending_markets.liquidations` as events
where events.block_timestamp >= timestamp('2026-08-01')
  and events.block_timestamp < timestamp('2026-09-01')
  and events.chain_id = 'ethereum'
group by day, events.app_id
order by day