Open Interest Daily

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 Columns

Unique Key: unique_id

Column Name	Data Type	Description
project	VARCHAR	Project name (ex. polymarket).
protocol	VARCHAR	Protocol name (ex. polymarket).
day	DATE	Date for the open interest snapshot.
address	VARCHAR	Wallet address holding the position.
condition_id	VARCHAR	Unique condition identifier for the market.
market_unique_id	VARCHAR	Unique key for grouping related markets.
market_id	VARCHAR	Market identifier.
market_name	VARCHAR	Market name.
market_description	VARCHAR	Market description.
question_id	VARCHAR	Unique question identifier.
question	VARCHAR	Market question text.
question_description	VARCHAR	Detailed question description.
token_id	VARCHAR	Token ID for the specific outcome token.
token_outcome	VARCHAR	Token outcome name (Yes/No).
category	VARCHAR	Main category of the market.
sub_category	VARCHAR	Specific subcategory of the market.
tags	VARCHAR	Market tags.
neg_risk	BOOLEAN	Whether this is a NegRisk market.
resolution_outcome	VARCHAR	Market resolution outcome if resolved.
resolved_at	TIMESTAMP_NTZ(9)	Market resolution timestamp.
open_interest	FLOAT	Number of outcome tokens held (position size), normalized by dividing by 1e6.
token_price	FLOAT	Price per token on this day.
open_interest_usd	FLOAT	USD value of the open interest position (open_interest * token_price).
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	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

Position size: open_interest represents the number of outcome tokens held
USD value: open_interest_usd is calculated as open_interest * token_price

Overview

Data Verticals

Solana

Hyperliquid

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

Understanding Open Interest

Overview

Data Verticals

Solana

Hyperliquid

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

​Table Columns

​Sample Query

​Understanding Open Interest

Table Columns

Sample Query

Understanding Open Interest