Perpetual Funding Events - Allium Documentation Hub

The hyperliquid.assets.perpetual_funding_events view contains one row per perpetual funding settlement for native Hyperliquid perps and HIP-3 perps. Spot markets and HIP-4 prediction markets are not included. funding_amount is denominated in the market’s collateral token. Do not treat that column as USD unless the collateral token is a dollar stablecoin at peg. funding_amount_usd is the same settlement converted at the collateral token’s 5-minute USD price and is null when that price is missing. Coverage starts at 2025-06-04 21:00:00.050720 UTC.

Always filter with WHERE user = .... User-scoped queries are the supported access pattern.

Table Details

Property	Value
Table Name	`hyperliquid.assets.perpetual_funding_events`
Table Status	Production-Ready
Unique Key	`unique_id`

Table Columns

Column Name	Data Type	Description
unique_id	VARCHAR(16777216)	Unique identifier for the funding settlement.
user	VARCHAR(16777216)	User wallet address.
coin	VARCHAR(16777216)	Perpetual market coin, including HIP-3 names such as `xyz:NVDA`.
perp_dex	VARCHAR(16777216)	HIP-3 DEX name. Empty for native Hyperliquid perps.
collateral_token	VARCHAR(16777216)	Collateral token symbol for the market (for example USDC, USDE, USDH, USDT0).
collateral_token_id	VARCHAR(16777216)	Hyperliquid token identifier for the collateral token.
timestamp	TIMESTAMP_NTZ(9)	UTC timestamp of the funding settlement.
funding_amount	NUMBER(38,18)	Signed funding in collateral-token units. Positive means received; negative means paid.
funding_rate	NUMBER(38,18)	Funding rate applied at this settlement.
szi	NUMBER(38,18)	Signed position size at settlement.
hash	VARCHAR(16777216)	Event hash. A zero hash is expected for funding settlements.
collateral_token_usd_price	FLOAT	USD price of one collateral-token unit at the settlement time. Null when no price is available.
funding_amount_usd	FLOAT	USD value of the funding settlement. Null when `collateral_token_usd_price` is null.
_created_at	TIMESTAMP_NTZ(9)	Row creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Row last update timestamp.

Sample Query

SELECT
  timestamp,
  coin,
  collateral_token,
  funding_amount,
  funding_rate,
  szi,
  funding_amount_usd
FROM hyperliquid.assets.perpetual_funding_events
WHERE user = '0x9237794d8e5c6eb247b20f2e5edd9ad5f530d8ec'
  AND timestamp >= '2026-08-17'
  AND timestamp < '2026-09-16'
ORDER BY timestamp
LIMIT 100;

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query