> ## 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.

# Markets 🌱

> Prediction market metadata on BNB Smart Chain, one row per outcome token.

The `bsc.predictions.markets` table is prediction-market metadata on BNB Smart Chain. Each row is one outcome token. `project` identifies the venue.

### Table Details

| Property | Value |
| - | - |
| Table Name | `bsc.predictions.markets` |
| Table Status | Beta 🌱 |
| Unique Key | `token_id` |

<Note>
  One row per outcome token. `token_id` is the same value as `asset_id` on [trades](/historical-data/supported-blockchains/evm/bsc/predictions/trades).
</Note>

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| project | VARCHAR | Project name. |
| protocol | VARCHAR | Protocol name. |
| chain | VARCHAR | Chain name. |
| market\_id | NUMBER(38,0) | Market id. |
| parent\_market\_id | NUMBER(38,0) | Parent market id. Null when the market has no parent. |
| market\_type | VARCHAR | Market type. |
| market\_name | VARCHAR | Market name. |
| market\_title | VARCHAR | Market title. |
| parent\_title | VARCHAR | Parent market title. Null when the market has no parent. |
| question | VARCHAR | Market question. |
| description | VARCHAR | Resolution rules. |
| slug | VARCHAR | URL slug. |
| condition\_id | VARCHAR | Onchain condition id for the market. |
| question\_id | VARCHAR | Question id for the market. |
| token\_id | VARCHAR | Outcome token id, as a decimal string. |
| token\_side | VARCHAR | Outcome slot of this token, such as yes or no. |
| token\_outcome | VARCHAR | Outcome label, such as YES, UP, or a team name. |
| token\_name | VARCHAR | Outcome label and question. |
| is\_winner | BOOLEAN | True when this token won. Null while the market has no result, and on a draw. |
| outcome | VARCHAR | yes, no, or draw. Null when no result has been reported, including markets whose status is already resolved. |
| category | VARCHAR | Market category. `other` when the market has no category. |
| tags | ARRAY | Tags for the market. |
| label\_ids | ARRAY | Label ids for the market. |
| api\_labels | VARCHAR | Label names for the market. |
| status | NUMBER(38,0) | Market status code. |
| status\_enum | VARCHAR | Market status name. |
| yes\_label | VARCHAR | Label of the yes outcome. |
| no\_label | VARCHAR | Label of the no outcome. |
| result\_token\_id | VARCHAR | Winning token id, or `draw`. |
| winner | VARCHAR | `yes` or `no`. Null while the market has no result, and on a draw. |
| volume | FLOAT | Market volume. |
| quote\_token | VARCHAR | Collateral token address. |
| chain\_id | VARCHAR | Chain id. |
| collection\_title | VARCHAR | Recurring collection title. Null when the market is not part of a collection. |
| collection\_symbol | VARCHAR | Recurring collection asset symbol. |
| collection\_frequency | VARCHAR | Recurring collection period. |
| extras | VARIANT | Additional market fields. Contents vary by project. |
| created\_at | TIMESTAMP\_NTZ(9) | When the market was created. |
| cutoff\_at | TIMESTAMP\_NTZ(9) | When trading on the market closes. |
| resolved\_at | TIMESTAMP\_NTZ(9) | When the market resolved. |
| resolution\_phase | VARCHAR | Resolution phase, when the project reports one. |
| proposed\_token\_id | VARCHAR | Token id proposed as the result. |
| proposed\_at | TIMESTAMP\_NTZ(9) | When the result was proposed. |
| dispute\_deadline | TIMESTAMP\_NTZ(9) | End of the dispute window. |
| finalized\_at | TIMESTAMP\_NTZ(9) | When the result was finalized. |
| dispute\_outcome | VARCHAR | Outcome of a dispute, when there was one. |
| ingested\_at | TIMESTAMP\_NTZ(9) | When the market was first recorded. Does not change. |
| updated\_at | TIMESTAMP\_NTZ(9) | When one of the market's values last changed. |
| 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

```sql theme={null}
select
  project,
  market_id,
  question,
  token_side,
  category,
  outcome
from bsc.predictions.markets
limit 100;
```