Table Details
| Property | Value |
|---|---|
| Table Name | arbitrum.perpetuals.market_metrics |
| Table Status | Beta 🌱 |
| Unique Key | project, protocol, unique_key |
| Clustering Key(s) | partition_date, ticker |
Sample Query
SELECT *
FROM arbitrum.perpetuals.market_metrics
WHERE partition_date = '2026-07-24'
ORDER BY total_open_interest_usd 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. |
| ticker | VARCHAR(16777216) | Market ticker (for example, BTC or XAU). |
| name | VARCHAR(16777216) | Market display name. |
| mark_price | NUMBER(38,12) | Mark price at snapshot time. |
| volume_24h_usd | NUMBER(38,6) | Trailing-24h volume in USD for this market. |
| long_open_interest_usd | NUMBER(38,6) | Long open interest in USD. |
| short_open_interest_usd | NUMBER(38,6) | Short open interest 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. |
| funding_rate | NUMBER(38,12) | Funding rate at snapshot time. |
| extra_fields | VARIANT | Protocol-specific per-market fields as a JSON object. Keys: funding_interval_s (funding interval in seconds); base_spread_bps (base spread in basis points); quote_updated_at (UTC time quotes were last updated); quote_base_bid, quote_base_ask (best bid/ask); quote_size_1k_bid/ask, quote_size_100k_bid/ask, quote_size_1m_bid/ask (bid/ask prices for 1k, 100k, and 1m-notional quotes). |
| 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). |