Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Hourly price tracking view for Polymarket prediction market tokens.
polygon.predictions.token_prices_hourly view provides hourly price snapshots for all prediction market tokens.
Use this view for granular price trend analysis, intraday market movements, and time-series analysis of market outcomes.
| Property | Value |
|---|---|
| Table Name | polygon.predictions.token_prices_hourly |
| Table Status | Beta 🌱 |
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | Project name (polymarket). |
| protocol | VARCHAR(16777216) | Protocol name (polymarket). |
| block_hour | TIMESTAMP_NTZ(9) | Hour timestamp for the price snapshot. |
| condition_id | VARCHAR(16777216) | Unique condition identifier for the market. |
| token_id | VARCHAR(16777216) | Token ID for the specific outcome token. |
| price | FLOAT | Token price in USDC.e terms. After market resolution, prices reflect the final outcome. |
| unique_id | VARCHAR(16777216) | Unique identifier combining block_hour and token_id. |
SELECT
block_hour,
condition_id,
token_id,
price
FROM polygon.predictions.token_prices_hourly
WHERE block_hour >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
ORDER BY block_hour DESC
LIMIT 100;
Was this page helpful?