megaeth.perpetuals.liquidations contains GMX perpetual position liquidations on MegaETH, exposed with the same schema as 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
SELECT *
FROM megaeth.perpetuals.liquidations
WHERE block_date = '2026-03-26'
LIMIT 100;