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(16777216)	Trade event name.
project	VARCHAR(16777216)	Project name.
protocol	VARCHAR(16777216)	Protocol name.
exchange_type	VARCHAR(16777216)	Exchange type.
contract_version	VARCHAR(16777216)	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(16777216)	BUY when the maker posted a bid, SELL when the maker posted an ask. Null when the project has no maker order.
builder	VARCHAR(16777216)	Builder attribution on the order. Null when the project does not set one.
metadata	VARCHAR(16777216)	Extra per-order data. Null when the project does not set it.
condition_id	VARCHAR(16777216)	Onchain condition id for the market.
market_id	VARCHAR(16777216)	Market id.
market_name	VARCHAR(16777216)	Market name.
market_description_onchain	VARCHAR(16777216)	Market description recorded onchain. Null when none is recorded.
question_id	VARCHAR(16777216)	Question id for the market.
question	VARCHAR(16777216)	Market question.
question_description	VARCHAR(16777216)	Resolution rules.
neg_risk	BOOLEAN	True when the market uses a negative-risk structure. Null when the project does not set it.
category	VARCHAR(16777216)	Market category. `other` when the market has no category.
sub_category	VARCHAR(16777216)	Finer category under `category`. Null when the project does not set one.
tags	VARCHAR(16777216)	Tags for the market.
asset_id	VARCHAR(16777216)	Outcome token id. Same value as `token_id` on markets.
token_outcome	VARCHAR(16777216)	Outcome label of the traded token.
token_outcome_name	VARCHAR(16777216)	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(42)	Exchange contract address.
order_hash	VARCHAR(16777216)	Hash of the maker order.
maker	VARCHAR(42)	Maker address.
taker	VARCHAR(42)	Taker address.
collateral_amount_raw	VARCHAR(16777216)	Collateral amount in raw token units.
token_amount_raw	VARCHAR(16777216)	Outcome token amount in raw units.
price_str	VARCHAR(16777216)	Trade price as text, so precision is not lost.
trade_price	FLOAT	Trade price.
maker_amount_raw	VARCHAR(16777216)	Maker order amount in raw units.
taker_amount_raw	VARCHAR(16777216)	Taker order amount in raw units.
fee_charged_raw	VARCHAR(16777216)	Gross fee charged on the trade, in raw collateral units.
fee_rebate_raw	VARCHAR(16777216)	Rebate in raw collateral units. 0 when the trade has no rebate.
fee_raw	VARCHAR(16777216)	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(16777216)	Collateral amount in token units.
fee_charged_amount	VARCHAR(16777216)	Gross fee charged on the trade, in collateral token units.
fee_rebate_amount	VARCHAR(16777216)	Rebate in collateral token units. 0 when the trade has no rebate.
fee_amount	VARCHAR(16777216)	Net fee in collateral token units, after the rebate.
fee_bips	VARCHAR(16777216)	Fee in basis points. Null when the project does not publish one.
collateral_token_address	VARCHAR(42)	Collateral token address.
collateral_token_name	VARCHAR(16777216)	Collateral token name.
collateral_token_symbol	VARCHAR(16777216)	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(16777216)	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(42)	Oracle address. Null when the project does not set one.
resolution_outcome	VARCHAR(16777216)	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(66)	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(66)	Block hash.
unique_id	VARCHAR(16777216)	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(16777216)	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;

EVM

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query