HyperLiquid Tables

Tables containing HyperLiquid perpetual exchange data including trades, orders, and funding rates.

Last updated: 2026-05-23 21:01 UTC

Tables (4)

Statistic	Value
Rows	425,720,908
Size	10.15 GB
Partition Key	`toYYYYMM(utc_first_fill_dt)`
TTL	`utc_first_fill_dt + toIntervalDay(90)`

Columns:

Column	Type	Description
`utc_first_fill_dttm`	`SimpleAggregateFunction(min, DateTime64(3, 'UTC'))`	UTC datetime of the first fill for this order
`utc_first_fill_dt`	`Date`	UTC date of the first fill (for partitioning)
`order_id`	`Int64`	Unique order identifier
`wallet_address`	`String`	Wallet address of the trader
`coin`	`String`	Trading pair symbol (e.g., BTC, ETH)
`side`	`String`	Trade side (Buy/Sell)
`twap_id`	`Nullable(Int64)`	TWAP order identifier (if part of TWAP)
`size`	`SimpleAggregateFunction(sum, Float64)`	Total filled size (in contracts)
`volume`	`SimpleAggregateFunction(sum, Float64)`	Total filled volume in USD
`closed_pnl`	`SimpleAggregateFunction(sum, Float64)`	Realized PnL from this order

Example Query:

ClickHouse (hyperliquid)

Columns:

Column	Type	Description
`utc_fill_dttm`	`DateTime64(3, 'UTC')`	UTC datetime of the fill (millisecond precision)
`utc_fill_dt`	`Date`	UTC date of the fill (for partitioning)
`fill_id`	`Int64`	Unique fill identifier
`fill_hash`	`String`	Hash of the fill
`fill_type`	`String`	Type of fill (trade, liquidation, etc.)
`utc_block_dttm`	`DateTime64(9, 'UTC')`	UTC datetime of the block (nanosecond precision)
`block_id`	`Int64`	HyperLiquid block number
`block_tx_idx`	`UInt16`	Transaction index within the block
`wallet_address`	`String`	Wallet address of the trader
`coin`	`String`	Trading pair symbol (e.g., BTC, ETH)
`price`	`Float64`	Execution price
`size`	`Float64`	Fill size (in contracts)
`side`	`String`	Trade side (Buy/Sell)
`start_position`	`Float64`	Position size before fill
`closed_pnl`	`Float64`	Realized PnL from this fill
`order_id`	`Int64`	Order identifier
`order_crossed_spread_flg`	`Bool`	Whether order crossed the spread
`fee`	`Float64`	Trading fee
`fee_token`	`String`	Token used for fee payment
`client_order_id`	`Nullable(String)`	Client-provided order ID
`builder_fee`	`Nullable(Float64)`	Builder/API fee
`builder`	`Nullable(String)`	Builder/API identifier
`liquidation_user`	`Nullable(String)`	User being liquidated (if liquidation)
`liquidation_mark_px`	`Nullable(Float64)`	Mark price at liquidation
`liquidation_method`	`Nullable(String)`	Liquidation method used
`twap_id`	`Nullable(Int64)`	TWAP order identifier
`deployer_fee`	`Nullable(Float64)`	Deployer fee for spot tokens
`priority_gas`	`Nullable(Float64)`	Priority gas fee paid for inclusion (in USDC)

Example Query:

ClickHouse (hyperliquid)

Statistic	Value
Rows	0
Size	0 B

Columns:

Column	Type	Description
`wallet_address`	`String`	Wallet address of the trader
`total_pnl`	`Float64`	Total realized profit and loss across all positions
`total_volume`	`Float64`	Total trading volume in USD
`cnt_unique_orders`	`UInt64`	Count of unique orders placed
`last_utc_order_dt`	`SimpleAggregateFunction(max, Date)`	UTC date of the most recent order
`win_count`	`UInt64`	Number of profitable trades
`total_count`	`UInt64`	Total number of completed trades
`sum_order_roi`	`Float64`	Sum of return on investment across all orders
`sum_profitable_pnl`	`Float64`	Sum of PnL from profitable trades
`cnt_profitable_orders`	`UInt64`	Count of profitable orders
`sum_unprofitable_pnl`	`Float64`	Sum of PnL from unprofitable trades (negative)
`cnt_unprofitable_orders`	`UInt64`	Count of unprofitable orders
`cnt_unique_coins`	`UInt64`	Number of unique trading pairs traded
`cnt_trade_days`	`UInt64`	Number of distinct days with trading activity
`roi_quantiles`	`Array(Float64)`	ROI distribution quantiles for the wallet

Example Query:

ClickHouse (hyperliquid)

Statistic	Value
Rows	0
Size	0 B

Columns:

Column	Type	Description
`wallet_address`	`String`	Wallet address of the trader
`coin`	`String`	Trading pair symbol (e.g., BTC, ETH)
`last_position_size`	`Float64`	Current position size (positive=long, negative=short)
`last_position_update_dttm`	`DateTime64(3, 'UTC')`	UTC datetime of the last position update

Example Query:

ClickHouse (hyperliquid)