Market Overview - Allium Documentation Hub

arbitrum.perpetuals.market_overview contains Variational Omni platform-level snapshots on Arbitrum, archived hourly. One row per protocol per snapshot.

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
total_volume_24h_usd	Reported trailing 24-hour volume in USD.	number	793071819.332556
cumulative_volume_usd	Reported cumulative volume in USD.	number	278288926174.024731
total_tvl_usd	Total value locked in USD.	number	138499148.874048
total_open_interest_usd	Total open interest in USD.	number	1332215367.723570
num_markets	Number of markets listed on the platform at snapshot time.	number	517
extra_fields	VARIANT column with platform-specific fields.	variant
unique_key	Unique identifier for the row.	varchar	2026072422
ingested_at	Time the snapshot was ingested (UTC).	timestamp_ntz	2026-07-24 22:14:40

Sample Query

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

⌘I