Skip to main content

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.

The crosschain.predictions.trades table contains prediction market trades. Use project and protocol to filter by venue.
For platform-specific details, see: Polymarket Trades, Polymarket US Trades, Kalshi Trades, Jupiter Trades.

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi, jupiter, polymarket_us).
protocolProtocol name (polymarket, kalshi, polymarket_us).
chainBlockchain where the trade settled, when applicable. NULL for off-chain venues (Kalshi, Polymarket US).
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.
sub_categorySubcategory for narrower topic scoping. Polymarket only.
market_statusNormalized market status. Values: active, closed, settled.
token_outcomeThe outcome side of this trade (e.g. Yes, No). NULL for Polymarket US.
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 in outcome shares or contracts.
usd_amountTrade value in USD.
fee_usdTrading fee in USD. NULL for Kalshi.
makerMaker wallet address. Polymarket only. NULL for Kalshi, Jupiter, and Polymarket US.
takerTaker wallet address. Polymarket and Jupiter only. NULL for Kalshi and Polymarket US.
transaction_hashOn-chain transaction hash. NULL for Kalshi and Polymarket US.
resolution_outcomeFinal resolution outcome of the market this trade belongs to. NULL if the market has not yet resolved.
extrasVARIANT column with platform-specific metadata.
_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