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 across Polymarket (Polygon), Polymarket US, Kalshi (API), Gemini (API), and Solana venues (Jupiter and DFlow). 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, gemini).
protocolProtocol name (polymarket, kalshi, polymarket_us, gemini). Jupiter rows may show kalshi or polymarket depending on the market.
chainBlockchain where the trade settled, when applicable. NULL for off-chain venues (Kalshi, Polymarket US, Gemini).
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_outcomeOutcome side of the trade (yes or no). Populated for Polymarket and Gemini. NULL for Polymarket US.
yes_pricePrice of the Yes outcome on a 0 to 1 scale. For Gemini, inverted when the traded leg is No.
no_pricePrice of the No outcome on a 0 to 1 scale. For Gemini, inverted when the traded leg is No.
taker_pricePrice paid by the taker.
num_sharesTrade size in outcome shares or contracts. Polymarket uses outcome shares; Kalshi, Gemini, Jupiter, DFlow, and Polymarket US use contract counts.
usd_amountTrade value in USD.
fee_usdNET trading fee in USD (gross charged minus on-chain rebate). For Polymarket: on-chain FeeCharged minus FeeRefunded. For Jupiter, DFlow, and Polymarket US: equals gross_fee_usd because these platforms have no on-chain rebate. NULL for Kalshi and Gemini.
gross_fee_usdPre-rebate fee in USD charged to the taker. Polymarket V1 populates from on-chain FeeCharged events. Equals fee_usd for platforms without rebates (Jupiter, DFlow, Polymarket US). NULL for Kalshi and Gemini.
rebate_fee_usdMaker rebate paid back on-chain in USD. Polymarket V1 only (FeeRefunded events). V2 Polymarket rebates are batched off-event (not captured here). NULL for Jupiter, DFlow, Polymarket US, Kalshi, and Gemini.
makerMaker wallet address. Polymarket only. NULL for Kalshi, Jupiter, Polymarket US, and Gemini.
takerTaker wallet address. Polymarket and Jupiter only. NULL for Kalshi, Polymarket US, and Gemini.
transaction_hashOn-chain transaction hash. NULL for Kalshi, Polymarket US, and Gemini.
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. Gemini includes buy/sell direction in taker_side and maker_side.
_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