hyperliquid.metrics.overview_by_coin table provides daily Hyperliquid trading metrics broken out per coin and market type. Each row is one (activity_date, coin, market_type) combination, covering native perpetuals, spot, and HIP-3 permissionless perpetual markets. It is the per-coin cut of hyperliquid.metrics.overview. This table is updated daily.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.metrics.overview_by_coin |
| Table Status | Production-Ready |
| Unique Key | activity_date, coin, market_type |
| Clustering Key(s) | activity_date::date |
Table Columns
General
| Column Name | Data Type | Description |
|---|---|---|
| activity_date | TIMESTAMP_NTZ(9) | The date of the activity. |
| coin | VARCHAR(16777216) | The coin / market symbol (e.g. BTC, ETH, HYPE). |
| market_type | VARCHAR(16777216) | The market type for this row: perpetuals or spot. |
| is_hip3 | BOOLEAN | Whether this is a HIP-3 permissionless perpetual market. |
| perp_dex | VARCHAR(16777216) | The HIP-3 builder DEX name for this market. NULL for native main-dex perpetuals and spot. |
| volume_usd | FLOAT | Daily trading volume in USD for this coin and market type. |
| trade_count | NUMBER(38,0) | Daily number of trades for this coin and market type. |
| active_buyers | NUMBER(38,0) | Daily number of unique buyers for this coin and market type. |
| active_sellers | NUMBER(38,0) | Daily number of unique sellers for this coin and market type. |
| open_interest_usd | FLOAT | Daily average open interest in USD for this coin. Populated for perpetuals rows only; NULL for spot. |
| avg_oracle_price | FLOAT | Daily average oracle price of this coin. Populated for perpetuals rows only; NULL for spot. |
| _created_at | TIMESTAMP_NTZ(9) | Row creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Row last update timestamp. |
| _changed_since_full_refresh | BOOLEAN | Change-tracking flag for row updates. |
Trading Volume
| Column Name | Description | |
|---|---|---|
| volume_usd | Daily trading volume in USD for this coin and market type. | The daily trading volume in USD for this DEX. |
| trade_count | Daily number of trades for this coin and market type. | Number of trades or swaps included in this aggregated record. |
Users
| Column Name | Description | |
|---|---|---|
| active_buyers | Daily number of unique buyers for this coin and market type. | Number of unique buyer addresses that executed at least one trade on this day. |
| active_sellers | Daily number of unique sellers for this coin and market type. | Number of unique seller addresses that executed at least one trade on this day. |
Open Interest
| Column Name | Description | |
|---|---|---|
| open_interest_usd | Daily average open interest in USD for this coin. Populated for perpetuals rows only; NULL for spot. | Daily average USD open interest for this coin. Single-sided base-coin open interest valued at oracle price, averaged over the day. Populated for perpetuals rows only; NULL for spot rows. |
| avg_oracle_price | Daily average oracle price of this coin. Populated for perpetuals rows only; NULL for spot. | Daily average oracle price of this coin. Populated for perpetuals rows only; NULL for spot rows. |
Lineage
| Column Name | Description | |
|---|---|---|
| _created_at | Row creation timestamp. | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | Row last update timestamp. | 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). |
| _changed_since_full_refresh | Change-tracking flag for row updates. | Flag indicating whether this row was created or modified after the last full refresh of the model. Useful for identifying recently added or updated records in incremental processing. Same concept as _change_since_full_refresh — the column name varies by model generation. |