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) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| version | VARCHAR(16777216) | Protocol version. |
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| pair_index | NUMBER(38,0) | Protocol-native numeric identifier of the trading pair. Used by the protocol’s contracts to reference this market. |
| market_symbol | VARCHAR(16777216) | Market symbol (e.g. SOL-USD). |
| from_symbol | VARCHAR(16777216) | Symbol of the base asset being traded (the asset whose price the market tracks). |
| to_symbol | VARCHAR(16777216) | Symbol of the quote asset the market is denominated in. |
| max_leverage | NUMBER(38,6) | Maximum leverage the protocol permits on this market. |
| extra_fields | VARIANT | JSON object containing additional protocol-specific fields for this market that are not part of the standard schema. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record. Stable across full refreshes. |
| _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
SELECT *
FROM megaeth.perpetuals.markets
LIMIT 100;