dim_spot_markets

hypercore.core.dim_spot_markets

Schema: hypercore.core Table: dim_spot_markets Type: View

What

Reference table of all HIP-1 spot tokens deployed on HyperCore, enriched with token details including supply, deployer, and pricing. Covers all tokens tradeable on the Hyperliquid spot order book.

Key Use Cases

• Looking up token metadata (name, supply, deployer)
• Mapping token_index to human-readable names
• Filtering canonical vs non-canonical tokens
• Enriching spot trade data with token details

Important Relationships

• Joined by core__ez_spot_trades and core__ez_spot_asset_snapshots via token_index
• Combines silver__spot_metadata with silver__token_details for complete token info

Commonly-used Fields

• token_index: Numeric token index on the exchange
• token_name / full_name: Token ticker and full name
• token_id: Unique token identifier
• is_canonical: Whether this is the canonical version
• total_supply / circulating_supply: Token supply metrics
• is_delisted: Whether the token has been delisted

Columns

Column Name	Data Type	Description
TOKEN_INDEX	NUMBER	Numeric index for the spot token on the exchange.
TOKEN_ID	TEXT	Unique identifier (hex address) for the spot token.
TOKEN_NAME	TEXT	Ticker symbol for the spot token.
FULL_NAME	TEXT	Full descriptive name of the spot token.
SPOT_INDEX	NUMBER	Spot market pair index on the exchange.
IS_CANONICAL	BOOLEAN	Boolean indicating whether this is the canonical version of the token.
EVM_CONTRACT	VARIANT	HyperEVM contract address for the token, if deployed.
IS_DELISTED	BOOLEAN	Boolean indicating whether this market or token has been delisted from the exchange.
DEPLOYER	TEXT	Address that deployed the token.
TOTAL_SUPPLY	TEXT	Total supply of the token.
CIRCULATING_SUPPLY	TEXT	Circulating supply of the token.
MARK_PRICE	TEXT	Mark price used for margining and liquidation calculations.
MID_PRICE	TEXT	Mid-market price, calculated as the average of the best bid and ask.
PREV_DAY_PRICE	TEXT	Previous day’s closing price.
GENESIS	VARIANT	Genesis configuration data for the token.
INSERTED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when the record was last modified in this table (Snowflake SYSDATE).
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.