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

# Hourly

### Table Details

| Property | Value |
| - | - |
| Table Name | `arc.prices.hourly` |
| Table Status | Production-Ready |
| Unique Key | `timestamp`, `address` |
| Clustering Key(s) | `timestamp::date` |
| Search Optimization | `address` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| chain | VARCHAR(16777216) | The blockchain network name. |
| id | VARCHAR(16777216) | The unique identifier of the token (e.g., CoinGecko ID). |
| symbol | VARCHAR(16777216) | The ticker symbol of the token. |
| address | VARCHAR(16777216) | The contract address of the token. |
| decimals | NUMBER(38,0) | The number of decimal places for the token. |
| timestamp | TIMESTAMP\_NTZ(9) | The hourly timestamp for the price data point. |
| price | VARCHAR(16777216) | The token price in USD at the given timestamp. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. |

### Related Docs

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