> ## 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

> GMX perpetual position liquidations on Avalanche.

`avalanche.perpetuals.liquidations` contains GMX perpetual position liquidations on Avalanche, exposed with the same schema as [Trades](/historical-data/supported-blockchains/evm/avalanche/perpetuals/trades). Every row has `action = 'liquidation'`.

Current coverage includes GMX v1 and v2.

### Table Columns

| Column Name       | Description                                      | Type           | Example                                                            |
| ----------------- | ------------------------------------------------ | -------------- | ------------------------------------------------------------------ |
| project           | The perpetuals project.                          | varchar        | gmx                                                                |
| protocol          | The specific protocol within the project.        | varchar        | gmx                                                                |
| version           | Protocol version.                                | varchar        | v2                                                                 |
| chain             | Blockchain network.                              | varchar        | avalanche                                                          |
| block\_timestamp  | Block timestamp of the event.                    | timestamp\_ntz | 2026-01-13 22:10:52                                                |
| block\_date       | Calendar date of the event (UTC).                | date           | 2026-01-13                                                         |
| block\_number     | Block number containing the event.               | number         | 75,690,722                                                         |
| transaction\_hash | Transaction hash.                                | varchar        | 0x6be921b4de0e2096a7e58c1ab8cedbde60d5934ac8b05ffbe3a9bcdfddd9bef2 |
| log\_index        | Position of the event log within the block.      | number         | 141                                                                |
| unique\_id        | Unique identifier for the row.                   | varchar        | txn-0x6be921b4...\_log\_index-141                                  |
| trader            | Wallet address of the liquidated position.       | varchar        | 0x74dc3f4e095ab2aef7e085c6580597be48b2d4e7                         |
| market\_address   | GMX market address.                              | varchar        | 0x913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf                         |
| market\_symbol    | Symbol of the market's index token.              | varchar        | WAVAX                                                              |
| asset\_address    | Address of the index (traded) token.             | varchar        | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7                         |
| side              | Position side: long or short.                    | varchar        | short                                                              |
| action            | Always liquidation for this table.               | varchar        | liquidation                                                        |
| size\_usd         | Notional size of the liquidated position in USD. | number         | 3823.708136                                                        |
| price\_usd        | Index token price in USD at the event.           | number         | 14.788201                                                          |
| collateral\_usd   | Collateral of the position in USD.               | number         | 76.536328                                                          |
| pnl\_usd          | Realized profit or loss in USD.                  | number         | -74.922415                                                         |
| fee\_usd          | Total liquidation fee for the event, in USD.     | number         | 0.000000                                                           |
| extra\_fields     | VARIANT column with protocol-specific detail.    | variant        |                                                                    |

### Sample Query

```sql theme={null}
SELECT *
FROM avalanche.perpetuals.liquidations
WHERE block_date = '2026-07-23'
LIMIT 100;
```