Trades 🌱

The hyperliquid.predictions.trades table contains every Hyperliquid HIP-4 prediction-market trade. event_name = 'Settlement' rows mark settlement events; all other rows are regular trades.

Table Details

Property	Value
Table Name	`hyperliquid.predictions.trades`
Table Status	Beta 🌱
Unique Key	`transaction_hash`, `unique_id`

Table Columns

Identifiers

Column Name	Data Type	Description
event_name	VARCHAR(16777216)	Event type: ‘Trade’ for a fill, ‘Settlement’ for a settlement event.
project	VARCHAR(16777216)	Top-level project namespace (`hyperliquid`).
protocol	VARCHAR(16777216)	Protocol within the project (`hyperliquid_hip4`).
chain	VARCHAR(16777216)	The blockchain network (`hyperliquid`).
exchange_type	VARCHAR(16777216)	Trade execution venue type (`orderbook`).
coin	VARCHAR(16777216)	HL-native side-token identifier (e.g. ‘#54760’).
encoding	NUMBER(38,0)	HL-canonical numeric encoding for the side-token.
outcome_id	NUMBER(38,0)	HIP-4 outcome identifier (shared by both token sides).
token_side	NUMBER(38,0)	Which side of the outcome’s YES/NO pair the row represents (0 or 1).
asset_id	NUMBER(38,0)	HL-canonical numeric identifier for the side-token.
maker_address	VARCHAR(16777216)	Maker (resting-order) address. NULL on synthetic mints.
taker_address	VARCHAR(16777216)	Taker (aggressing-order) address.
side_name	VARCHAR(16777216)	One of ‘BUY’, ‘SELL’, ‘SETTLE’. NULL on some synthetic-mint rows.
buyer_order_id	VARCHAR(16777216)	Order ID for the buyer’s order.
seller_order_id	VARCHAR(16777216)	Order ID for the seller’s order.
buyer_twap_id	VARCHAR(16777216)	TWAP order ID if the buyer’s order was a TWAP order.
seller_twap_id	VARCHAR(16777216)	TWAP order ID if the seller’s order was a TWAP order.
trade_id	VARCHAR(16777216)	The HL trade ID (`tid`).
price	NUMBER(22,10)	Trade price as a 0..1 probability.
size	NUMBER(22,10)	Trade size in side-tokens.
collateral_token	VARCHAR(16777216)	Collateral token symbol for the trade (e.g. ‘USDH’).
collateral_token_decimals	NUMBER(38,0)	Decimals of the collateral token.
collateral_amount	NUMBER(38,10)	Native-unit collateral value of the trade.
usd_exchange_rate	FLOAT	USD price of the collateral token. 1.0 for USDH.
usd_collateral_amount	FLOAT	USD value of the trade.
fee_token	VARCHAR(16777216)	Token in which the trade fee was paid (e.g. ‘USDH’, ‘USDC’). NULL when no fee was charged.
seller_fee_token	VARCHAR(16777216)	Token in which the seller’s fee was paid. HIP-4 buyer and seller can pay in different tokens.
buyer_fee_token	VARCHAR(16777216)	Token in which the buyer’s fee was paid.
buyer_fee	NUMBER(22,10)	Buyer-side fee in `buyer_fee_token` units.
seller_fee	NUMBER(22,10)	Seller-side fee in `seller_fee_token` units.
buyer_fee_usd	FLOAT	Buyer-side fee in USD.
seller_fee_usd	FLOAT	Seller-side fee in USD.
tx_fee	NUMBER(38,10)	Total fee for the transaction in native token units.
tx_fee_usd	FLOAT	Total fee for the transaction in USD.
builder_fee	NUMBER(22,10)	Total builder fee for the trade.
buyer_builder_fee	NUMBER(22,10)	Builder fee paid by the buyer, in `buyer_fee_token` units.
seller_builder_fee	NUMBER(22,10)	Builder fee paid by the seller, in `seller_fee_token` units.
buyer_builder_fee_usd	FLOAT	Buyer’s builder fee in USD.
seller_builder_fee_usd	FLOAT	Seller’s builder fee in USD.
buyer_builder_address	VARCHAR(16777216)	Builder address that received the buyer’s builder fee.
seller_builder_address	VARCHAR(16777216)	Builder address that received the seller’s builder fee.
buyer_dir	VARCHAR(16777216)	Direction string for the buyer leg (e.g. ‘Open Long’, ‘Settlement’).
seller_dir	VARCHAR(16777216)	Direction string for the seller leg.
is_synthetic_mint	BOOLEAN	True when the trade represents a synthetic mint, burn, or cross-coin pairing.
buyer_address	VARCHAR(16777216)	Buyer of the side-token.
seller_address	VARCHAR(16777216)	Seller of the side-token.
buyer_crossed	BOOLEAN	Whether the buyer’s order was the aggressor.
seller_crossed	BOOLEAN	Whether the seller’s order was the aggressor.
buyer_start_position	NUMBER(22,10)	Buyer’s position in this side-token before the trade.
seller_start_position	NUMBER(22,10)	Seller’s position in this side-token before the trade.
buyer_closed_pnl	NUMBER(22,10)	Closed PnL realized by the buyer on this fill.
seller_closed_pnl	NUMBER(22,10)	Closed PnL realized by the seller on this fill.
transaction_hash	VARCHAR(16777216)	The HL transaction hash for the fill.
timestamp	TIMESTAMP_NTZ(9)	UTC timestamp of the fill.
unique_id	VARCHAR(16777216)	Deterministic unique identifier per row.
venue	VARCHAR(16777216)	Venue identifier (for example `txyz`, `out`, `skew`). Null when not published.
quote_token	VARCHAR(16777216)	Quote token symbol.
template_id	VARCHAR(16777216)	Template identifier (for example `binaryPrice`).
resolved_market_title	VARCHAR(16777216)	Display title for the market.
resolved_side_label	VARCHAR(16777216)	Display label for this side.
resolved_question_title	VARCHAR(16777216)	Display title for the question.
_created_at	TIMESTAMP_NTZ(9)	Row creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Row last update timestamp.

Counterparties

Column Name	Description
buyer_address	Buyer of the side-token.
seller_address	Seller of the side-token.
maker_address	Maker (resting-order) address. NULL on synthetic mints.
taker_address	Taker (aggressing-order) address.
side_name	One of ‘BUY’, ‘SELL’, ‘SETTLE’. NULL on some synthetic-mint rows.
buyer_dir	Direction string for the buyer leg (e.g. ‘Open Long’, ‘Settlement’).
seller_dir	Direction string for the seller leg.
buyer_crossed	Whether the buyer’s order was the aggressor.
seller_crossed	Whether the seller’s order was the aggressor.
buyer_order_id	Order ID for the buyer’s order.
seller_order_id	Order ID for the seller’s order.
buyer_twap_id	TWAP order ID if the buyer’s order was a TWAP order.
seller_twap_id	TWAP order ID if the seller’s order was a TWAP order.

Trade Economics

Column Name	Description
price	Trade price as a 0..1 probability.
size	Trade size in side-tokens.
collateral_token	Collateral token symbol for the trade (e.g. ‘USDH’).
collateral_token_decimals	Decimals of the collateral token.
collateral_amount	Native-unit collateral value of the trade.
usd_exchange_rate	USD price of the collateral token. 1.0 for USDH.
usd_collateral_amount	USD value of the trade.

Fees

Column Name	Description
fee_token	Token in which the trade fee was paid (e.g. ‘USDH’, ‘USDC’). NULL when no fee was charged.
seller_fee_token	Token in which the seller’s fee was paid. HIP-4 buyer and seller can pay in different tokens.
buyer_fee_token	Token in which the buyer’s fee was paid.
buyer_fee	Buyer-side fee in `buyer_fee_token` units.
seller_fee	Seller-side fee in `seller_fee_token` units.
buyer_fee_usd	Buyer-side fee in USD.
seller_fee_usd	Seller-side fee in USD.
tx_fee	Total fee for the transaction in native token units.
tx_fee_usd	Total fee for the transaction in USD.
builder_fee	Total builder fee for the trade.
buyer_builder_fee	Builder fee paid by the buyer, in `buyer_fee_token` units.
seller_builder_fee	Builder fee paid by the seller, in `seller_fee_token` units.
buyer_builder_fee_usd	Buyer’s builder fee in USD.
seller_builder_fee_usd	Seller’s builder fee in USD.
buyer_builder_address	Builder address that received the buyer’s builder fee.
seller_builder_address	Builder address that received the seller’s builder fee.

Position & PnL

Column Name	Description
buyer_start_position	Buyer’s position in this side-token before the trade.
seller_start_position	Seller’s position in this side-token before the trade.
buyer_closed_pnl	Closed PnL realized by the buyer on this fill.
seller_closed_pnl	Closed PnL realized by the seller on this fill.
is_synthetic_mint	True when the trade represents a synthetic mint, burn, or cross-coin pairing.

Sample Query

SELECT
  timestamp,
  coin,
  venue,
  side_name,
  size,
  price,
  usd_collateral_amount,
  buyer_address,
  seller_address
FROM hyperliquid.predictions.trades
WHERE timestamp >= CURRENT_DATE - 7
  AND event_name = 'Trade'
ORDER BY timestamp DESC
LIMIT 100

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

Table Details

Table Columns

Identifiers

Counterparties

Trade Economics

Fees

Position & PnL

Sample Query

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

​Table Details

​Table Columns

​Identifiers

​Counterparties

​Trade Economics

​Fees

​Position & PnL

​Sample Query

Table Details

Table Columns

Identifiers

Counterparties

Trade Economics

Fees

Position & PnL

Sample Query