> ## 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 tracking view for Polymarket prediction markets, combining user positions with market pricing data.

The `polygon.predictions.open_interest_daily` view provides daily snapshots of open interest across all prediction markets.

Open interest represents the total value of outstanding positions. These holdings include positions that have not been redeemed.

Use this view for market liquidity analysis, total value locked tracking, and understanding the overall size of prediction markets.

### Table Details

| Property     | Value                                     |
| ------------ | ----------------------------------------- |
| Table Name   | `polygon.predictions.open_interest_daily` |
| Table Status | Beta 🌱                                   |

### Table Columns

| Column Name               | Data Type         | Description                                                                                                                 |
| ------------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------- |
| project                   | VARCHAR(16777216) | Project name (ex. polymarket).                                                                                              |
| protocol                  | VARCHAR(16777216) | Protocol name (ex. polymarket).                                                                                             |
| day                       | DATE              | Date for the open interest snapshot.                                                                                        |
| address                   | VARCHAR(42)       | Wallet address holding the position.                                                                                        |
| condition\_id             | VARCHAR(16777216) | Unique condition identifier for the market.                                                                                 |
| market\_unique\_id        | VARCHAR(16777216) | Unique key for grouping related markets.                                                                                    |
| market\_id                | VARCHAR(16777216) | Market identifier.                                                                                                          |
| market\_name              | VARCHAR(16777216) | Market name.                                                                                                                |
| market\_description       | VARCHAR(16777216) | Market description.                                                                                                         |
| question\_id              | VARCHAR(16777216) | Unique question identifier.                                                                                                 |
| question                  | VARCHAR(16777216) | Market question text.                                                                                                       |
| question\_description     | VARCHAR(16777216) | Detailed question description.                                                                                              |
| token\_id                 | VARCHAR(16777216) | Token ID for the specific outcome token.                                                                                    |
| token\_outcome            | VARCHAR(16777216) | Token outcome name (Yes/No).                                                                                                |
| category                  | VARCHAR(16777216) | Main category of the market.                                                                                                |
| sub\_category             | VARCHAR(16777216) | Specific subcategory of the market.                                                                                         |
| tags                      | VARCHAR(16777216) | Market tags.                                                                                                                |
| neg\_risk                 | BOOLEAN           | Whether this is a NegRisk market.                                                                                           |
| resolution\_outcome       | VARCHAR(16777216) | Market resolution outcome if resolved.                                                                                      |
| resolved\_at              | TIMESTAMP\_NTZ(9) | Market resolution timestamp.                                                                                                |
| open\_interest            | FLOAT             | Number of outcome tokens held (position size).                                                                              |
| token\_price              | FLOAT             | Price per token on this day. After market resolution, prices reflect the final outcome.                                     |
| open\_interest\_usd       | FLOAT             | USD value of the open interest position.                                                                                    |
| market\_active            | BOOLEAN           | Whether market is currently active.                                                                                         |
| market\_closed            | BOOLEAN           | Whether market is closed.                                                                                                   |
| market\_accepting\_orders | BOOLEAN           | Whether market is accepting new orders.                                                                                     |
| is\_winner                | BOOLEAN           | Whether this outcome won the market.                                                                                        |
| unique\_id                | VARCHAR(16777216) | Unique identifier combining day, address, and token\_id (format 'day-YYYY-MM-DD\_address-{address}\_token\_id-{token_id}'). |

***

### Sample Query

<Tabs>
  <Tab title="Daily TVL Trends">
    Track total value locked over time:

    ```sql theme={null}
    select
      day,
      sum(open_interest_usd) as total_tvl_usd
    from polygon.predictions.open_interest_daily
    where day >= current_date - interval '30 days'
    group by day
    order by day desc
    ```
  </Tab>
</Tabs>

### Understanding Open Interest

* `open_interest` represents the number of outcome tokens held.
* `open_interest_usd` is the USD value of the position.