Metrics Daily - Allium Documentation Hub

arbitrum.perpetuals.metrics_daily contains Variational Omni daily on-chain total value locked on Arbitrum, with one row per day, address_type, and token.

Table Columns

Column Name	Description	Type	Example
date	End-of-day date (UTC) of the balance snapshot.	date	2026-07-24
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
address_type	Component of protocol-controlled value: settlement_pools, core_olp_vault, or treasury.	varchar	core_olp_vault
token_address	Token address.	varchar	0xaf88d065e77c8cc2239327c5edb3a432268e5831
token_symbol	Token symbol.	varchar	USDC
balance	End-of-day token balance for this address type.	number	15682293.109176
balance_usd	End-of-day USD balance for this address type.	number	15679841.339471
address_count	Number of distinct addresses of this address type holding the token on the date.	number	1
unique_id	Unique identifier for the row.	varchar	2026-07-24_core_olp_vault_0xaf88d065e77c8cc2239327c5edb3a432268e5831

Sample Query

SELECT *
FROM arbitrum.perpetuals.metrics_daily
WHERE date = '2026-07-24'
ORDER BY balance_usd DESC;

⌘I