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

> Hourly open interest tracking view for Polymarket prediction markets based on total token supply.

The `polygon.predictions.open_interest_hourly` view provides hourly snapshots of open interest across all prediction markets.

Use this view for granular liquidity analysis, intraday TVL tracking, and understanding market dynamics at hourly resolution.

### Table Details

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

### Table Columns

| Column Name               | Data Type         | Description                                                                              |
| ------------------------- | ----------------- | ---------------------------------------------------------------------------------------- |
| project                   | VARCHAR(16777216) | Project name (polymarket).                                                               |
| protocol                  | VARCHAR(16777216) | Protocol name (polymarket).                                                              |
| block\_hour               | TIMESTAMP\_NTZ(9) | Hour timestamp for the open interest snapshot.                                           |
| token\_address            | VARCHAR(42)       | Conditional Tokens contract address.                                                     |
| 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\_name               | VARCHAR(16777216) | Full name of the token (e.g. "USD Coin", "Wrapped Ether").                               |
| token\_outcome            | VARCHAR(16777216) | Token outcome name (Yes/No).                                                             |
| is\_winner                | BOOLEAN           | Whether this outcome won the market.                                                     |
| 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.                                                  |
| 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.                                                        |
| resolved\_by              | VARCHAR(16777216) | Entity responsible for resolution                                                        |
| oracle                    | VARCHAR(42)       | Oracle contract address for market resolution                                            |
| resolution\_outcome       | VARCHAR(16777216) | Market resolution outcome if resolved.                                                   |
| resolved\_at              | TIMESTAMP\_NTZ(9) | Market resolution timestamp.                                                             |
| open\_interest            | FLOAT             | Total token supply for this outcome.                                                     |
| token\_price              | FLOAT             | Price per token at this hour. After market resolution, prices reflect the final outcome. |
| open\_interest\_usd       | FLOAT             | USD value of the open interest.                                                          |
| unique\_id                | VARCHAR(16777216) | Unique identifier combining block\_hour and token\_id.                                   |

***

### Sample Query

```sql theme={null}
SELECT 
  block_hour,
  market_name,
  token_outcome,
  open_interest,
  token_price,
  open_interest_usd
FROM polygon.predictions.open_interest_hourly
WHERE block_hour >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
ORDER BY open_interest_usd DESC
LIMIT 100;
```