Token Prices Hourly 🌱 - Allium Documentation Hub

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 Details

Property	Value
Table Name	`polygon.predictions.token_prices_hourly`
Table Status	Beta 🌱

Table Columns

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.

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;