crosschain.predictions.markets table provides prediction market metadata across Polymarket (Polygon), Polymarket US, Kalshi, and Gemini. Categories and market statuses use a shared normalized taxonomy across platforms.
For platform-specific details, see:
Kalshi Markets.
Table Columns
| Column Name | Description |
|---|---|
| project | Platform name (polymarket, kalshi, polymarket_us, gemini). |
| protocol | Protocol name (polymarket, kalshi, polymarket_us, gemini). |
| chain | Blockchain where the market lives. NULL for off-chain platforms (Kalshi, Polymarket US, Gemini). |
| market_unique_id | Native platform market identifier. |
| market_ticker | Tradeable outcome identifier. |
| event_ticker | Event-level grouping identifier. |
| series_ticker | Series ticker for Kalshi and Gemini. NULL for Polymarket and Polymarket US. |
| token_id | Polymarket token ID. NULL for Kalshi, Polymarket US, and Gemini. |
| token_outcome | Polymarket token outcome name (Yes, No, or named outcome). NULL for Kalshi, Polymarket US, and Gemini (one row per market). |
| is_mve | Whether this is a multi-outcome market. |
| market_name | Market name. |
| question | The market question text. |
| description | Detailed market description or resolution rules. |
| seconds_delay | Settlement delay in seconds. NULL for Polymarket US and Gemini. |
| category | Normalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other. |
| market_status | Normalized market status. Values: active, closed, settled. |
| active | Whether the market is currently active. |
| closed | Whether the market is closed. |
| accepting_orders | Whether the market is currently accepting orders. |
| start_date | When the market opened for trading. |
| end_date | When the market closes or expires. |
| expiration_time | Expiration timestamp for Kalshi and Gemini. NULL for Polymarket and Polymarket US. |
| resolved_at | Timestamp when the market was resolved. |
| outcome | Resolution outcome (e.g. yes, no, unresolved, 50/50). |
| is_winner | Whether this token was the winning outcome. Polymarket only (token-level). NULL for Kalshi, Polymarket US, and Gemini. |
| token_price | Current or last traded price for this market/token. |
| extras | VARIANT column with platform-specific metadata. |
Sample Query
SELECT
project,
market_unique_id,
market_name,
category,
market_status,
token_outcome,
token_price,
start_date,
end_date
FROM crosschain.predictions.markets
WHERE market_status = 'active'
AND category = 'crypto'
ORDER BY start_date DESC
LIMIT 100