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

> Polymarket US prediction market metadata.

The `common.predictions.polymarket_us_markets` table lists Polymarket US markets. Each row is one market.

### Table Columns

Unique Key: `market_unique_id`

| Column Name                 | Data Type      | Description                                            |
| --------------------------- | -------------- | ------------------------------------------------------ |
| project                     | VARCHAR        | Project name.                                          |
| protocol                    | VARCHAR        | Protocol name.                                         |
| market\_unique\_id          | VARCHAR        | Unique market identifier (slug).                       |
| market\_id                  | VARCHAR        | Market ID.                                             |
| question                    | VARCHAR        | Market question text.                                  |
| description                 | VARCHAR        | Market description.                                    |
| category                    | VARCHAR        | Market category (sports, culture, etc).                |
| market\_type                | VARCHAR        | Market type.                                           |
| sports\_market\_type        | VARCHAR        | Sports market type (MONEYLINE, SPREAD, TOTAL, PROP).   |
| active                      | BOOLEAN        | Whether the market is accepting orders.                |
| closed                      | BOOLEAN        | Whether the market has closed.                         |
| archived                    | BOOLEAN        | Whether the market is archived.                        |
| market\_status              | VARCHAR        | Current market status.                                 |
| outcome\_1                  | VARCHAR        | First outcome description (long side).                 |
| outcome\_2                  | VARCHAR        | Second outcome description (short side).               |
| outcome\_1\_price           | FLOAT          | Price for outcome 1 (0 to 1 scale).                    |
| outcome\_2\_price           | FLOAT          | Price for outcome 2 (0 to 1 scale).                    |
| settlement\_price           | FLOAT          | Binary settlement value for the market (0 to 1 scale). |
| winner                      | VARCHAR        | Name of the winning outcome.                           |
| is\_resolved                | BOOLEAN        | Whether the market has been resolved.                  |
| market\_outcome\_resolution | VARCHAR        | Resolution status.                                     |
| start\_date                 | TIMESTAMP\_NTZ | Market start timestamp.                                |
| end\_date                   | TIMESTAMP\_NTZ | Market end timestamp.                                  |
| game\_start\_time           | TIMESTAMP\_NTZ | Game/event start time for sports markets.              |
| created\_at                 | TIMESTAMP\_NTZ | Market creation timestamp.                             |
| updated\_at                 | TIMESTAMP\_NTZ | Market last update timestamp.                          |
| fee\_coefficient            | FLOAT          | Trading fee coefficient.                               |
| tick\_size                  | FLOAT          | Minimum order price tick size.                         |
| outcomes\_raw               | VARCHAR        | Raw outcomes JSON array.                               |
| extras                      | VARCHAR        | VARIANT column with platform-specific metadata.        |

***

### Sample Query

```sql theme={null}
SELECT
    category,
    COUNT(*) AS total_markets,
    SUM(CASE WHEN is_resolved THEN 1 ELSE 0 END) AS resolved,
    SUM(CASE WHEN active AND NOT closed THEN 1 ELSE 0 END) AS open
FROM common.predictions.polymarket_us_markets
GROUP BY category
ORDER BY total_markets DESC
```