> ## 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 Perpl perpetual markets on Monad.

### Table Details

| 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](https://docs.allium.so/historical-data/perpetuals/perpl.md) for venue notes.

### Table Columns

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

### Sample Query

```sql theme={null}
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;
```