Trades - Allium Documentation Hub

The hyperliquid.raw.trades table contains raw trade data for Hyperliquid (spot and perp). Two fills make a trade. To resolve spot coin to a pair (e.g. HYPE/USDC), join to hyperliquid.raw.spot_coin_pairs on coin = name.

Table Columns

Column Name	Description
coin	A unique identifier for the asset being traded: • The coin for perpetuals is the standard token symbol, e.g. HYPE • The coin for spot tokens is an ID representing a pair of tokens based on Hyperliquid’s metadata, e.g. @4 (coin) represents token 5/token 0, which corresponds to JEFF/USDC The metadata is available from the info endpoint of Hyperliquid’s API
price	Price of the coin at the time of the trade
side	B = Buy (spot) / Long (perpetuals) A = Sell (spot) / Short (perpetuals)
size	Units of the coin that were traded
users	An array of 2 users that were involved in the trade
transaction_hash	The transaction hash for the trade. *See notes for Null Transaction hash.
trade_id	An identifier for the trade. Some historical trades share a tid of 0
timestamp	The UTC timestamp of when the trade was executed
unique_id	A unique identifier for each trade
extra_fields	Additional information for each trade. See notes for more details.

⌘I