Open Interest Daily 🌱 - Allium Documentation Hub

The polygon.predictions.open_interest_daily view provides daily snapshots of open interest across all prediction markets. Open interest represents the total value of outstanding positions. These holdings include positions that have not been redeemed. Use this view for market liquidity analysis, total value locked tracking, and understanding the overall size of prediction markets.

Table Details

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

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Project name (ex. polymarket).
protocol	VARCHAR(16777216)	Protocol name (ex. polymarket).
day	DATE	Date for the open interest snapshot.
address	VARCHAR(42)	Wallet address holding the position.
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)	Title of the neg-risk event the market belongs to. The market question for markets outside a neg-risk event, for native Polymarket Protocol V2 markets, and for neg-risk markets with no available event title. For Polymarket Protocol V2 tokens not listed in the markets table, the token’s own market name (the combo name for combo tokens). Null when no market details are available for the token.
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_outcome	VARCHAR(16777216)	Token outcome name (Yes/No).
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.
resolution_outcome	VARCHAR(16777216)	Market resolution outcome if resolved.
resolved_at	TIMESTAMP_NTZ(9)	Market resolution timestamp.
open_interest	FLOAT	Number of outcome tokens held (position size).
token_price	FLOAT	Price per token on this day. After market resolution, prices reflect the final outcome.
open_interest_usd	FLOAT	USD value of the open interest position.
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.
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.
is_winner	BOOLEAN	Whether this outcome won the market.
unique_id	VARCHAR(16777216)	Unique identifier combining day, address, and token_id (format ‘day-YYYY-MM-DD_address-_token_id-’).

Sample Query

Daily TVL Trends

Track total value locked over time:

select
  day,
  sum(open_interest_usd) as total_tvl_usd
from polygon.predictions.open_interest_daily
where day >= current_date - interval '30 days'
group by day
order by day desc

Understanding Open Interest

open_interest represents the number of outcome tokens held.
open_interest_usd is the USD value of the position.

EVM

​Table Details

​Table Columns

​Sample Query

​Understanding Open Interest

Table Details

Table Columns

Sample Query

Understanding Open Interest