Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The common.predictions.polymarket_us_open_interest_daily table provides daily open interest snapshots per market outcome from Polymarket US exchange end-of-day reports. One row per (day, market_unique_id).
See also: Crosschain Open Interest Daily for unified OI across all prediction market platforms.

​
Table Columns

Column NameData TypeDescription
projectVARCHARProject name.
protocolVARCHARProtocol name.
dayDATEDate of the open interest snapshot.
market_unique_idVARCHARMarket outcome identifier.
market_series_idVARCHARBase market identifier (slug).
market_idVARCHARMarket ID.
questionVARCHARMarket question text.
market_descriptionVARCHARMarket description.
categoryVARCHARMarket category.
market_typeVARCHARMarket type.
sports_market_typeVARCHARSports market type (MONEYLINE, SPREAD, TOTAL, PROP).
outcome_1VARCHARFirst outcome description.
outcome_2VARCHARSecond outcome description.
winnerVARCHARName of the winning outcome.
is_resolvedBOOLEANWhether the market has been resolved.
market_statusVARCHARCurrent market status.
report_dateDATEUTC report date.
strike_priceFLOATStrike price or outcome index.
open_interestFLOATEnd-of-day open interest in contracts.
trade_volumeFLOATDaily trade volume.
block_volumeFLOATDaily block trade volume.
low_bid_priceFLOATLowest bid price of the day.
high_bid_priceFLOATHighest bid price of the day.
low_offer_priceFLOATLowest offer price of the day.
high_offer_priceFLOATHighest offer price of the day.
low_trade_priceFLOATLowest trade price of the day.
high_trade_priceFLOATHighest trade price of the day.
settlement_priceFLOATEnd-of-day settlement price.
maturity_dateDATEMarket maturity date.
maturity_timestampTIMESTAMP_NTZMarket maturity timestamp in UTC.
report_descriptionVARCHARDescription from the exchange daily report.
unique_idVARCHARDeterministic 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