Skip to main content
The solana.predictions.trades table contains all prediction market trades executed on Solana. Covers Jupiter and DFlow prediction markets using Kalshi as the underlying protocol. Trades are decoded from on-chain fill instructions, enriched with order data and token prices.

​
Table Columns

Column NameData TypeDescription
projectVARCHARProject identifier (jupiter or dflow).
protocolVARCHARProtocol identifier (kalshi).
trade_dateDATEDate of the trade execution (used for partitioning).
timestampTIMESTAMP_NTZ(9)Timestamp when the fill instruction was executed on-chain.
trade_idVARCHARUnique identifier for the trade (Kalshi order ID from fill params).
tickerVARCHARKalshi market ticker identifier (e.g., KXFEDDECISION-25DEC-C25).
num_contractsINTEGERNumber of contracts filled in this trade.
user_addressVARCHARSolana wallet address of the user who placed the order.
actionVARCHARTrade action (buy or sell) - buy increases position, sell decreases position.
taker_sideVARCHARSide taken by the taker (yes or no).
maker_sideVARCHARSide taken by the maker (opposite of taker_side).
yes_priceFLOATDerived YES price at execution (0-1 scale). Calculated from taker_price using complementary pricing (yes_price + no_price = 1.0).
no_priceFLOATDerived NO price at execution (0-1 scale). Calculated from taker_price using complementary pricing (yes_price + no_price = 1.0).
taker_priceFLOATActual execution price paid by the taker for their side.
settlement_token_priceFLOATSettlement token USD price at trade time (USDC or CASH depending on project).
venue_fee_usdFLOATKalshi venue fee paid in USD.
order_created_timeTIMESTAMP_NTZ(9)Timestamp when the order was created on-chain (from create_order instruction).
order_txn_idVARCHARTransaction signature of the create_order instruction.
fill_txn_idVARCHARTransaction signature of the fill instruction (fill_buy_order or fill_sell_order).
extrasVARIANTJSON object containing technical fields (position_pda, order_pda, external_order_id).
_created_atTIMESTAMP_NTZ(9)Timestamp when the record was created in Allium’s database.
_updated_atTIMESTAMP_NTZ(9)Timestamp when the record was last updated in Allium’s database.

​
Sample Queries

Analyze trading activity for a specific user:
select
  timestamp,
  ticker,
  user_address,
  action,
  taker_side,
  num_contracts,
  taker_price,
  venue_fee_usd,
  fill_txn_id
from solana.predictions.trades
where user_address = 'YOUR_WALLET_ADDRESS'
  and trade_date >= current_date - interval '30 days'
order by timestamp desc

​
Understanding Price Fields

  • taker_price: The actual price paid by the taker for their chosen side (yes or no).
  • Price scale: All prices are on a 0-1 scale.