hyperliquid.raw.fills table contains raw fill data for all trades that are executed on Hyperliquid.
Table Columns
| Column Name | Description |
|---|---|
| timestamp | The UTC timestamp of the fill |
| user | The address of the user involved in the fill |
| builder_fee | The builder fee for the fill |
| closed_pnl | The closed PnL from this fill |
| coin | The asset being traded |
| dir | The direction of the fill (e.g., Open Long, Close Short) |
| fee | The trading fee for the fill |
| fee_token | The token in which the fee was paid |
| hash | Transaction hash |
| order_id | The order ID associated with this fill |
| price | The price at which the fill was executed |
| side | B - Buy A - Ask (Sell) |
| start_position | The user’s position before this fill |
| size | The size of the fill |
| trade_id | The trade ID associated with this fill |
| builder_address | The builder address associated with this fill |
| twap_id | The TWAP order ID if this fill was part of a TWAP order |
| crossed | Whether the fill was crossed |
| liquidation | Liquidation details as a JSON variant, if this is a liquidation |