hyperliquid.raw.twaps table contains TWAP (Time-Weighted Average Price) order data on Hyperliquid.
Table Columns
| Column Name | Description |
|---|---|
| status_change_timestamp | The time at which the TWAP order status changed |
| order_timestamp | The time at which the TWAP order was placed |
| twap_id | The TWAP order ID |
| status | The status of the TWAP order |
| coin | For perpetuals the token symbol (e.g. HYPE). For spot, an ID representing a pair (e.g. @4). Resolve via hyperliquid.raw.spot_coin_pairs (join on coin = name) to get pair, token_a_symbol, token_b_symbol. |
| executed_notional | The executed notional value |
| executed_size | The executed size |
| side | B - Buy A - Ask (Sell) |
| size | The total order size |
| user | The address of the user |
| minutes | The duration of the TWAP order in minutes |
| randomize | Whether the TWAP order uses randomized execution |
| is_reduce_only | Whether this is a reduce-only order |