ez_perp_predicted_fundings

hypercore.core.ez_perp_predicted_fundings

Schema: hypercore.core Table: ez_perp_predicted_fundings Type: View

What

Predicted next funding rates from multiple venues, enriched with market metadata. Provides forward-looking funding rate estimates useful for trading decisions.

Key Use Cases

• Forecasting upcoming funding costs
• Comparing predicted rates across venues
• Identifying funding rate convergence/divergence
• Planning position entry/exit around funding events

Important Relationships

• Derived from silver__predicted_fundings via Streamline API
• Enriched with core__dim_perp_markets via coin
• Forward-looking complement to core__ez_perp_funding_rates

Commonly-used Fields

• coin: Perp asset identifier
• venue: Venue providing the prediction
• predicted_funding_rate: Predicted next funding rate
• next_funding_time: When the next funding will be applied
• snapshot_timestamp: When this prediction was recorded

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.
ASSET_INDEX	NUMBER	Numeric index for the asset on the Hyperliquid exchange.
SIZE_DECIMALS	NUMBER	Decimal precision for order sizes on this market.
MAX_LEVERAGE	NUMBER	Maximum allowed leverage for this perpetual market.
VENUE	TEXT	Venue or exchange providing the predicted funding rate.
PREDICTED_FUNDING_RATE	FLOAT	Predicted funding rate for the next funding period.
NEXT_FUNDING_TIME	TIMESTAMP_NTZ	Timestamp when the next funding rate will be applied.
FUNDING_INTERVAL_HOURS	NUMBER	Number of hours between funding periods.
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_PERP_PREDICTED_FUNDINGS_ID	TEXT	Surrogate key for predicted funding records
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.