ez_spot_asset_snapshots

hypercore.core.ez_spot_asset_snapshots

Schema: hypercore.core Table: ez_spot_asset_snapshots Type: View

What

Periodic snapshots of spot token market state, enriched with token metadata from dim_spot_markets. Includes volume, pricing, and supply data for HIP-1 tokens.

Key Use Cases

• Tracking spot token price trends
• Monitoring token supply changes
• Analyzing daily trading volume by token
• Comparing mark vs mid price for tokens

Important Relationships

• Derived from silver__spot_asset_contexts via Streamline API
• Enriched with core__dim_spot_markets via token_index
• Complements core__ez_spot_trades for spot market analysis

Commonly-used Fields

• token_index / token_name: Token identifier and name
• mark_price / mid_price / prev_day_price: Price metrics
• day_notional_volume: 24-hour notional volume
• circulating_supply / total_supply: Supply metrics
• snapshot_timestamp: When this snapshot was taken

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.
IS_CANONICAL	BOOLEAN	Boolean indicating whether this is the canonical version of the token.
DAY_NOTIONAL_VOLUME	FLOAT	24-hour notional trading volume for the market.
MARK_PRICE	FLOAT	Mark price used for margining and liquidation calculations.
MID_PRICE	FLOAT	Mid-market price, calculated as the average of the best bid and ask.
PREV_DAY_PRICE	FLOAT	Previous day’s closing price.
CIRCULATING_SUPPLY	FLOAT	Circulating supply of the token.
TOTAL_SUPPLY	FLOAT	Total supply of the token.
SNAPSHOT_TIMESTAMP	TIMESTAMP_LTZ	Timestamp when the market data snapshot was taken via Streamline API.
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).
EZ_SPOT_ASSET_SNAPSHOTS_ID	TEXT	Surrogate key for spot asset snapshot records
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.