> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Trades Enriched 🌱

> Prediction market trades on BNB Smart Chain with market question, category, and resolution on each row.

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` |

<Note>
  `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.
</Note>

<Note>
  `fee_amount` is the net fee after rebates recorded on the trade.
</Note>

<Note>
  Market fields match [markets](/historical-data/supported-blockchains/evm/bsc/predictions/markets). Fields the project does not provide are null.
</Note>

### 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](/historical-data/supported-blockchains/evm/bsc/predictions/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

```sql theme={null}
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;
```