Liquidations - Token Terminal Docs

One row per liquidation fill on a perpetual market, keeping the leg of the party whose position was force-closed. trade_amount is the size closed on that fill, and price is what it filled at.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Time of the block containing the liquidation fill. Partition column.
`block_number`	`INT64`	Number of the block containing the liquidation fill.
`transaction_hash`	`STRING`	Hash of the transaction that emitted the forced fill. Shared by every fill of the same liquidation.
`trade_id`	`INT64`	Forced-fill identifier on HyperCore; fingerprint of chain, transaction hash and log index on MUX. Part of the row key with `block_timestamp`, `perp_market_id`, `liquidated_user_address` and `crossed`.
`perp_market_id`	`STRING`	Market the position was liquidated in, keyed like `dimensions.perp_markets`.
`interface_app_id`	`STRING`	The builder credited for the market, read from the registry.
`exchange_app_id`	`STRING`	The venue that force-closed the position. The same liquidation is credited under both app columns, so group by one of them for a total.
`token_id`	`STRING`	The market’s settlement token, keyed like `dimensions.tokens`. Null on MUX markets, which accept several collateral tokens.
`chain_id`	`STRING`	Chain the liquidation happened on.
`project_id`	`STRING`	Project the exchange app belongs to.
`liquidated_user_address`	`STRING`	Account whose position was force-closed. Part of the row key, and a position closed in pieces spans one row per fill under this address.
`side`	`STRING`	The position that was force-closed: `A` for a long, `B` for a short.
`crossed`	`BOOL`	True on a HyperCore taker leg or a MUX pool liquidation; false on a HyperCore maker leg.
`price`	`BIGNUMERIC`	Execution price in the settlement token on HyperCore and in USD on MUX.
`trade_amount`	`BIGNUMERIC`	Size force-closed on this fill, in units of the underlying asset. Times `price` it is the liquidated notional in the HyperCore settlement token or in USD on MUX.
`mark_price`	`BIGNUMERIC`	Mark price the liquidation was triggered at. Null on MUX executions.
`method`	`STRING`	How the position was closed, as the venue labels its liquidation method. `liquidation` on MUX.

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 market, one day
Long vs short liquidations
Most liquidated accounts

A position closed in pieces spans one row per fill, so liquidated_user_address repeats down the result for a single force-close.

select
    liquidations.block_timestamp,
    liquidations.trade_id,
    liquidations.liquidated_user_address,
    liquidations.side,
    liquidations.price,
    liquidations.trade_amount,
    liquidations.mark_price,
    liquidations.method
from `facts_perp_markets.liquidations` as liquidations
where liquidations.perp_market_id = 'hlbtc-hypercore'
  and liquidations.chain_id = 'hypercore'
  and liquidations.block_timestamp >= timestamp('2026-08-01')
  and liquidations.block_timestamp < timestamp('2026-08-02')
order by liquidations.block_timestamp
limit 100

side is the position that was closed, so summing trade_amount * price under each value separates the two. MUX execution prices are in USD, and the result matches the daily tables on Metrics.

select
    date(liquidations.block_timestamp) as day,
    sum(if(liquidations.side = 'A', liquidations.trade_amount * liquidations.price, 0)) as long_liquidations,
    sum(if(liquidations.side = 'B', liquidations.trade_amount * liquidations.price, 0)) as short_liquidations
from `facts_perp_markets.liquidations` as liquidations
where liquidations.exchange_app_id = 'mux-perps'
  and liquidations.chain_id = 'arbitrum'
  and liquidations.block_timestamp >= timestamp('2026-08-01')
  and liquidations.block_timestamp < timestamp('2026-08-08')
group by day
order by day

liquidated_user_address is the account force-closed, and grouping on it adds every fill of every position it lost in the window.

select
    liquidations.liquidated_user_address,
    count(*) as fills,
    sum(liquidations.trade_amount * liquidations.price) as liquidated_notional
from `facts_perp_markets.liquidations` as liquidations
where liquidations.chain_id = 'hypercore'
  and liquidations.block_timestamp >= timestamp('2026-08-01')
  and liquidations.block_timestamp < timestamp('2026-08-08')
group by liquidations.liquidated_user_address
order by liquidated_notional desc
limit 25