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

# Overview 🌱

> Daily Perpl protocol metrics on Monad.

### Table Details

| Property | Value |
| - | - |
| Table Name | `monad.perpetuals.overview` |
| Table Status | Beta 🌱 |
| Unique Key | `activity_date`, `project`, `protocol`, `version` |

`monad.perpetuals.overview` has one row per protocol per UTC day: volume, open interest, TVL, fees, revenue, deposits, withdrawals, and active users. `total_volume_usd` counts each match once. Protocol-specific metrics are in `extra_fields`.

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 | Metric date (UTC 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. |
| total\_tvl\_usd | FLOAT | USD value of the AUSD held by the Perpl exchange at end of day. |
| total\_volume\_usd | NUMBER(38,6) | Trading volume in USD on the day, counting each match once. |
| total\_volume\_24h\_usd | NUMBER(38,6) | Null for Perpl. |
| cumulative\_volume\_usd | NUMBER(38,6) | All-time trading volume in USD up to and including the 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. |
| 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\_revenue\_usd | FLOAT | Protocol revenue in USD on the day. |
| cumulative\_revenue\_usd | FLOAT | All-time protocol revenue in USD up to and including the day. |
| total\_fees\_usd | NUMBER(38,6) | Fees charged on the day, in USD. |
| cumulative\_fees\_usd | NUMBER(38,6) | All-time fees in USD up to and including the day. |
| trade\_count | NUMBER(38,0) | Number of matched fills on the day. |
| liquidations\_count | NUMBER(38,0) | Number of liquidations on the day. |
| deposit\_count | NUMBER(38,0) | Number of collateral deposits on the day. |
| deposit\_usd | NUMBER(38,6) | Collateral deposited on the day, in USD. |
| withdrawal\_count | NUMBER(38,0) | Number of collateral withdrawals on the day. |
| withdrawal\_usd | NUMBER(38,6) | Collateral withdrawn on the day, in USD. |
| active\_users | NUMBER(38,0) | Distinct accounts with a position change on the day. |
| extra\_fields | VARIANT | Protocol-specific daily breakdown: volume by market and by action, maker, taker, builder, insurance, liquidation, and recycle fees, realized PnL, funding settled, markets with open interest, and protocol payouts to accounts. |
| 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, total_volume_usd, total_open_interest_usd, total_tvl_usd, total_fees_usd, total_revenue_usd, active_users
FROM monad.perpetuals.overview
WHERE project = 'perpl'
ORDER BY activity_date DESC
LIMIT 30;
```