> ## 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.

# Token Prices Daily

> Hyperliquid HIP-4 side-token prices at daily grain.

The `hyperliquid.predictions.token_prices_daily` table contains a daily price for every Hyperliquid HIP-4 side-token. One row per (day, coin). Settled outcomes are excluded from the settlement day onward.

## Table Columns

| Column Name   | Description                                                                                 |
| ------------- | ------------------------------------------------------------------------------------------- |
| project       | Top-level project namespace (`hyperliquid`).                                                |
| protocol      | Protocol within the project (`hyperliquid_hip4`).                                           |
| chain         | The blockchain network (`hyperliquid`).                                                     |
| day           | Date bucket (UTC).                                                                          |
| coin          | HL-native side-token identifier (e.g. '#54760').                                            |
| outcome\_id   | HIP-4 outcome identifier (shared by both token sides).                                      |
| token\_side   | Which side of the outcome's YES/NO pair the row represents (0 or 1).                        |
| side\_label   | Display label for this row's token\_side (e.g. 'Yes', 'No').                                |
| last\_price   | Last observed price for the coin as a 0..1 probability. Resolves to 0 or 1 post-settlement. |
| vwap\_price   | Volume-weighted price across the day.                                                       |
| trade\_count  | Number of trades in the day.                                                                |
| unique\_id    | Deterministic unique identifier per row.                                                    |
| \_created\_at | Row creation timestamp.                                                                     |
| \_updated\_at | Row last update timestamp.                                                                  |

## Sample Query

```sql theme={null}
SELECT
  day,
  coin,
  side_label,
  last_price,
  vwap_price,
  trade_count
FROM hyperliquid.predictions.token_prices_daily
WHERE day >= CURRENT_DATE - 30
ORDER BY day DESC, coin
LIMIT 200
```