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

### Table Details

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

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| chain | VARCHAR(16777216) | Blockchain network (e.g., 'ethereum', 'arbitrum') |
| timestamp | TIMESTAMP\_NTZ(9) | Start of the hourly period |
| address | VARCHAR(42) | Token contract address |
| symbol | VARCHAR(16777216) | Token symbol |
| name | VARCHAR(16777216) | Token name |
| decimals | NUMBER(38,0) | Number of decimal places for the token |
| price | FLOAT | Volume-weighted average price for the hour |
| median\_price | FLOAT | Median price from all trades in the hour |
| median\_safe\_price | FLOAT | Filtered median price by filtering swaps > 100 usd in volume |
| usd\_trading\_volume | FLOAT | Total USD volume traded in the hour |
| traders | NUMBER(38,0) | Number of distinct traders that swapped the token for the hour by counting distinct `transaction_from_address.` |
| trade\_count | NUMBER(38,0) | Total number of swaps executed |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of entry creation |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of entry update |

### Related Docs

* [EVM DEX Token Prices Hourly](/historical-data/supported-blockchains/evm/core-schemas/dex/token-prices-hourly)