Skip to main content
The crosschain.predictions.markets table provides prediction market metadata across Polymarket (Polygon) and Kalshi (API). Categories and market statuses are normalized across platforms.
For platform-specific details, see: Polymarket Markets, Kalshi Markets.

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi).
protocolProtocol name (polymarket, kalshi).
chainBlockchain where the market lives. NULL for off-chain platforms (Kalshi).
market_unique_idNative platform market identifier.
market_tickerTradeable outcome identifier. Represents the most granular tradeable unit on each platform.
event_tickerEvent-level grouping identifier.
series_tickerKalshi series ticker (e.g. KXBTCD). NULL for Polymarket.
token_idPolymarket token ID for the tradeable outcome. NULL for Kalshi.
token_outcomePolymarket token outcome name (Yes, No, or named outcome). NULL for Kalshi.
is_mveWhether this is a multi-outcome market.
market_nameMarket name.
questionThe market question text.
descriptionDetailed market description or resolution rules.
seconds_delaySettlement delay in seconds. Available for both Polymarket and Kalshi.
categoryNormalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other.
market_statusNormalized market status. Values: active, closed, settled.
activeWhether the market is currently active.
closedWhether the market is closed.
accepting_ordersWhether the market is currently accepting orders.
start_dateWhen the market opened for trading.
end_dateWhen the market closes or expires.
expiration_timeKalshi-specific expiration timestamp. NULL for Polymarket.
resolved_atTimestamp when the market was resolved.
outcomeResolution outcome (e.g. yes, no, unresolved, 50/50).
is_winnerWhether this token was the winning outcome. Polymarket only (token-level). NULL for Kalshi.
token_priceCurrent or last traded price for this market/token.
extrasVARIANT 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