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

> Per-user, per-coin Hyperliquid HIP-4 open interest at end of day.

The `hyperliquid.predictions.open_interest_daily` table contains one row per (day, user, coin) for every user holding a non-zero balance on a Hyperliquid HIP-4 side-token. Settled outcomes are excluded from the settlement day onward.

<Info>
  For supply-based, per-coin open interest at hourly grain see [Open Interest Hourly](/historical-data/supported-blockchains/hyperliquid/predictions/open-interest-hourly).
</Info>

## Table Columns

| Column Name         | Description                                                                                        |
| ------------------- | -------------------------------------------------------------------------------------------------- |
| project             | Top-level project namespace (`hyperliquid`).                                                       |
| protocol            | Protocol within the project (`hyperliquid_hip4`).                                                  |
| chain               | The blockchain network (`hyperliquid`).                                                            |
| day                 | Date bucket (UTC).                                                                                 |
| user\_address       | User wallet address.                                                                               |
| 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').                                       |
| token\_balance      | User's end-of-day balance in this side-token. Only non-zero (positive) holdings are included.      |
| last\_price         | Last observed price for the day as a 0..1 probability.                                             |
| open\_interest\_usd | USD value of the user's position on this coin. Safe to SUM across users / coins / days.            |
| 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.                                                                     |
| event\_ticker       | Stable cross-side event identifier. Use for COUNT(DISTINCT) when reporting markets/events with OI. |
| 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
  day,
  SUM(open_interest_usd) AS total_oi_usd,
  COUNT(DISTINCT user_address) AS holders,
  COUNT(DISTINCT event_ticker) AS markets_with_oi
FROM hyperliquid.predictions.open_interest_daily
WHERE day >= CURRENT_DATE - 30
GROUP BY day
ORDER BY day DESC
```