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

Latest state of each Solana perpetuals market (currently Jupiter Perpetuals).

### Table Columns

| Column Name            | Data Type         | Description                                                            |
| ---------------------- | ----------------- | ---------------------------------------------------------------------- |
| project                | VARCHAR           | The perpetuals project.                                                |
| protocol               | VARCHAR           | The specific protocol within the project.                              |
| version                | VARCHAR           | Protocol version.                                                      |
| chain                  | VARCHAR           | Blockchain network.                                                    |
| market\_index          | INTEGER           | Protocol market index.                                                 |
| market\_symbol         | VARCHAR           | Market symbol (e.g. SOL-USD).                                          |
| base\_asset\_symbol    | VARCHAR           | Symbol of the market's base asset.                                     |
| is\_prediction\_market | BOOLEAN           | Whether this market is a prediction market rather than a classic perp. |
| market\_status         | VARCHAR           | Current status of the market (e.g. active, paused, settled).           |
| is\_settled            | BOOLEAN           | Whether the market has been settled.                                   |
| initialized\_at        | TIMESTAMP\_NTZ(9) | Timestamp when the market was initialized.                             |
| settled\_at            | TIMESTAMP\_NTZ(9) | Timestamp when the market was settled, if applicable.                  |
| last\_state\_at        | DATE              | Date of the most recent market-state observation.                      |
| extra\_fields          | VARIANT           | Protocol-specific fields not promoted to first-class columns.          |