fact_mid_prices

hypercore.core.fact_mid_prices

Schema: hypercore.core Table: fact_mid_prices Type: View

What

Point-in-time mid-market prices (average of best bid and ask) for all listed assets on Hyperliquid. Snapshot data collected periodically via the Streamline REST API.

Key Use Cases

• Tracking real-time price movements across all assets
• Building price reference data for valuation
• Analyzing spread dynamics when combined with L2 book data
• Monitoring price discovery for newly listed assets

Important Relationships

• Can be joined to core__dim_perp_markets or core__dim_spot_markets via coin
• Complements core__ez_perp_l2_book for full order book analysis

Commonly-used Fields

• coin: Asset identifier
• mid_price: Mid-market price
• snapshot_timestamp: When the snapshot was taken

Columns

Column Name	Data Type	Description
COIN	TEXT	Raw asset identifier. Perps use plain ticker (e.g. BTC), spot uses @token_index format (e.g. @2), prelaunch uses xyz:name prefix.
MID_PRICE	FLOAT	Mid-market price, calculated as the average of the best bid and ask.
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).
FACT_MID_PRICES_ID	TEXT	Surrogate key for mid price records
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.