Markets 🌱 - Allium Documentation Hub

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`

One row per outcome token. token_id is the same value as asset_id on trades.

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

select
  project,
  market_id,
  question,
  token_side,
  category,
  outcome
from bsc.predictions.markets
limit 100;

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query