> ## 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 open interest, funding rate, premium, and mark per perpetual market on Arbitrum.

### Table Details

| Property | Value |
| - | - |
| Table Name | `arbitrum.perpetuals.open_interest` |
| Table Status | Beta 🌱 |
| Unique Key | `unique_id` |
| Clustering Key(s) | `activity_date, market_symbol` |

`arbitrum.perpetuals.open_interest` has one row per market per UTC day. Current coverage is GMX v2 and Ostium v1. The latest day includes activity up to the latest refresh.

Ostium `funding_rate` and `premium` are per-block values with 18 decimal places. A positive Ostium funding rate means longs pay shorts. Both are null for GMX. Ostium `mark_price_usd` is null before 2025-03-03 and null for HSI-HKD.

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| activity\_date | DATE | UTC calendar day. |
| project | VARCHAR(16777216) | The perpetuals project, such as `gmx` or `ostium`. |
| protocol | VARCHAR(16777216) | The protocol within the project. |
| version | VARCHAR(16777216) | Protocol contract version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| pair\_index | NUMBER(38,0) | Venue pair index. Set for Ostium. Null for GMX. |
| market\_symbol | VARCHAR(16777216) | Symbol for the market when one is available. Not unique for GMX. |
| from\_symbol | VARCHAR(16777216) | Base symbol when the venue uses a from-to pair. |
| to\_symbol | VARCHAR(16777216) | Quote symbol when the venue uses a from-to pair. |
| long\_open\_interest\_usd | NUMBER(38,6) | Long open interest in USD. |
| short\_open\_interest\_usd | NUMBER(38,6) | Short open interest in USD. |
| total\_open\_interest\_usd | NUMBER(38,6) | Long plus short open interest in USD. |
| funding\_rate | NUMBER(38,18) | Last funding rate of the day. Ostium is per block, with 18 decimal places; positive means longs pay shorts. Null for GMX. |
| premium | NUMBER(38,18) | Last premium of the day. Ostium is per block, with 18 decimal places. Null for GMX. |
| mark\_price\_usd | NUMBER(38,6) | Last mark of the day in USD. Ostium is null before 2025-03-03 and null for HSI-HKD. |
| extra\_fields | VARIANT | Protocol-specific values for this market and day. |
| unique\_id | VARCHAR(16777216) | Unique identifier for the row. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database. |

### Sample Query

```sql theme={null}
SELECT *
FROM arbitrum.perpetuals.open_interest
WHERE activity_date = '2026-10-01'
LIMIT 100;
```