bsc.predictions.trades table is prediction-market trade fills on BNB Smart Chain. Each row is one fill. project identifies the venue.
Table Details
| Property | Value |
|---|---|
| Table Name | bsc.predictions.trades |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, transaction_hash, log_index |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | transaction_hash |
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.Table Columns
_raw amounts are unnormalized. price_str keeps the trade price as text.
| 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. |
| market_address | VARCHAR | Exchange contract address. |
| order_hash | VARCHAR | Hash of the maker order. |
| maker | VARCHAR | Maker address. |
| taker | VARCHAR | Taker address. |
| 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. |
| asset_id | VARCHAR | Outcome token id. Same value as token_id on markets. |
| 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. |
| 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_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. |
| 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. |
| 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. |
| 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. |
Sample Query
select
project,
transaction_hash,
maker,
taker,
price,
usd_collateral_amount,
block_timestamp
from bsc.predictions.trades
where block_timestamp >= '2026-09-28'
and block_timestamp < '2026-09-29'
limit 100;