Candlesticks Hourly

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

Price Evolution

Track hourly price evolution for a specific market:

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

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Queries

Understanding Candlestick Data

OHLCV Components

Price Interpretation

Volume vs Open Interest

​Table Columns

​Sample Queries

​Understanding Candlestick Data

​OHLCV Components

​Price Interpretation

​Volume vs Open Interest

Table Columns

Sample Queries

Understanding Candlestick Data

OHLCV Components

Price Interpretation

Volume vs Open Interest