polygon.predictions.token_prices_daily view provides daily price snapshots for all prediction market tokens.
Use this view for market outcome price trend analysis, and time-series analysis of market outcomes.
Table Columns
Unique Key:unique_id
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Project name (ex. polymarket). |
| protocol | VARCHAR | Protocol name (ex. polymarket). |
| day | DATE | Date for the price snapshot. |
| condition_id | VARCHAR | Unique condition identifier for the market. |
| token_id | VARCHAR | Token ID for the specific outcome token. |
| price | FLOAT | Token price, forward-filled from last trade or set to 0/1 after resolution based on outcome. |
| unique_id | VARCHAR | Unique identifier combining day and token_id (format ‘day-YYYY-MM-DD_token_id-’). |
Understanding Price Data
- Forward-filled prices: If no trade occurred on a given day, the price is forward-filled from the last known trade
- Resolution-based corrections: After market resolution, prices are set to 0 for losing outcomes and 1 for winning outcomes