TheDocumentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
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
- Market Category Diversity
Find market category diversity: