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

# Markets 🌱

> Listed GMX v2 perpetual markets on MegaETH.

### Table Details

| Property | Value |
| - | - |
| Table Name | `megaeth.perpetuals.markets` |
| Table Status | Beta 🌱 |
| Unique Key | `unique_id` |

`megaeth.perpetuals.markets` has one row per listed GMX v2 perpetual market. `market_symbol` is the index symbol and is not unique across markets; use `unique_id` to identify a market. `pair_index` is null.

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| project | VARCHAR(16777216) | The perpetuals project. `gmx` on this table. |
| protocol | VARCHAR(16777216) | The protocol within the project. |
| version | VARCHAR(16777216) | Protocol contract version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| pair\_index | NUMBER(38,0) | Venue pair index. Null for GMX. |
| market\_symbol | VARCHAR(16777216) | Index symbol for the market. Not unique across GMX markets. |
| from\_symbol | VARCHAR(16777216) | Base symbol when the venue uses a from-to pair. Null for GMX. |
| to\_symbol | VARCHAR(16777216) | Quote symbol when the venue uses a from-to pair. Null for GMX. |
| max\_leverage | NUMBER(38,6) | Current maximum leverage for the market. Null when the protocol has not published one. |
| extra\_fields | VARIANT | Protocol-specific market metadata. |
| unique\_id | VARCHAR(16777216) | Unique identifier for the row. |
| \_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 *
FROM megaeth.perpetuals.markets
LIMIT 100;
```