Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The hyperliquid.assets.perpetual_positions_latest view contains the latest perpetual position per (user, type, coin) on Hyperliquid. Every row represents a currently-open position.
Use last_activity_timestamp for freshness checks.

​
Table Columns

​
Identifiers

Column NameDescription
userUser wallet address.
typePosition type. Currently ‘oneWay’.
coinCoin of the position.
last_activity_timestampSub-second timestamp of the most recent observed activity for this (user, type, coin).
block_dateCalendar date for this row (midnight UTC).
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Position

Column NameDescription
sziSize of the position.
leverage_typeType of leverage used (e.g. ‘cross’, ‘isolated’).
leverage_valueLeverage multiplier.
entry_pxEntry price.
position_valuePosition value.
unrealized_pnlUnrealized PnL.
return_on_equityReturn on equity.
liquidation_pricePrice that would trigger liquidation.
margin_usedMargin used to maintain the position.
max_leverageMaximum leverage allowed for this position.

​
Funding

Column NameDescription
cumulative_funding_all_timeCumulative funding paid / received all time.
cumulative_funding_since_openCumulative funding paid / received since the position was opened.
cumulative_funding_since_changeCumulative funding paid / received since the last position change.

​
Sample Query

SELECT
  user,
  coin,
  szi,
  position_value,
  unrealized_pnl,
  last_activity_timestamp
FROM hyperliquid.assets.perpetual_positions_latest
WHERE coin = 'BTC'
ORDER BY ABS(position_value::float) DESC
LIMIT 100