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.
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 byblock_month. Always filter on block_month or hour, and on venue when you only need one venue.
Example query
Previous version
Previous version (v1)
Previous version (v1)
Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.