Snapshots

Daily position snapshots, spot balances, and account values.

Daily snapshots of all trader positions, spot token balances, and account values. Taken from the on-chain ABCI state at end of day. Available from August 2025 onward.

Some dates may be missing if the ABCI state file was not available. This is normal — check the S3 listing for available dates. The gap from late October to mid-December 2025 is a known period without ABCI state captures.

S3 Paths

Bucket: s3://hydromancer-reservoir (requester pays)

global/snapshots/perp/all/date=YYYY-MM-DD/{block}_{timestamp}.parquet
global/snapshots/spot/date=YYYY-MM-DD/{block}_{timestamp}.parquet
global/snapshots/account_values/date=YYYY-MM-DD/{block}_{timestamp}.parquet

by_dex/{dex}/snapshots/perp/date=YYYY-MM-DD/{block}_{timestamp}.parquet

File names include the block number and timestamp (milliseconds) from the ABCI state, e.g., 926030000_1773706027926.parquet.

Perp Snapshot Schema

One row per user per market. Contains every open perpetual position.

Column
Type
Description

user

string

Wallet address

market

string

Market name (e.g., BTC, xyz:MSFT)

size

float64

Position size (positive = long, negative = short)

notional

float64

Position notional value (USD)

entry_price

float64

Average entry price

liquidation_price

float64?

Estimated liquidation price (null if not calculable)

leverage_type

string

cross or isolated

leverage

uint32

Leverage multiplier

funding_pnl

float64

Cumulative funding PnL (USD)

account_value

float64

Margin available on the collateral token of the traded market. For Hyperliquid native markets this is the USDC margin. For HIP-3 dexes this is the margin in the dex's collateral token (e.g., USDE for HyENA, USDH for Felix). Includes spot collateral for unified accounts.

account_mode

string?

standard, dex_abstraction, unified, portfolio_margin

Spot Snapshot Schema

One row per user per token. Contains all spot token holdings with positive balance.

Column
Type
Description

user

string

Wallet address

token

string

Token name (e.g., USDC, HYPE, PURR)

balance

float64

Token balance

entry_value

float64

Entry value in USD

Account Values Schema

One row per user per dex. Aggregated account-level metrics.

Column
Type
Description

user

string

Wallet address

dex

string

DEX name

collateral_token

string

Collateral token (e.g., USDC, USDE)

account_value

float64

Total margin available on the dex's collateral token. For Hyperliquid this is the USDC equity. For HIP-3 dexes this is the equity in the dex's collateral token. Includes spot collateral for unified accounts.

total_long_notional

float64

Sum of long position notionals

total_short_notional

float64

Sum of short position notionals

account_mode

string?

Account abstraction mode

Quick Start

DuckDB

Last updated