Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The 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.
For platform-specific details, see: Polymarket Markets, Polymarket US Markets, Kalshi Markets.

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi, polymarket_us, gemini).
protocolProtocol name (polymarket, kalshi, polymarket_us, gemini).
chainBlockchain where the market lives. NULL for off-chain platforms (Kalshi, Polymarket US, Gemini).
market_unique_idNative platform market identifier.
market_tickerTradeable outcome identifier.
event_tickerEvent-level grouping identifier.
series_tickerSeries ticker for Kalshi and Gemini. NULL for Polymarket and Polymarket US.
token_idPolymarket token ID. NULL for Kalshi, Polymarket US, and Gemini.
token_outcomePolymarket token outcome name (Yes, No, or named outcome). NULL for Kalshi, Polymarket US, and Gemini (one row per market).
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. NULL for Polymarket US and Gemini.
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_timeExpiration timestamp for Kalshi and Gemini. NULL for Polymarket and Polymarket US.
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, Polymarket US, and Gemini.
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