Skip to main content
The polygon.predictions.token_prices_hourly view provides hourly price snapshots for all prediction market tokens. Prices are forward-filled from raw trade prices and resolution-corrected using live markets metadata. Use this view for granular price trend analysis, intraday market movements, and time-series analysis of market outcomes.

​
Table Columns

Unique Key: unique_id
Column NameData TypeDescription
projectVARCHARProject name (polymarket).
protocolVARCHARProtocol name (polymarket).
block_hourTIMESTAMP_NTZ(9)Hour timestamp for the price snapshot.
condition_idVARCHARUnique condition identifier for the market.
token_idVARCHARToken ID for the specific outcome token.
priceFLOATToken price in USDC.e terms. Before end_date: forward-filled raw trade price. After end_date: resolution-corrected via live markets metadata.
unique_idVARCHARUnique identifier combining block_hour and token_id.

​
Understanding Price Data

Price Resolution Logic After market end_date, prices are corrected using this fallback chain:
  1. Chain resolution outcome/token yes/no mapping
  2. API is_winner=true gives 1.0
  3. API token_price when exactly 0 or 1
  4. Raw trade price (fallback)
Forward-filled prices: If no trade occurred during a given hour, the price is forward-filled from the last known trade.

​
Sample Query

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;