Skip to main content
The crosschain.predictions.trades table provides prediction market trades across Polymarket (Polygon), Kalshi (API), and Jupiter (Solana). Categories and market statuses are normalized across platforms.
For platform-specific details, see: Polymarket Trades, Kalshi Trades, Jupiter Trades.

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi, jupiter).
protocolProtocol name (polymarket, kalshi).
chainBlockchain where the trade occurred. NULL for off-chain platforms (Kalshi).
trade_timestampTimestamp of the trade execution.
trade_dateDate of the trade.
trade_idUnique trade identifier per platform.
market_unique_idNative platform market identifier for this trade.
market_tickerTradeable outcome identifier.
event_tickerEvent-level grouping identifier.
market_nameMarket name.
questionThe market question text.
categoryNormalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other.
market_statusNormalized market status. Values: active, closed, settled.
token_outcomeThe outcome side of this trade (e.g. Yes, No).
yes_pricePrice of the Yes outcome at time of trade (0 to 1 scale).
no_pricePrice of the No outcome at time of trade (0 to 1 scale).
taker_pricePrice paid by the taker.
num_sharesTrade size (outcome shares for Polymarket, contracts for Kalshi/Jupiter).
usd_amountTrade value in USD.
fee_usdTrading fee in USD. NULL for Kalshi.
makerMaker wallet address. Polymarket only.
takerTaker wallet address. Polymarket and Jupiter only.
transaction_hashOn-chain transaction hash. NULL for Kalshi.
resolution_outcomeFinal resolution outcome of the market this trade belongs to. NULL if the market has not yet resolved.
extrasVARIANT column with platform-specific fields.
_created_atRecord creation timestamp.
_updated_atRecord 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