> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Liquidations 🌱

> Perpl perpetual liquidations on Monad.

### Table Details

| Property | Value |
| - | - |
| Table Name | `monad.perpetuals.liquidations` |
| Table Status | Beta 🌱 |
| Unique Key | `block_timestamp`, `unique_id` |

`monad.perpetuals.liquidations` contains the liquidation rows of [`monad.perpetuals.trades`](https://docs.allium.so/historical-data/supported-blockchains/evm/monad/perpetuals/trades), with the same columns. `size_usd` is the size liquidated at the liquidation price; a partial liquidation leaves the rest of the position open.

Coverage is Perpl (`project = 'perpl'`, `protocol = 'perpl'`, `version = 'v1'`). See [Perpl](https://docs.allium.so/historical-data/perpetuals/perpl.md) for venue notes.

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| project | VARCHAR(16777216) | The perpetuals project. |
| protocol | VARCHAR(16777216) | The specific protocol within the project. |
| version | VARCHAR(16777216) | Protocol version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Block timestamp of the event. |
| block\_date | DATE | Calendar date of the event (UTC). |
| block\_number | NUMBER(38,0) | Block number containing the event. |
| transaction\_hash | VARCHAR(66) | Transaction hash. |
| log\_index | NUMBER(38,0) | Position of the event log within the transaction. |
| unique\_id | VARCHAR(16777216) | Unique identifier for the row. |
| trader | VARCHAR(42) | Address of the liquidated account. |
| market\_address | VARCHAR(42) | Null. Perpl markets are numbered markets on one exchange contract, not separate contracts. |
| market\_symbol | VARCHAR(16777216) | Market symbol as base-USD, for example BTC-USD. A relisted market keeps its symbol and has a new `pair_index`. |
| asset\_address | VARCHAR(42) | Collateral token address (AUSD, `0x00000000efe302beaa2b3e6e1b18d08d69a9012a`). |
| side | VARCHAR(16777216) | Position side: long or short. |
| action | VARCHAR(16777216) | Always `liquidation`. |
| size\_usd | NUMBER(38,6) | Notional size of the position change in USD. For a liquidation, the size liquidated at the liquidation price. |
| price\_usd | NUMBER(38,6) | Execution price in USD. For a liquidation, the liquidation price. |
| collateral\_usd | NUMBER(38,6) | Collateral held by the position after the event, in USD. |
| pnl\_usd | NUMBER(38,6) | Realized profit or loss in USD on decreases, closes, inversions, liquidations, and auto-deleveraging. Null on increases. |
| fee\_usd | NUMBER(38,6) | Trading fee paid on the event in USD. On opens and increases, the exchange splits this same fee between its insurance fund and the protocol; the split is in `extra_fields` and is not an additional charge. |
| extra\_fields | VARIANT | Protocol-specific detail: event name, perpetual and account ids, maker or taker role, order id, leverage, funding, the insurance, protocol, and builder fee split, lot sizes and deposits before and after the event, close reason, inversion leg, and liquidation amounts. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database. |

### Sample Query

```sql theme={null}
SELECT block_timestamp, trader, market_symbol, side, size_usd, price_usd, pnl_usd, transaction_hash
FROM monad.perpetuals.liquidations
WHERE block_timestamp >= current_date - 30
  AND project = 'perpl'
ORDER BY block_timestamp DESC
LIMIT 100;
```