Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Listed Perpl perpetual markets on Monad.
| Property | Value |
|---|---|
| Table Name | monad.perpetuals.markets |
| Table Status | Beta 🌱 |
| Unique Key | unique_id |
monad.perpetuals.markets has one row per Perpl market with its latest parameters, including paused markets. pair_index is the Perpl market id. max_leverage is the current maximum leverage.
Coverage is Perpl (project = 'perpl', protocol = 'perpl', version = 'v1'). See Perpl for venue notes.
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | The perpetuals project. |
| protocol | VARCHAR(16777216) | The specific protocol within the project. |
| version | VARCHAR(16777216) | Protocol version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| pair_index | NUMBER(38,0) | Perpl numeric market id. |
| market_symbol | VARCHAR(16777216) | Market symbol as base-USD, for example BTC-USD. A relisted market keeps its symbol and has a new pair_index. |
| from_symbol | VARCHAR(16777216) | Base symbol of the market. |
| to_symbol | VARCHAR(16777216) | Quote symbol of the market (USD). |
| max_leverage | NUMBER(38,6) | Current maximum leverage for the market. |
| extra_fields | VARIANT | Protocol-specific market parameters: name, price and lot decimals, maintenance margin, maker and taker fee rates and tiers, fee schedule id, insurance fund share, liquidation shares, maximum open interest, paused and removed flags, and listing time. |
| 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 pair_index, market_symbol, max_leverage, extra_fields:is_paused::boolean AS is_paused
FROM monad.perpetuals.markets
WHERE project = 'perpl'
ORDER BY pair_index;
Was this page helpful?