Perpetual Positions Daily

To filter to currently-open positions use WHERE NOT is_tombstone. Use last_activity_timestamp rather than time_slice for freshness.

Table Columns

Identifiers

Column Name	Description
time_slice	Calendar day for this row.
user	User wallet address.
type	Position type. Currently ‘oneWay’.
coin	Coin of the position.
timestamp	End-of-day timestamp (midnight TIMESTAMP_NTZ).
last_activity_timestamp	Sub-second timestamp of the most recent observed activity for this (user, type, coin).
is_tombstone	True when the position for this day is known to be closed. Use `WHERE NOT is_tombstone` to filter to open positions.
closure_ts	For tombstone rows, the earliest fill timestamp at which the position reached zero. NULL otherwise.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Position

Column Name	Description
szi	Size of the position. ‘0’ on tombstone rows.
leverage_type	Type of leverage. NULL on tombstone rows.
leverage_value	Leverage multiplier. NULL on tombstone rows.
entry_px	Entry price. NULL on tombstone rows.
position_value	Position value. Zeroed on tombstone rows.
unrealized_pnl	Unrealized PnL. Zeroed on tombstone rows.
return_on_equity	Return on equity. Zeroed on tombstone rows.
liquidation_price	Price that would trigger liquidation. NULL on tombstone rows.
margin_used	Margin used. Zeroed on tombstone rows.
max_leverage	Maximum leverage allowed. NULL on tombstone rows.

Funding

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

SELECT time_slice, user, coin, szi, position_value, unrealized_pnl FROM hyperliquid.assets.perpetual_positions_daily WHERE time_slice >= CURRENT_DATE - 7 AND coin = 'BTC' AND NOT is_tombstone ORDER BY time_slice DESC, 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