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

> Per-coin Hyperliquid HIP-4 open interest at hourly grain.

The `hyperliquid.predictions.open_interest_hourly` table contains supply-based open interest for every Hyperliquid HIP-4 side-token at hourly grain. One row per (block\_hour, coin). Settled outcomes are excluded from the settlement hour onward.

<Info>
  For per-user open interest see [Open Interest Daily](/historical-data/supported-blockchains/hyperliquid/predictions/open-interest-daily). When summing across YES + NO sides at the same outcome, prefer `oi_usd` — `market_oi_usd` and `oi_tokens` repeat their value on each side.
</Info>

## Table Columns

| Column Name     | Description                                                                                                              |
| --------------- | ------------------------------------------------------------------------------------------------------------------------ |
| project         | Top-level project namespace (`hyperliquid`).                                                                             |
| protocol        | Protocol within the project (`hyperliquid_hip4`).                                                                        |
| chain           | The blockchain network (`hyperliquid`).                                                                                  |
| block\_hour     | Hour bucket (UTC).                                                                                                       |
| coin            | HL-native side-token identifier (e.g. '#54760').                                                                         |
| encoding        | HL-canonical numeric encoding for the side-token.                                                                        |
| outcome\_id     | HIP-4 outcome identifier (shared by both token sides).                                                                   |
| token\_side     | Which side of the outcome's YES/NO pair the row represents (0 or 1).                                                     |
| side\_label     | Display label for this row's token\_side (e.g. 'Yes', 'No').                                                             |
| oi\_tokens      | Open interest in side-tokens for this coin.                                                                              |
| holders         | Distinct users with a positive position on this side-token.                                                              |
| last\_price     | Last observed price as a 0..1 probability.                                                                               |
| oi\_usd         | USD value of the open interest on this coin. Safe to SUM across both sides of an outcome.                                |
| market\_oi\_usd | Collateral locked at the outcome level, in USD. Repeats on both `token_side` rows of a given (block\_hour, outcome\_id). |
| outcome\_name   | Outcome display name from the HL API.                                                                                    |
| market\_title   | Human-readable market title.                                                                                             |
| category        | Market type. One of 'price\_binary', 'categorical', 'binary'.                                                            |
| sub\_category   | Underlying asset for Recurring outcomes (e.g. 'BTC'). NULL otherwise.                                                    |
| is\_recurring   | True for HL's auto-generated price-binary outcomes.                                                                      |
| question\_id    | Parent question ID. NULL for Recurring / orphan outcomes.                                                                |
| question\_name  | Question name from the HL API.                                                                                           |
| is\_winner      | True for the winning side of a settled outcome. NULL while unsettled.                                                    |
| expiry\_ts      | Resolution timestamp (UTC) for Recurring outcomes. NULL otherwise.                                                       |
| unique\_id      | Deterministic unique identifier per row.                                                                                 |
| \_created\_at   | Row creation timestamp.                                                                                                  |
| \_updated\_at   | Row last update timestamp.                                                                                               |

## Sample Query

```sql theme={null}
SELECT
  block_hour,
  SUM(oi_usd) AS total_oi_usd
FROM hyperliquid.predictions.open_interest_hourly
WHERE block_hour >= CURRENT_DATE - 7
GROUP BY block_hour
ORDER BY block_hour DESC
LIMIT 100
```