Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Crosschain prediction market metadata across Polymarket, Polymarket US, Kalshi, and Gemini.
crosschain.predictions.markets table provides prediction market metadata across Polymarket (Polygon), Polymarket US, Kalshi (API), and Gemini (API). Categories and market statuses use a shared normalized taxonomy across platforms.
| 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. |
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
Was this page helpful?