> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# TWAPs

> TWAP (Time-Weighted Average Price) order data on Hyperliquid

The `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                                                                                                                                                                                  |