> ## 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.

# Markets

> Crosschain prediction market metadata across Polymarket, Polymarket US, Kalshi, and Gemini.

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.

<Info>
  For platform-specific details, see:
  [Polymarket Markets](/historical-data/supported-blockchains/evm/polygon/predictions/markets),
  [Polymarket US Markets](/historical-data/predictions/polymarket-us/markets),
  [Kalshi Markets](/historical-data/predictions/kalshi/markets).
</Info>

## 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

```sql theme={null}
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
```