lighter.dex.liquidations table contains liquidation events only. The taker is the liquidated account, and the maker is the counterparty.
Table Details
| Property | Value |
|---|---|
| Clustering Key(s) | to_date("timestamp") (base table) |
Table Columns
Market Information
| Column Name | Description |
|---|---|
| market_type | ’perpetuals’ or ‘spot’ |
| coin | Market symbol |
| token_a_symbol | Base token symbol |
| token_b_symbol | Quote token symbol |
Liquidation Details
| Column Name | Description |
|---|---|
| amount | Liquidation size in base asset units |
| price | Execution price |
| usd_amount | USD value of the liquidation |
| liquidated_account_id | Account ID of the liquidated party |
| counterparty_account_id | Account ID of the counterparty (maker) |
| buyer | Account ID of the buyer (bid side) |
| seller | Account ID of the seller (ask side) |
Transaction Information
| Column Name | Description |
|---|---|
| timestamp | UTC timestamp of the event |
| transaction_hash | On-chain transaction hash |
| trade_id | Unique trade identifier |
| unique_id | Alias of trade_id |
Fees & Margins
| Column Name | Description |
|---|---|
| liquidation_fee_rate | Liquidation fee as decimal fraction |
| liquidation_fee_amount | Liquidation fee in USD |
| liquidated_position_size_before | Liquidated account’s position before event |
| liquidated_max_leverage | Liquidated account’s max leverage |
| market_max_leverage | Maximum leverage for this market |
| maintenance_margin_fraction | Market maintenance margin fraction |
| closeout_margin_fraction | Market closeout margin fraction |