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

# Candlesticks Hourly

> Hourly OHLCV (Open, High, Low, Close, Volume, OI) candlestick data for Kalshi prediction markets.

The `common.predictions.kalshi_markets_candlesticks_hourly` table provides hourly price candlestick data for Kalshi prediction markets. Each row represents one hour of market activity with open, high, low, close prices, trading volume, and end-of-hour open interest.

Use this table for technical analysis, price trend visualization, volume analysis, and understanding intraday market dynamics.

### Table Columns

**Data Notes:**

* Combines settled and non-settled market candlesticks
* Prices are on a 0-1 scale (e.g., 0.65 = \$0.65)
* Volume represents the number of contracts traded during the hour
* Open interest is the end-of-hour snapshot of outstanding contracts

Unique Key: `unique_key`

| Column Name             | Data Type         | Description                                           |
| ----------------------- | ----------------- | ----------------------------------------------------- |
| project                 | VARCHAR           | Project identifier, always 'kalshi'.                  |
| protocol                | VARCHAR           | Protocol identifier, always 'kalshi'.                 |
| market\_ticker          | VARCHAR           | Market ticker identifier.                             |
| event\_ticker           | VARCHAR           | Event ticker identifier.                              |
| series\_ticker          | VARCHAR           | Series ticker identifier.                             |
| period\_date            | DATE              | Date of the candlestick period.                       |
| start\_period\_datetime | TIMESTAMP\_NTZ(9) | Start timestamp of the hourly period.                 |
| end\_period\_datetime   | TIMESTAMP\_NTZ(9) | End timestamp of the hourly period.                   |
| price\_open             | FLOAT             | Opening price for the hour (0-1 scale).               |
| price\_high             | FLOAT             | Highest price during the hour (0-1 scale).            |
| price\_low              | FLOAT             | Lowest price during the hour (0-1 scale).             |
| price\_close            | FLOAT             | Closing price for the hour (0-1 scale).               |
| volume                  | NUMBER            | Trading volume (number of contracts) during the hour. |
| open\_interest          | NUMBER            | Open interest at the end of the hour.                 |
| unique\_key             | VARCHAR           | Unique identifier for the candlestick record.         |

***

### Sample Queries

<Tabs>
  <Tab title="Price Evolution">
    Track hourly price evolution for a specific market:

    ```sql theme={null}
    select
      market_ticker,
      start_period_datetime,
      price_open,
      price_high,
      price_low,
      price_close,
      volume,
      open_interest,
      (price_close - price_open) as price_change,
      (price_high - price_low) as price_range
    from common.predictions.kalshi_markets_candlesticks_hourly
    where market_ticker = 'YOUR_MARKET_TICKER'
      and start_period_datetime >= current_timestamp - interval '7 days'
    order by start_period_datetime asc
    ```
  </Tab>
</Tabs>

### Understanding Candlestick Data

#### OHLCV Components

* **Open**: First price at the start of the hour
* **High**: Highest price during the hour
* **Low**: Lowest price during the hour
* **Close**: Last price at the end of the hour
* **Volume**: Total contracts traded during the hour
* **Open Interest**: Outstanding contracts at end of hour

#### Price Interpretation

Since prices are on a 0-1 scale:

* `price_close = 0.75` means the market believes there's a 75% probability of the outcome
* Price increase (close > open) indicates growing confidence in "yes"
* Price decrease (close \< open) indicates declining confidence in "yes"

#### Volume vs Open Interest

* **Volume**: Contracts traded during a period (stock analogy: daily trading volume or daily notional volume)
* **Open Interest**: Total outstanding contracts (stock analogy: shares outstanding)
* High volume with flat open interest → lots of trading between participants
* High open interest indicates significant market participation
* Low open interest suggests limited liquidity or interest