Skip to main content
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 (Using trades for volume is preffered)
  • Open interest is the end-of-hour snapshot of outstanding contracts
Unique Key: unique_key
Column NameData TypeDescription
projectVARCHARProject identifier, always ‘kalshi’.
protocolVARCHARProtocol identifier, always ‘kalshi’.
market_tickerVARCHARMarket ticker identifier.
event_tickerVARCHAREvent ticker identifier.
series_tickerVARCHARSeries ticker identifier.
period_dateDATEDate of the candlestick period.
start_period_datetimeTIMESTAMP_NTZ(9)Start timestamp of the hourly period.
end_period_datetimeTIMESTAMP_NTZ(9)End timestamp of the hourly period.
price_openFLOATOpening price for the hour (0-1 scale).
price_highFLOATHighest price during the hour (0-1 scale).
price_lowFLOATLowest price during the hour (0-1 scale).
price_closeFLOATClosing price for the hour (0-1 scale).
volumeNUMBERTrading volume (number of contracts) during the hour.
open_interestNUMBEROpen interest at the end of the hour.
unique_keyVARCHARUnique 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