hyperliquid.raw.builder_fills table contains fills completed by builders only, including builder fees and the builder address. i.e. the trade was facilitated by an order placed by that builder. Data is available from 2024-10-27.
Table Columns
| Column Name | Description |
|---|---|
| timestamp | The timestamp of the trade |
| builder_address | The address of the builder that executed the trade |
| builder_fee | The fee paid to the builder for the trade |
| user | user that executed the trade |
| counterparty | user that was matched with |
| closed_pnl | The profit or loss of the trade |
| 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 |
| crossed | Whether the trade was crossed |
| is_trigger | Boolean Whether this order has a trigger condition. For instance the order is only in effect if the price goes above 25. See Notes for more details. |
| price | The price of the trade |
| side | B - Buy A - Ask (Sell) |
| special_trade_type | The type of trade |
| size | Order size. This is the current order size. So if partially filled, this will be the size of the unfilled part |
| time_in_force | Behaviour for the order. Refer to the Hyperliquid Docs |
| twap_id | The twap id of the trade |