Perpetual Positions EOD (Unhydrated)

The hyperliquid.unhydrated.perpetual_positions_eod table contains end-of-day perpetual position snapshots for every (user, type, coin) on Hyperliquid. One row per day, keeping the last snapshot of the day.

Table Columns

Identifiers

Column Name	Description
block_date	Calendar date of the position snapshot.
user	User wallet address.
type	Position type. Currently always ‘oneWay’.
coin	Coin of the position.
timestamp	Timestamp of the last snapshot taken on this day.
_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.

Sample Query

SELECT
  block_date,
  user,
  coin,
  szi,
  entry_px,
  position_value,
  unrealized_pnl
FROM hyperliquid.unhydrated.perpetual_positions_eod
WHERE block_date >= CURRENT_DATE - 7
ORDER BY block_date DESC, ABS(position_value) DESC
LIMIT 100

Spot Balances EOD (Unhydrated)Summaries EOD (Unhydrated)

⌘I

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