> ## 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 price tracking view for Polymarket prediction market tokens.

The `polygon.predictions.token_prices_hourly` view provides hourly price snapshots for all prediction market tokens.

Use this view for granular price trend analysis, intraday market movements, and time-series analysis of market outcomes.

### Table Details

| Property     | Value                                     |
| ------------ | ----------------------------------------- |
| Table Name   | `polygon.predictions.token_prices_hourly` |
| Table Status | Beta 🌱                                   |

### Table Columns

| Column Name   | Data Type         | Description                                                                             |
| ------------- | ----------------- | --------------------------------------------------------------------------------------- |
| project       | VARCHAR(16777216) | Project name (polymarket).                                                              |
| protocol      | VARCHAR(16777216) | Protocol name (polymarket).                                                             |
| block\_hour   | TIMESTAMP\_NTZ(9) | Hour timestamp for the price snapshot.                                                  |
| condition\_id | VARCHAR(16777216) | Unique condition identifier for the market.                                             |
| token\_id     | VARCHAR(16777216) | Token ID for the specific outcome token.                                                |
| price         | FLOAT             | Token price in USDC.e terms. After market resolution, prices reflect the final outcome. |
| unique\_id    | VARCHAR(16777216) | Unique identifier combining block\_hour and token\_id.                                  |

***

### Understanding Price Data

* If no trade occurred during a given hour, the price carries forward from the last known trade.
* After market resolution, prices are set to 0 for losing outcomes and 1 for winning outcomes.

### Sample Query

```sql theme={null}
SELECT 
  block_hour,
  condition_id,
  token_id,
  price
FROM polygon.predictions.token_prices_hourly
WHERE block_hour >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
ORDER BY block_hour DESC
LIMIT 100;
```