kalshi.market_report table contains market-level metadata for Kalshi event contracts, including ticker, title, category, and lifecycle status.
Table Schema
| Column | Type | Description |
|---|---|---|
block_volume | DOUBLE | Trading volume for the block period |
category | VARCHAR | Category of the event contract (e.g., Politics, Economics, Sports, etc.) |
daily_volume | DOUBLE | Total trading volume for the day |
date | VARCHAR | Date of the market report |
high | DOUBLE | Highest price reached during the reporting period |
low | DOUBLE | Lowest price reached during the reporting period |
open_interest | DOUBLE | Total number of outstanding contracts |
payout_type | VARCHAR | Type of payout for the event contract |
report_ticker | VARCHAR | Unique ticker identifier for the market report |
status | VARCHAR | Current status of the event contract market |
ticker_name | VARCHAR | Name or description of the event contract ticker |
_updated_at | TIMESTAMP | Last update timestamp |
_ingested_at | TIMESTAMP | Ingestion timestamp |