Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Daily Perpl TVL on Monad by protocol component and token.
| Property | Value |
|---|---|
| Table Name | monad.perpetuals.metrics_daily |
| Table Status | Beta 🌱 |
| Unique Key | date, project, address_type, token_address |
monad.perpetuals.metrics_daily has the end-of-day AUSD balance of the Perpl exchange (address_type = 'exchange'). total_tvl_usd on overview is this balance. The PLP vault is not included.
Coverage is Perpl (project = 'perpl', protocol = 'perpl', version = 'v1'). See Perpl for venue notes.
| Column Name | Data Type | Description |
|---|---|---|
| date | DATE | End-of-day date (UTC) of the balance snapshot. |
| 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. |
| address_type | VARCHAR(16777216) | Protocol component holding the balance: exchange. |
| token_address | VARCHAR(42) | Token address (AUSD). |
| token_symbol | VARCHAR(16777216) | Token symbol. |
| balance | NUMBER(38,6) | End-of-day token balance held by the component. |
| balance_usd | FLOAT | End-of-day balance in USD. |
| address_count | NUMBER(38,0) | Number of addresses in the component. |
| 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. |
SELECT date, address_type, token_symbol, balance, balance_usd
FROM monad.perpetuals.metrics_daily
WHERE project = 'perpl'
ORDER BY date DESC
LIMIT 30;
Was this page helpful?