crosschain.predictions.trades table contains prediction market trades across Polymarket (Polygon), Polymarket US, Kalshi, Gemini, and Solana venues (Jupiter, DFlow, and World). Use project and protocol to filter by venue.
For platform-specific details, see:
Polymarket Trades,
Kalshi Trades,
Solana Trades (Jupiter, DFlow, World).
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
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