Open Interest Hourly 🌱 - Allium Documentation Hub

The polygon.predictions.open_interest_hourly view provides hourly snapshots of open interest across all prediction markets. Use this view for granular liquidity analysis, intraday TVL tracking, and understanding market dynamics at hourly resolution.

Table Details

Property	Value
Table Name	`polygon.predictions.open_interest_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 open interest snapshot.
token_address	VARCHAR(42)	Conditional Tokens contract address.
condition_id	VARCHAR(16777216)	Unique condition identifier for the market.
market_unique_id	VARCHAR(16777216)	Unique key for grouping related markets.
market_id	VARCHAR(16777216)	Market identifier.
market_name	VARCHAR(16777216)	Market name.
market_description	VARCHAR(16777216)	Market description.
question_id	VARCHAR(16777216)	Unique question identifier.
question	VARCHAR(16777216)	Market question text.
question_description	VARCHAR(16777216)	Detailed question description.
token_id	VARCHAR(16777216)	Token ID for the specific outcome token.
token_name	VARCHAR(16777216)	Full name of the token (e.g. “USD Coin”, “Wrapped Ether”).
token_outcome	VARCHAR(16777216)	Token outcome name (Yes/No).
is_winner	BOOLEAN	Whether this outcome won the market.
market_active	BOOLEAN	Whether market is currently active.
market_closed	BOOLEAN	Whether market is closed.
market_accepting_orders	BOOLEAN	Whether market is accepting new orders.
category	VARCHAR(16777216)	Main category of the market.
sub_category	VARCHAR(16777216)	Specific subcategory of the market.
tags	VARCHAR(16777216)	Market tags.
neg_risk	BOOLEAN	Whether this is a NegRisk market.
resolved_by	VARCHAR(16777216)	Entity responsible for resolution
oracle	VARCHAR(42)	Oracle contract address for market resolution
resolution_outcome	VARCHAR(16777216)	Market resolution outcome if resolved.
resolved_at	TIMESTAMP_NTZ(9)	Market resolution timestamp.
open_interest	FLOAT	Total token supply for this outcome.
token_price	FLOAT	Price per token at this hour. After market resolution, prices reflect the final outcome.
open_interest_usd	FLOAT	USD value of the open interest.
is_price_known	BOOLEAN	False when no price was available for the token, in which case `open_interest_usd` contributes zero and understates rather than being genuinely worthless. Combo positions minted by a transformation carry no mark until their combo resolves.
unique_id	VARCHAR(16777216)	Unique identifier combining block_hour and token_id.

Sample Query

SELECT 
  block_hour,
  market_name,
  token_outcome,
  open_interest,
  token_price,
  open_interest_usd
FROM polygon.predictions.open_interest_hourly
WHERE block_hour >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
ORDER BY open_interest_usd DESC
LIMIT 100;