> ## 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, and mark price per Perpl market on Monad.

### Table Details

| Property | Value |
| - | - |
| Table Name | `monad.perpetuals.open_interest` |
| Table Status | Beta 🌱 |
| Unique Key | `unique_id` |

`monad.perpetuals.open_interest` has one row per market per UTC day from the market's listing. Open interest is the USD value of open long and short positions at end of day. Perpl is an order book, so long equals short and `total_open_interest_usd` equals each side.

Coverage is Perpl (`project = 'perpl'`, `protocol = 'perpl'`, `version = 'v1'`). See [Perpl](https://docs.allium.so/historical-data/perpetuals/perpl.md) for venue notes.

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| activity\_date | DATE | UTC calendar day. The latest day includes activity up to the latest refresh. |
| project | VARCHAR(16777216) | The perpetuals project. |
| protocol | VARCHAR(16777216) | The specific protocol within the project. |
| version | VARCHAR(16777216) | Protocol version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| pair\_index | NUMBER(38,0) | Perpl numeric market id. |
| market\_symbol | VARCHAR(16777216) | Market symbol as base-USD, for example BTC-USD. A relisted market keeps its symbol and has a new `pair_index`. |
| from\_symbol | VARCHAR(16777216) | Base symbol of the market. |
| to\_symbol | VARCHAR(16777216) | Quote symbol of the market (USD). |
| long\_open\_interest\_usd | NUMBER(38,6) | Long open interest in USD at end of day. |
| short\_open\_interest\_usd | NUMBER(38,6) | Short open interest in USD at end of day. |
| total\_open\_interest\_usd | NUMBER(38,6) | Open interest in USD, counted once. On an order book every long is matched by a short, so this equals each side. |
| funding\_rate | NUMBER(38,18) | Last funding rate of the day as a fraction per funding interval of 8,571 Monad blocks (about 57 minutes until July 2026, about 43 minutes since August 2026). Positive when longs pay shorts. |
| premium | NUMBER(38,18) | Null. Perpl does not publish a premium series. |
| mark\_price\_usd | NUMBER(38,6) | Latest on-chain mark price in USD as of end of day. |
| extra\_fields | VARIANT | Protocol-specific market state: lots long and short, open positions, raw and specified funding rates, funding price, funding event count, and oracle index price. |
| 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 activity_date, market_symbol, total_open_interest_usd, funding_rate, mark_price_usd
FROM monad.perpetuals.open_interest
WHERE activity_date >= current_date - 30
  AND project = 'perpl'
ORDER BY activity_date DESC, total_open_interest_usd DESC;
```