Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Listed GMX v2 perpetual markets on MegaETH.
| 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.
| 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. |
SELECT *
FROM megaeth.perpetuals.markets
LIMIT 100;
Was this page helpful?