Table Details
| Property | Value |
|---|---|
| Table Name | arbitrum.perpetuals.market_overview |
| Table Status | Beta 🌱 |
| Unique Key | project, protocol, unique_key |
| Clustering Key(s) | partition_date |
Sample Query
SELECT *
FROM arbitrum.perpetuals.market_overview
WHERE partition_date = '2026-07-24'
ORDER BY snapshot_ts DESC;
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| version | VARCHAR(16777216) | Schema version discriminator. |
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| snapshot_ts | TIMESTAMP_NTZ(9) | Hour-truncated snapshot timestamp (UTC) from the metadata API. |
| partition_date | DATE | Snapshot date (UTC), used for partitioning. |
| total_volume_24h_usd | NUMBER(38,6) | Reported trailing-24h trading volume in USD. |
| cumulative_volume_usd | NUMBER(38,6) | Reported cumulative trading volume in USD to date. |
| total_tvl_usd | NUMBER(38,6) | Total value locked in USD. |
| total_open_interest_usd | NUMBER(38,6) | Total open interest in USD (long plus short). NULL when the venue does not report open interest. |
| num_markets | NUMBER(38,0) | Number of markets listed on the platform at snapshot time. |
| extra_fields | VARIANT | Protocol-specific platform fields as a JSON object. Keys: loss_refund_pool_size_usd (reported loss-refund pool size in USD; the program wound down on 2026-04-19), loss_refund_refunded_24h_usd (reported trailing-24h loss refunds in USD). |
| unique_key | VARCHAR(16777216) | Unique record key. |
| ingested_at | TIMESTAMP_NTZ(9) | Data ingestion timestamp. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |