hyperliquid.raw.trades table contains raw trade data for Hyperliquid. Two fills make a trade.
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. |