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