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

# Trades

> Crosschain prediction market trades across Polymarket, Polymarket US, Kalshi, Gemini, and Solana venues (Jupiter, DFlow, World).

The `crosschain.predictions.trades` table contains prediction market trades across Polymarket (Polygon), Polymarket US, Kalshi (API), Gemini (API), and Solana venues (Jupiter, DFlow, and World). Use `project` and `protocol` to filter by venue.

<Info>
  For platform-specific details, see:
  [Polymarket Trades](/historical-data/supported-blockchains/evm/polygon/predictions/trades),
  [Polymarket US Trades](/historical-data/predictions/polymarket-us/trades),
  [Kalshi Trades](/historical-data/predictions/kalshi/trades),
  [Solana Trades (Jupiter, DFlow, World)](/historical-data/supported-blockchains/solana/solana/predictions/trades).
</Info>

## Table Columns

| Column Name         | Description                                                                                                                                                                                                                                                                                                                          |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| project             | Platform name (polymarket, kalshi, jupiter, dflow, world, polymarket\_us, gemini).                                                                                                                                                                                                                                                   |
| protocol            | Protocol name (polymarket, kalshi, world, polymarket\_us, gemini). Jupiter rows may show kalshi or polymarket depending on the market; World rows show world.                                                                                                                                                                        |
| chain               | Blockchain where the trade settled, when applicable. NULL for off-chain venues (Kalshi, Polymarket US, Gemini).                                                                                                                                                                                                                      |
| trade\_timestamp    | Timestamp of the trade execution.                                                                                                                                                                                                                                                                                                    |
| trade\_date         | Date of the trade.                                                                                                                                                                                                                                                                                                                   |
| trade\_id           | Unique trade identifier per platform.                                                                                                                                                                                                                                                                                                |
| market\_unique\_id  | Native platform market identifier for this trade.                                                                                                                                                                                                                                                                                    |
| market\_ticker      | Tradeable outcome identifier.                                                                                                                                                                                                                                                                                                        |
| event\_ticker       | Event-level grouping identifier.                                                                                                                                                                                                                                                                                                     |
| market\_name        | Market name.                                                                                                                                                                                                                                                                                                                         |
| question            | The market question text.                                                                                                                                                                                                                                                                                                            |
| category            | Normalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other.                                                                                                                                                                                                    |
| sub\_category       | Subcategory for narrower topic scoping. Polymarket only.                                                                                                                                                                                                                                                                             |
| market\_status      | Normalized market status. Values: active, closed, settled.                                                                                                                                                                                                                                                                           |
| token\_outcome      | Outcome side of the trade (yes or no). Populated for Polymarket and Gemini. NULL for Polymarket US.                                                                                                                                                                                                                                  |
| yes\_price          | Price of the Yes outcome on a 0 to 1 scale. For Gemini, inverted when the traded leg is No.                                                                                                                                                                                                                                          |
| no\_price           | Price of the No outcome on a 0 to 1 scale. For Gemini, inverted when the traded leg is No.                                                                                                                                                                                                                                           |
| taker\_price        | Price paid by the taker.                                                                                                                                                                                                                                                                                                             |
| num\_shares         | Trade size in outcome shares or contracts. Polymarket uses outcome shares; Kalshi, Gemini, Jupiter, DFlow, World, and Polymarket US use contract counts.                                                                                                                                                                             |
| usd\_amount         | Trade value in USD.                                                                                                                                                                                                                                                                                                                  |
| fee\_usd            | Net trading fee in USD, after any maker rebate. Equals gross\_fee\_usd for venues without rebates (Jupiter, DFlow, World, Polymarket US, Kalshi). For Kalshi this is the published trade fee, rounded up to \$0.0001 per side (taker + maker); it does not include Kalshi's later rounding fee or per-order rebate. NULL for Gemini. |
| gross\_fee\_usd     | Trading fee in USD charged to the taker, before any rebate. Equals fee\_usd for venues without rebates (Jupiter, DFlow, World, Polymarket US, Kalshi). NULL for Gemini.                                                                                                                                                              |
| rebate\_fee\_usd    | Maker rebate in USD. Polymarket V1 markets only. NULL for all other venues.                                                                                                                                                                                                                                                          |
| maker               | Maker wallet address. Polymarket only. NULL for Kalshi, Jupiter, DFlow, World, Polymarket US, and Gemini.                                                                                                                                                                                                                            |
| taker               | Taker wallet address. Polymarket and Solana venues (Jupiter, DFlow, World). NULL for Kalshi, Polymarket US, and Gemini.                                                                                                                                                                                                              |
| transaction\_hash   | On-chain transaction hash. NULL for Kalshi, Polymarket US, and Gemini.                                                                                                                                                                                                                                                               |
| resolution\_outcome | Final resolution outcome of the market this trade belongs to. NULL if the market has not yet resolved.                                                                                                                                                                                                                               |
| extras              | VARIANT column with platform-specific metadata. Gemini includes buy/sell direction in `taker_side` and `maker_side`.                                                                                                                                                                                                                 |
| \_created\_at       | Record creation timestamp.                                                                                                                                                                                                                                                                                                           |
| \_updated\_at       | Record update timestamp.                                                                                                                                                                                                                                                                                                             |

## Sample Query

```sql theme={null}
SELECT
    project,
    trade_timestamp,
    market_name,
    category,
    token_outcome,
    taker_price,
    num_shares,
    usd_amount,
    maker,
    taker
FROM crosschain.predictions.trades
WHERE trade_date >= CURRENT_DATE - 7
ORDER BY trade_timestamp DESC
LIMIT 100
```