Open Interest Daily

See also: Crosschain Open Interest Daily for unified OI across all prediction market platforms.

Table Columns

Column Name	Data Type	Description
project	VARCHAR	Project name.
protocol	VARCHAR	Protocol name.
day	DATE	Date of the open interest snapshot.
market_unique_id	VARCHAR	Market outcome identifier.
market_series_id	VARCHAR	Base market identifier (slug).
market_id	VARCHAR	Market ID.
question	VARCHAR	Market question text.
market_description	VARCHAR	Market description.
category	VARCHAR	Market category.
market_type	VARCHAR	Market type.
sports_market_type	VARCHAR	Sports market type (MONEYLINE, SPREAD, TOTAL, PROP).
outcome_1	VARCHAR	First outcome description.
outcome_2	VARCHAR	Second outcome description.
winner	VARCHAR	Name of the winning outcome.
is_resolved	BOOLEAN	Whether the market has been resolved.
market_status	VARCHAR	Current market status.
report_date	DATE	UTC report date.
strike_price	FLOAT	Strike price or outcome index.
open_interest	FLOAT	End-of-day open interest in contracts.
trade_volume	FLOAT	Daily trade volume.
block_volume	FLOAT	Daily block trade volume.
low_bid_price	FLOAT	Lowest bid price of the day.
high_bid_price	FLOAT	Highest bid price of the day.
low_offer_price	FLOAT	Lowest offer price of the day.
high_offer_price	FLOAT	Highest offer price of the day.
low_trade_price	FLOAT	Lowest trade price of the day.
high_trade_price	FLOAT	Highest trade price of the day.
settlement_price	FLOAT	End-of-day settlement price.
maturity_date	DATE	Market maturity date.
maturity_timestamp	TIMESTAMP_NTZ	Market maturity timestamp in UTC.
report_description	VARCHAR	Description from the exchange daily report.
unique_id	VARCHAR	Deterministic unique key.

Sample Query

SELECT
    day,
    market_series_id,
    question,
    category,
    SUM(open_interest) AS total_oi
FROM common.predictions.polymarket_us_open_interest_daily
WHERE day >= CURRENT_DATE - 7
  AND open_interest > 0
GROUP BY day, market_series_id, question, category
ORDER BY day DESC, total_oi DESC
LIMIT 100

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query