polygon.predictions.user_positions table provides daily snapshots of user holdings across all prediction markets. Each row represents a user’s position in a specific outcome token on a given day, enriched with comprehensive market metadata.
Use this table for portfolio analysis, position tracking, exposure calculation, and understanding user investment patterns across different market categories.
Table Columns
Unique Key:unique_id
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Project name (ex. polymarket). |
| protocol | VARCHAR | Protocol name (ex. polymarket). |
| unique_id | VARCHAR | Unique identifier combining day, address, and token_id. |
| day | DATE | Date of the position snapshot. |
| address | VARCHAR | User wallet address holding the position. |
| token_address | VARCHAR | Conditional Tokens contract address. |
| token_id | VARCHAR | Token ID for the specific outcome token. |
| token_balance | FLOAT | Number of outcome tokens held, normalized by dividing by 1e6. |
| condition_id | VARCHAR | Unique condition identifier for the market. |
| market_unique_id | VARCHAR | Unique key for grouping related markets. |
| market_id | VARCHAR | Market identifier from onchain data. |
| market_name | VARCHAR | Market name (uses question for single markets). |
| market_description | VARCHAR | Market description from onchain events. |
| question_id | VARCHAR | Unique question identifier. |
| question | VARCHAR | Market question text. |
| question_description | VARCHAR | Market description from API. |
| token_name | VARCHAR | Combined outcome and question name. |
| token_outcome | VARCHAR | Token outcome name (Yes/No). |
| is_winner | BOOLEAN | Whether this outcome won the market. |
| market_active | BOOLEAN | Whether market is currently active. |
| market_closed | BOOLEAN | Whether market is closed. |
| market_accepting_orders | BOOLEAN | Whether market is accepting new orders. |
| category | VARCHAR | Main market category. |
| sub_category | VARCHAR | Specific market subcategory. |
| tags | VARCHAR | API category tags. |
| neg_risk | BOOLEAN | Whether this is a NegRisk market. |
| resolved_by | VARCHAR | Entity responsible for resolution. |
| oracle | VARCHAR | Oracle contract address for market resolution. |
| resolution_outcome | VARCHAR | Market resolution outcome if resolved. |
| resolved_at | TIMESTAMP_NTZ(9) | Market resolution timestamp. |
| _created_at | TIMESTAMP_NTZ(9) | Record creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Record update timestamp. |