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

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

Current coverage includes GMX 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        | megaeth                                                            |
| block\_timestamp  | Block timestamp of the event.                    | timestamp\_ntz | 2026-03-26 05:51:46                                                |
| block\_date       | Calendar date of the event (UTC).                | date           | 2026-03-26                                                         |
| block\_number     | Block number containing the event.               | number         | 11,707,295                                                         |
| transaction\_hash | Transaction hash.                                | varchar        | 0x760f28a0be2b154047b36f547a8393648d990e59165922e5798c99f9b217dc89 |
| log\_index        | Position of the event log within the block.      | number         | 89                                                                 |
| unique\_id        | Unique identifier for the row.                   | varchar        | txn-0x760f28a0...\_log\_index-89                                   |
| trader            | Wallet address of the liquidated position.       | varchar        | 0xd2a54e7afc36f6d09627c7c9abdd033ac3800613                         |
| market\_address   | GMX market address.                              | varchar        | 0x9b1b72720f6d277f3b1e607a0c5fab1b300248b1                         |
| market\_symbol    | Symbol of the market's index token.              | varchar        | WETH                                                               |
| asset\_address    | Address of the index (traded) token.             | varchar        | 0x4200000000000000000000000000000000000006                         |
| side              | Position side: long or short.                    | varchar        | long                                                               |
| action            | Always liquidation for this table.               | varchar        | liquidation                                                        |
| size\_usd         | Notional size of the liquidated position in USD. | number         | 2.047908                                                           |
| price\_usd        | Index token price in USD at the event.           | number         | 2119.676140                                                        |
| collateral\_usd   | Collateral of the position in USD.               | number         | 1.023573                                                           |
| pnl\_usd          | Realized profit or loss in USD at liquidation.   | number         | -0.023661                                                          |
| fee\_usd          | Total liquidation fee for the event, in USD.     | number         | 0.006978                                                           |
| extra\_fields     | VARIANT column with protocol-specific detail.    | variant        |                                                                    |

### Sample Query

```sql theme={null}
SELECT *
FROM megaeth.perpetuals.liquidations
WHERE block_date = '2026-03-26'
LIMIT 100;
```