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