polygon.predictions.markets table provides metadata for prediction markets, combining API data, onchain events, and resolution outcomes at the token level. Each row represents a specific outcome token within a market.
Use this table to discover markets, analyze resolution patterns, and understand market structure across different categories.
Table Columns
Unique Key:market_unique_id, token_id
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Project name (ex. polymarket). |
| protocol | VARCHAR | Protocol name (ex. polymarket). |
| market_unique_id | VARCHAR | Unique key for grouping related markets. |
| condition_id | VARCHAR | Unique condition identifier. |
| market_id | VARCHAR | Market identifier. |
| market_request_id | VARCHAR | NegRisk market request ID. |
| market_name | VARCHAR | Market name from onchain data. |
| market_description_onchain | VARCHAR | Market description from onchain events. |
| question_id | VARCHAR | Unique question identifier. |
| question | VARCHAR | Market question text. |
| description | VARCHAR | Market description from API. |
| token_id | VARCHAR | Token ID for this outcome. |
| token_outcome | VARCHAR | Token outcome name. |
| token_name | VARCHAR | Combined outcome and question name. |
| token_price | FLOAT | Current token price. |
| is_winner | BOOLEAN | Whether this outcome won. |
| active | BOOLEAN | Whether market is active. |
| archived | BOOLEAN | Whether market is archived. |
| closed | BOOLEAN | Whether market is closed. |
| accepting_orders | BOOLEAN | Whether accepting new orders. |
| enable_order_book | BOOLEAN | Whether order book is enabled. |
| neg_risk | BOOLEAN | Whether this is a NegRisk market. |
| resolved_by | VARCHAR | Entity responsible for resolution. |
| category | VARCHAR | Main category. |
| sub_category | VARCHAR | Specific subcategory. |
| tags | VARCHAR | Original category tokens. |
| api_category | VARCHAR | Original category from API before categorization. |
| api_type | VARCHAR | API data source type. |
| start_date | TIMESTAMP_NTZ(9) | Market start time. |
| end_date | TIMESTAMP_NTZ(9) | Market end time. |
| game_start_time | TIMESTAMP_NTZ(9) | Event start time. |
| seconds_delay | NUMBER | Resolution delay in seconds. |
| fpmm | VARCHAR | FPMM contract address. |
| maker_fee | FLOAT | Maker fee. |
| taker_fee | FLOAT | Taker fee. |
| oracle | VARCHAR | Oracle contract address. |
| fee_bips | NUMBER | Fee in basis points. |
| prepared_at | TIMESTAMP_NTZ(9) | Market preparation timestamp. |
| outcome | VARCHAR | Resolution outcome. |
| resolved_at | TIMESTAMP_NTZ(9) | Resolution timestamp. |
| created_at | TIMESTAMP_NTZ(9) | API record creation time. |
| updated_at | TIMESTAMP_NTZ(9) | API record update time. |
Sample Query
Find market category diversity: