Market Metrics

arbitrum.perpetuals.market_metrics contains Variational Omni per-market snapshots on Arbitrum, archived hourly. One row per market per snapshot, with mark price, open interest, funding, and quote depth.

Table Columns

Column Name	Description	Type	Example
project	The perpetuals project.	varchar	variational
protocol	The specific protocol within the project.	varchar	omni
version	Protocol version.	varchar	v1
chain	Blockchain network.	varchar	arbitrum
snapshot_ts	Hour-truncated snapshot timestamp (UTC).	timestamp_ntz	2026-07-24 22:00:00
partition_date	Snapshot date (UTC).	date	2026-07-24
ticker	Market ticker.	varchar	BR
name	Market display name.	varchar	Bedrock
mark_price	Mark price at snapshot time.	number	0.147183573552
volume_24h_usd	Trailing 24-hour volume in USD for this market.	number	1173.918440
long_open_interest_usd	Open interest held in long positions in USD.	number	658.533388
short_open_interest_usd	Open interest held in short positions in USD.	number	1329.980059
total_open_interest_usd	Total open interest in USD.	number	1988.513447
funding_rate	Funding rate at snapshot time.	number	0.109500000000
extra_fields	VARIANT column with additional per-market metadata.	variant
unique_key	Unique identifier for the row.	varchar	BR\|2026072422
ingested_at	Time the snapshot was ingested (UTC).	timestamp_ntz	2026-07-24 22:14:40

Sample Query

SELECT *
FROM arbitrum.perpetuals.market_metrics
WHERE partition_date = '2026-07-24'
ORDER BY total_open_interest_usd DESC;

Market Overview Overview

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query