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

### Table Details

| Property          | Value                       |
| ----------------- | --------------------------- |
| Table Name        | `sui.dex.token_prices_5min` |
| Table Status      | Production-Ready            |
| Unique Key        | `timestamp`, `address`      |
| Clustering Key(s) | `timestamp::date`           |

### Table Columns

| Column Name          | Data Type         | Description                                                                                                                                                                                                                    |
| -------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| chain                | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. `ethereum`, `base`, `avalanche`, `solana`). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| timestamp            | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of this record. Alias for block\_timestamp used in tables where the column is named `timestamp` rather than `block_timestamp`.                                                                                 |
| address              | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.                                                                         |
| symbol               | VARCHAR(16777216) | Ticker symbol of this token or asset. Short alias for `token_symbol` used in tables that preserve the original blockchain field naming convention.                                                                             |
| name                 | VARCHAR(16777216) | Market display name.                                                                                                                                                                                                           |
| decimals             | NUMBER(38,0)      | Number of decimal places for this token. Short alias for `token_decimals` used in tables that preserve the original blockchain field naming convention.                                                                        |
| price                | FLOAT             | Price per unit of the asset at the time of this event, in USD or in the quote token's units depending on context.                                                                                                              |
| median\_price        | FLOAT             | Median price per token unit across all trades in this aggregated period, in USD. Median is used rather than mean to reduce the impact of outlier trades.                                                                       |
| median\_safe\_price  | FLOAT             | Median price with outlier trades removed — excludes trades with extremely low liquidity or anomalous pricing that could distort the median\_price.                                                                             |
| usd\_trading\_volume | FLOAT             | Total USD value of tokens traded in this aggregated period.                                                                                                                                                                    |
| traders              | NUMBER(38,0)      | Number of distinct trader addresses that executed swaps in this aggregated record.                                                                                                                                             |
| trade\_count         | NUMBER(38,0)      | Number of trades on the day. NULL when the venue does not expose a trade count.                                                                                                                                                |
| \_created\_at        | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                                                                                                                       |
| \_updated\_at        | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                                                                                                                  |
