| client_order_id | Custom order ID provided by the user |
| order_id | Order ID generated by Hyperliquid |
| 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 |
| is_take_profit_or_stop_loss | Boolean Whether this order is a take profit or stop loss order |
| 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. |
| type | The type of order. Refer to the Hyperliquid Docs |
| original_size | The size of the original order For example if the order size has since changed since it was partially filled, then the original_size will show a different value |
| is_reduce_only | Whether this order reduces the current position, instead of opening a new order in the opposite direction. Refer to the Hyperliquid Docs |
| side | B - Buy A - Ask (Sell) |
| 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 |
| order_timestamp | This refers to the original order timestamp. See original_size. So depending on when the order status changes, this can be quite different from status_change_timestamp. |
| trigger_condition | What will make this order become active, go into the order book. For example ‘Price below 1560.1’ The value can also be ‘Triggered’ which means the trigger condition has already been met and the order is in active in the order book. For an example see SELECT * from hyperliquid.raw.orders where order_id = '44776647532'; |
| trigger_price | The price for it to be triggered, if it is a trigger. See is_trigger Will match the value in trigger_condition |
| limit_price | Maximum price the buyer or seller are willing to pay |
| children | Children will contain one or two orders, which will be added once the parent order is triggered. These can be a take profit and/or a stop loss. For examples see SELECT * from hyperliquid.raw.orders where order_id = '82039428821' or order_id = '82161896540' or order_id = '82182749399'; |
| status | The status which the order has after the order_status_change_timestamp. Refer to the Hyperliquid Docs for a list of all possible statuses. Currently we do not have the initial status Open refer to the Notes |
| user | user that owns the order |
| status_change_timestamp | The time at which the status of this order changed. Basically represents the time at which the entries in this row took effect |
| unique_id | A unique id generated by Allium to represent each record |
| builder_address | The builder address associated with the order |
| builder_fee | The builder fee associated with the order |
