Trades Enriched 🌱 - Allium Documentation Hub

The bsc.predictions.trades_enriched table is a prediction-market trade fill on BNB Smart Chain with the market question, category, and resolution on the same row. project identifies the venue.

Table Details

Property	Value
Table Name	`bsc.predictions.trades_enriched`
Table Status	Beta 🌱
Unique Key	`unique_id`

side is the maker’s resting order. 0 / BUY is a bid. 1 / SELL is an ask. taker is the other party. Null when the project has no maker order.

fee_amount is the net fee after rebates recorded on the trade.

Market fields match markets. Fields the project does not provide are null.

Table Columns

Column Name	Data Type	Description
event_name	VARCHAR	Trade event name.
project	VARCHAR	Project name.
protocol	VARCHAR	Protocol name.
exchange_type	VARCHAR	Exchange type.
contract_version	VARCHAR	Contract version. Null when the project does not set one.
side	NUMBER(38,0)	Maker order side. 0 is a bid, 1 is an ask. Null when the project has no maker order.
side_name	VARCHAR	BUY when the maker posted a bid, SELL when the maker posted an ask. Null when the project has no maker order.
builder	VARCHAR	Builder attribution on the order. Null when the project does not set one.
metadata	VARCHAR	Extra per-order data. Null when the project does not set it.
condition_id	VARCHAR	Onchain condition id for the market.
market_id	VARCHAR	Market id.
market_name	VARCHAR	Market name.
market_description_onchain	VARCHAR	Market description recorded onchain. Null when none is recorded.
question_id	VARCHAR	Question id for the market.
question	VARCHAR	Market question.
question_description	VARCHAR	Resolution rules.
neg_risk	BOOLEAN	True when the market uses a negative-risk structure. Null when the project does not set it.
category	VARCHAR	Market category. `other` when the market has no category.
sub_category	VARCHAR	Finer category under `category`. Null when the project does not set one.
tags	VARCHAR	Tags for the market.
asset_id	VARCHAR	Outcome token id. Same value as `token_id` on markets.
token_outcome	VARCHAR	Outcome label of the traded token.
token_outcome_name	VARCHAR	Outcome label and question.
token_price	FLOAT	Latest price of the outcome token. Null when the project does not publish one.
is_winning_outcome	BOOLEAN	True when the traded token won. Null while the market has no result, and on a draw.
market_address	VARCHAR	Exchange contract address.
order_hash	VARCHAR	Hash of the maker order.
maker	VARCHAR	Maker address.
taker	VARCHAR	Taker address.
collateral_amount_raw	VARCHAR	Collateral amount in raw token units.
token_amount_raw	VARCHAR	Outcome token amount in raw units.
price_str	VARCHAR	Trade price as text, so precision is not lost.
trade_price	FLOAT	Trade price.
maker_amount_raw	VARCHAR	Maker order amount in raw units.
taker_amount_raw	VARCHAR	Taker order amount in raw units.
fee_charged_raw	VARCHAR	Gross fee charged on the trade, in raw collateral units.
fee_rebate_raw	VARCHAR	Rebate in raw collateral units. 0 when the trade has no rebate.
fee_raw	VARCHAR	Net fee in raw collateral units, after the rebate.
fee_charged_event_count	NUMBER(38,0)	Number of fee charges on this transaction.
fee_rebate_event_count	NUMBER(38,0)	Number of rebates on this transaction. 0 when the trade has no rebate.
collateral_amount	VARCHAR	Collateral amount in token units.
fee_charged_amount	VARCHAR	Gross fee charged on the trade, in collateral token units.
fee_rebate_amount	VARCHAR	Rebate in collateral token units. 0 when the trade has no rebate.
fee_amount	VARCHAR	Net fee in collateral token units, after the rebate.
fee_bips	VARCHAR	Fee in basis points. Null when the project does not publish one.
collateral_token_address	VARCHAR	Collateral token address.
collateral_token_name	VARCHAR	Collateral token name.
collateral_token_symbol	VARCHAR	Collateral token symbol.
collateral_token_decimals	NUMBER(38,0)	Collateral token decimals.
usd_exchange_rate	FLOAT	USD price of the collateral token at the time of the trade.
usd_collateral_amount	FLOAT	USD value of the collateral amount.
usd_fee_charged_amount	FLOAT	USD value of the gross fee.
usd_fee_rebate_amount	FLOAT	USD value of the rebate.
usd_fee_amount	FLOAT	USD value of the net fee.
fee_type	VARCHAR	Fee scheme. Null when the project does not set one.
fees_enabled	BOOLEAN	True when fees are charged on this market. Null when the project does not set it.
rfq_enabled	BOOLEAN	True when the market accepts RFQ orders. Null when the project does not set it.
fee_rebate_rate	FLOAT	Maker fee rebate rate. Null when the project does not set one.
fee_rate	FLOAT	Base fee rate. Null when the project does not set one.
fee_exponent	FLOAT	Fee curve exponent. Null when the project does not set one.
fee_taker_only	BOOLEAN	True when only the taker is charged a fee. Null when the project does not set it.
maker_base_fee_bps	NUMBER(38,0)	Base maker fee in basis points. Null when the project does not set one.
taker_base_fee_bps	NUMBER(38,0)	Base taker fee in basis points. Null when the project does not set one.
extras	VARIANT	Additional market fields. Contents vary by project.
oracle	VARCHAR	Oracle address. Null when the project does not set one.
resolution_outcome	VARCHAR	yes, no, or draw. Null when no result has been reported, including markets whose status is already resolved.
transaction_index	NUMBER(38,0)	Transaction index in the block.
transaction_hash	VARCHAR	Transaction hash.
log_index	NUMBER(38,0)	Log index of the trade in the transaction.
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp.
block_number	NUMBER(38,0)	Block number.
block_hash	VARCHAR	Block hash.
unique_id	VARCHAR	Unique row id.
_created_at	TIMESTAMP_NTZ(9)	When this row was first written.
_updated_at	TIMESTAMP_NTZ(9)	When this row was last updated.
parlay_description	VARCHAR	Parlay description. Null when the trade is not a parlay.
combo_n_legs	NUMBER(38,0)	Number of legs in a parlay. Null when the trade is not a parlay.
combo_all_legs_resolved	BOOLEAN	True when every parlay leg has resolved. Null when the trade is not a parlay.

Sample Query

select
  project,
  transaction_hash,
  question,
  category,
  token_outcome,
  usd_collateral_amount,
  usd_fee_amount,
  block_timestamp
from bsc.predictions.trades_enriched
where block_timestamp >= '2026-09-28'
  and block_timestamp < '2026-09-29'
limit 100;

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query