> ## 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.

# Open Interest Daily

> Daily open interest per market outcome from Polymarket US.

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).

<Info>
  See also: [Crosschain Open Interest Daily](/historical-data/predictions/crosschain/open-interest-daily) for unified OI across all prediction market platforms.
</Info>

## 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

```sql theme={null}
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
```