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