> ## 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 5min

> 5-minute token price and swap-activity metrics for Hyperliquid.

The `hyperliquid.dex.token_prices_5min` table contains 5-minute 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 5-minute interval.

<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 5-minute 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 interval.          |
| median\_price        | Median trade price over the interval.                     |
| median\_safe\_price  | Median price after filtering outlier trades.              |
| usd\_trading\_volume | Total USD swap volume over the interval.                  |
| traders              | Number of distinct traders over the interval.             |
| trade\_count         | Number of trades over the interval.                       |
| \_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_5min
WHERE timestamp >= CURRENT_DATE - 1
  AND token_symbol = 'HYPE'
ORDER BY timestamp DESC
```