> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# kalshi.ohlcv_hourly

> Kalshi hourly OHLCV candles — per-market open/high/low/close/volume with VWAP and trade count.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

The `kalshi.ohlcv_hourly` table provides hourly OHLCV (Open-High-Low-Close-Volume) candles per Kalshi market. Grain: one row per `(hour, market_id, outcome)`. Kalshi candles are built on the Yes side (No can be derived as `1 - Yes`). Hours without trades carry the previous close forward and are flagged via `is_forward_filled`. Resolved markets are pinned to 1.0 / 0.0 after expiration.

## Table Schema

| Column              | Type        | Description                                                    |
| ------------------- | ----------- | -------------------------------------------------------------- |
| `block_month`       | `DATE`      | UTC month partition derived from `hour`                        |
| `hour`              | `TIMESTAMP` | UTC hour bucket for the candle                                 |
| `market_id`         | `VARCHAR`   | Kalshi market ticker                                           |
| `market_name`       | `VARCHAR`   | Market question text                                           |
| `outcome`           | `VARCHAR`   | Always `Yes` for Kalshi                                        |
| `yes_outcome_name`  | `VARCHAR`   | Human-readable label of the Yes side                           |
| `category`          | `VARCHAR`   | Market category                                                |
| `open`              | `DOUBLE`    | Opening price in the hour                                      |
| `high`              | `DOUBLE`    | High price in the hour                                         |
| `low`               | `DOUBLE`    | Low price in the hour                                          |
| `close`             | `DOUBLE`    | Closing price in the hour                                      |
| `vwap`              | `DOUBLE`    | Volume-weighted average price. NULL when no trades             |
| `volume_contracts`  | `DOUBLE`    | Total contracts traded in the hour                             |
| `volume_usd`        | `DOUBLE`    | Total USD notional in the hour                                 |
| `trade_count`       | `BIGINT`    | Number of trades in the hour                                   |
| `market_end_time`   | `TIMESTAMP` | Market expiration time                                         |
| `market_outcome`    | `VARCHAR`   | Settled outcome (`yes`, `no`, `scalar`). NULL while unresolved |
| `event_market_name` | `VARCHAR`   | Parent event title                                             |
| `is_forward_filled` | `BOOLEAN`   | TRUE when the bar has no trades and was carried forward        |
| `_updated_at`       | `TIMESTAMP` | When this row was last written by the pipeline                 |

## Table sample

<TableSample tableSchema="kalshi" tableName="ohlcv_hourly" />

## Query performance

`block_month` is the partition key. Always include a `block_month` or `hour` filter for time-series queries.

## Example query

```sql theme={null}
-- Hourly price path for a single market
SELECT
  hour,
  open,
  high,
  low,
  close,
  volume_contracts
FROM kalshi.ohlcv_hourly
WHERE market_id = 'KXNHLGAME-26MAY03MINCOL-MIN'
  AND block_month >= DATE '2026-05-01'
ORDER BY hour
```