Skip to main content
The solana.predictions.trades table contains all prediction market trades executed on Solana prediction market projects.

​
Table Columns

Column NameData TypeDescription
projectVARCHARProject identifier (ex. jupiter).
protocolVARCHARProtocol identifier (ex. kalshi - the underlying liquidity provider).
trade_dateDATEDate of the trade execution (used for partitioning).
timestampTIMESTAMP_NTZ(9)Timestamp when the order fill was executed on-chain.
trade_idVARCHARUnique identifier for the trade.
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_priceFLOATYES price at execution (0-1 scale).
no_priceFLOATNO price at execution (0-1 scale).
taker_priceFLOATActual execution price paid by the taker for their side.
usdc_priceFLOATUSDC/USD exchange rate at trade time.
venue_fee_usdFLOATKalshi venue fee paid in USD.
order_created_timeTIMESTAMP_NTZ(9)Timestamp when the order was created on-chain.
order_txn_idVARCHARTransaction hash of the order creation.
fill_txn_idVARCHARTransaction hash of the trade execution.
extrasVARIANTAdditional technical fields.
_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

  • yes_price + no_price = 1.0: Complementary pricing ensures the sum equals 1
  • 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 (0.0 to 1.0)