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

> Hourly token price and swap-activity metrics for Hyperliquid.

The `hyperliquid.dex.token_prices_hourly` table contains hourly price data for tokens traded on Hyperliquid. Each row also carries swap-activity metrics — USD trading volume, trader counts, and trade counts — for the asset over the hour.

<Note>This table is clustered by `timestamp::date`. Always include a `timestamp` filter in your `WHERE` clause to avoid scanning the full table.</Note>

## Table Columns

| Column Name          | Description                                               |
| -------------------- | --------------------------------------------------------- |
| chain                | The blockchain network (`hyperliquid`).                   |
| timestamp            | Start of the hourly interval (UTC).                       |
| market\_type         | The type of market — 'spot' or 'perpetuals'.              |
| token\_symbol        | The token symbol.                                         |
| token\_index         | Hyperliquid numeric token index.                          |
| evm\_token\_address  | The corresponding HyperEVM token address, when available. |
| dex\_name            | The DEX this price corresponds to.                        |
| pair                 | The trading pair (e.g. HYPE/USDC).                        |
| quote\_symbol        | The quote token symbol used for pricing.                  |
| decimals             | Token decimal places.                                     |
| price                | Volume-weighted average price over the hour.              |
| median\_price        | Median trade price over the hour.                         |
| median\_safe\_price  | Median price after filtering outlier trades.              |
| usd\_trading\_volume | Total USD swap volume over the hour.                      |
| traders              | Number of distinct traders over the hour.                 |
| trade\_count         | Number of trades over the hour.                           |
| \_created\_at        | Row creation timestamp.                                   |
| \_updated\_at        | Row last update timestamp.                                |

## Sample Query

```sql theme={null}
SELECT
  timestamp,
  token_symbol,
  price,
  usd_trading_volume,
  trade_count
FROM hyperliquid.dex.token_prices_hourly
WHERE timestamp >= CURRENT_DATE - 7
  AND token_symbol = 'HYPE'
ORDER BY timestamp DESC
```