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