Table Details
| Property | Value |
|---|---|
| Table Name | arbitrum.perpetuals.metrics_daily |
| Table Status | Beta 🌱 |
| Unique Key | date, address_type, token_address |
Sample Query
SELECT *
FROM arbitrum.perpetuals.metrics_daily
WHERE date = '2026-07-24'
ORDER BY balance_usd DESC;
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | DATE | End-of-day date (UTC) of the balance snapshot. |
| 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. |
| address_type | VARCHAR(16777216) | Component of protocol-controlled value: settlement_pools, core_olp_vault, or treasury. |
| token_address | VARCHAR(42) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”, “WETH”). |
| balance | NUMBER(38,6) | Sum of end-of-day token balances for this address_type. |
| balance_usd | FLOAT | Sum of end-of-day USD balances for this address_type (a TVL component). |
| address_count | NUMBER(38,0) | Number of distinct addresses of this address_type holding the token on this date. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _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). |