Skip to main content
The 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.

​
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. After market resolution, prices reflect the final outcome.
unique_idVARCHARUnique identifier combining block_hour and token_id.

​
Understanding Price Data

  • If no trade occurred during a given hour, the price carries forward from the last known trade.
  • After market resolution, prices are set to 0 for losing outcomes and 1 for winning outcomes.

​
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;