solana.predictions.kalshi_markets table provides Kalshi market metadata in the Solana namespace for convenience.
This is a reference view to the common Kalshi markets model. Solana prediction market platforms (ex. Jupiter) use Kalshi as the underlying liquidity provider, so this view provides easy access to market metadata for Solana users.
For the authoritative Kalshi markets data, see common.predictions.kalshi_markets.
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Project identifier (ex. jupiter). |
| protocol | VARCHAR | Protocol identifier (kalshi). |
| market_unique_id | VARCHAR | Unique identifier for the Kalshi market ticker (e.g., KXFEDDECISION-25DEC-C25). |
| market_event_id | VARCHAR | Event identifier that groups related markets together. |
| market_name | VARCHAR | Market title describing the prediction question. |
| question | VARCHAR | Question text from the event. |
| description | VARCHAR | Market description. |
| category | VARCHAR | Category classification of the market. |
| market_status | VARCHAR | Current status of the market (active, open, closed, finalized, settled). |
| start_date | TIMESTAMP_NTZ(9) | Timestamp when the market opened for trading. |
| end_date | TIMESTAMP_NTZ(9) | Timestamp when the market closes for trading. |
| market_outcome_resolution | VARCHAR | Market outcome resolution (yes/no/unresolved). |
| resolved_at | TIMESTAMP_NTZ(9) | Timestamp when the market was resolved. |
Market Status Values
- active: Market is currently open for trading
- open: Market is open for trading
- closed: Market has closed but not yet finalized
- finalized: Market outcome has been determined
- settled: Market has been fully settled
Understanding Market IDs
- market_unique_id: The Kalshi ticker (e.g., KXFEDDECISION-25DEC-C25) - unique per market
- market_event_id: Groups related markets under the same event