Trades - Allium Documentation Hub

The solana.predictions.trades table contains all prediction market trades executed on Solana. Covers Jupiter, DFlow, and World. Jupiter serves Kalshi and Polymarket markets, DFlow serves Kalshi markets, and World is a Solana-native binary prediction market. Each row is a single trade fill with order context and USD pricing.

Table Details

Property	Value
Table Name	`solana.predictions.trades`
Table Status	Production-Ready

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Project identifier (jupiter, dflow, or world).
protocol	VARCHAR(16777216)	Protocol identifier (kalshi, polymarket, or world).
trade_date	DATE	Date of the trade execution.
timestamp	TIMESTAMP_NTZ(9)	Timestamp when the trade executed on-chain.
trade_id	VARCHAR(16777216)	Unique identifier for the trade (venue order ID).
ticker	VARCHAR(16777216)	Market ticker identifier (e.g., KXFEDDECISION-25DEC-C25). On-chain market address for World rows.
num_contracts	FLOAT	Number of contracts filled in this trade.
user_address	VARCHAR(16777216)	Solana wallet address of the user who placed the order.
action	VARCHAR(16777216)	Trade action (buy or sell) - buy increases position, sell decreases position.
taker_side	VARCHAR(16777216)	Side taken by the taker (yes or no).
maker_side	VARCHAR(16777216)	Side taken by the maker (opposite of taker_side).
yes_price	FLOAT	YES outcome price at execution, on a 0-1 scale. yes_price + no_price = 1.
no_price	FLOAT	NO outcome price at execution, on a 0-1 scale. yes_price + no_price = 1.
taker_price	FLOAT	Execution price paid by the taker for their side, on a 0-1 scale.
settlement_token_price	FLOAT	Settlement token USD price at trade time (USDC, JupUSD, or CASH depending on project).
venue_fee_usd	FLOAT	Venue fee paid in USD.
order_created_time	TIMESTAMP_NTZ(9)	Timestamp when the order was created on-chain. Null for World, which has no separate order-creation step.
order_txn_id	VARCHAR(16777216)	Transaction signature of the order-creation transaction. Null for World.
fill_txn_id	VARCHAR(16777216)	Transaction signature of the fill transaction.
extras	VARIANT	Platform-specific metadata for the trade.
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created in Allium’s database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated in Allium’s database.

Sample Queries

User Trading Activity

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.