Perpetual Positions Latest

Use last_activity_timestamp for freshness checks.

Table Columns

Identifiers

Column Name	Description
user	User wallet address.
type	Position type. Currently ‘oneWay’.
coin	Coin of the position.
last_activity_timestamp	Sub-second timestamp of the most recent observed activity for this (user, type, coin).
block_date	Calendar date for this row (midnight UTC).
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Position

Column Name	Description
szi	Size of the position.
leverage_type	Type of leverage used (e.g. ‘cross’, ‘isolated’).
leverage_value	Leverage multiplier.
entry_px	Entry price.
position_value	Position value.
unrealized_pnl	Unrealized PnL.
return_on_equity	Return on equity.
liquidation_price	Price that would trigger liquidation.
margin_used	Margin used to maintain the position.
max_leverage	Maximum leverage allowed for this position.

Funding

Column Name	Description
cumulative_funding_all_time	Cumulative funding paid / received all time.
cumulative_funding_since_open	Cumulative funding paid / received since the position was opened.
cumulative_funding_since_change	Cumulative funding paid / received since the last position change.

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Identifiers

Position

Funding

Sample Query

​Table Columns

​Identifiers

​Position

​Funding

​Sample Query

Table Columns

Identifiers

Position

Funding

Sample Query