kalshi.trade_report table contains daily aggregated trade data for Kalshi event contracts. Note that a single date and ticker can have multiple rows at different price points — this is not individual fill data.
Table Schema
| Column | Type | Description |
|---|---|---|
contracts_traded | DOUBLE | Number of contracts traded in the transaction |
date | VARCHAR | Date of the trade report |
price | DOUBLE | Price at which the contracts were traded |
report_ticker | VARCHAR | Unique ticker identifier for the trade report |
ticker_name | VARCHAR | Name or description of the event contract ticker |
_updated_at | TIMESTAMP | Last update timestamp |
_ingested_at | TIMESTAMP | Ingestion timestamp |