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 Details

Property	Value
Table Name	`hyperliquid.raw.trades`
Table Status	Production-Ready
Unique Key	`timestamp`, `unique_id`
Clustering Key(s)	`to_date("timestamp")`
Search Optimization	`transaction_hash`, `users:"[0]"`, `users:"[1]"`

Table Columns

Column Name	Data Type	Description
coin	VARCHAR(16777216)	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	VARCHAR(16777216)	Price of the coin at the time of the trade
side	VARCHAR(16777216)	B = Buy (spot) / Long (perpetuals) A = Sell (spot) / Short (perpetuals)
size	VARCHAR(16777216)	Units of the coin that were traded
users	VARIANT	An array of 2 users that were involved in the trade
transaction_hash	VARCHAR(16777216)	The transaction hash for the trade. *See notes for Null Transaction hash.
trade_id	VARCHAR(16777216)	An identifier for the trade. Some historical trades share a tid of 0
timestamp	TIMESTAMP_NTZ(9)	The UTC timestamp of when the trade was executed
unique_id	VARCHAR(16777216)	A unique identifier for each trade
extra_fields	VARIANT	Additional information for each trade. See notes for more details.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.