Skip to main content
The prediction_markets.open_interest_hourly table holds hourly open interest and traded volume for Polymarket and Kalshi markets. It has one row per (venue, hour, market_id), for every hour from the market’s first open contract to the hour it settles. Open interest is the amount outstanding at the end of the hour. Volume is what traded during the hour. Open interest is zero in the settlement hour. The table combines polymarket_polygon.open_interest_hourly and kalshi.open_interest_hourly, which have the same columns. Kalshi open interest has no v2 table. Those pages explain how each venue’s figures are calculated. Hyperliquid HIP-4 is not included yet; use hip4_hyperliquid.open_interest_hourly. On Polymarket rows, event_id is Polymarket’s event id for markets in a mutually exclusive event (where exactly one outcome can win). It is NULL on standalone markets.
Polymarket Combos and Kalshi parlays are not included, so totals cover single markets only.
For total open interest, take event_oi_contracts once per (venue, COALESCE(event_id, market_id), hour), as in the example below. Don’t sum it across the members of an event, because it is repeated on every member row. Don’t sum market_oi_yes_contracts across Polymarket event members either. Converting No tokens mints Yes tokens of every sibling outcome without adding collateral, so that sum can overstate the money at stake several times over. On Kalshi the two methods agree.
For market names, join prediction_markets.markets. For prices, join prediction_markets.ohlcv_hourly. Both join on (venue, market_id).

Table Schema

Table sample

Query performance

The table is partitioned by block_month. Always filter on block_month or hour, and on venue when you only need one venue.

Example query

Previous version

Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.