Skip to main content
Schema: hypercore.core Table: ez_perp_funding_rates Type: View

​
What

Historical hourly funding rates for perpetual markets, enriched with market metadata. Positive funding rate means longs pay shorts; negative means shorts pay longs. This table has the longest historical data, reaching back to Hyperliquid’s launch in 2023.

​
Key Use Cases

  • Analyzing funding rate trends and mean-reversion patterns
  • Calculating annualized funding rate APR
  • Comparing funding rates across exchanges
  • Understanding market sentiment via funding bias
  • Identifying funding rate arbitrage opportunities

​
Important Relationships

  • Derived from silver__funding_rates via Streamline API
  • Enriched with core__dim_perp_markets via coin
  • Related to core__ez_perp_funding_payments for per-user impact

​
Commonly-used Fields

  • coin: Perp asset identifier
  • funding_time: When the funding rate was applied
  • funding_rate: Hourly funding rate (positive = longs pay shorts)
  • premium: Premium component of the funding rate

​
Sample queries

-- Funding rate arbitrage: which markets pay the most? (last 7 days)
SELECT
    coin,
    ROUND(AVG(funding_rate) * 100, 4) AS avg_funding_pct,
    ROUND(AVG(funding_rate) * 365 * 3 * 100, 2) AS annualized_pct,
    ROUND(AVG(premium) * 100, 4) AS avg_premium_pct,
    COUNT(*) AS observations
FROM hypercore.core.ez_perp_funding_rates
WHERE funding_time >= DATEADD('day', -7, CURRENT_DATE)
GROUP BY 1
HAVING observations >= 20
ORDER BY annualized_pct DESC
LIMIT 15;

​
Columns

Column NameData TypeDescription
COINTEXTRaw asset identifier. Perps use plain ticker (e.g. BTC), spot uses @token_index format (e.g. @2), prelaunch uses xyz:name prefix.
ASSET_INDEXNUMBERNumeric index for the asset on the Hyperliquid exchange.
SIZE_DECIMALSNUMBERDecimal precision for order sizes on this market.
MAX_LEVERAGENUMBERMaximum allowed leverage for this perpetual market.
FUNDING_TIMETIMESTAMP_NTZTimestamp when the funding rate was applied.
FUNDING_RATEFLOATHourly funding rate. Positive means longs pay shorts; negative means shorts pay longs.
PREMIUMFLOATPremium component of the funding rate, reflecting the price difference between the perp and oracle.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified in this table (Snowflake SYSDATE).
EZ_PERP_FUNDING_RATES_IDTEXTSurrogate key for funding rate records
_INVOCATION_IDTEXTdbt invocation identifier for tracking which run produced this record.