| CONDITION_ID | TEXT | ID of the specific market (CTF condition ID). |
| QUESTION | TEXT | The actual question the market is based on. |
| DESCRIPTION | TEXT | A detailed description of the market. |
| TOKENS | VARIANT | Token information for the market. |
| TOKEN_1_TOKEN_ID | TEXT | Token ID for the first token, available on-chain to make the on-chain data human-readable. |
| TOKEN_1_OUTCOME | TEXT | Outcome for the first token, typically “yes” or “no.” |
| TOKEN_1_WINNER | TEXT | Winner status for the first token. |
| TOKEN_2_TOKEN_ID | TEXT | Token ID for the second token, available on-chain to make the on-chain data human-readable. |
| TOKEN_2_OUTCOME | TEXT | Outcome for the second token, typically “yes” or “no.” |
| TOKEN_2_WINNER | TEXT | Winner status for the second token. |
| ENABLE_ORDER_BOOK | TEXT | Indicates if the order book is enabled. |
| ACTIVE | BOOLEAN | Indicates if the market is currently live. |
| CLOSED | BOOLEAN | Indicates if the market is not currently live. |
| ARCHIVED | BOOLEAN | Indicates if the market is archived. |
| ACCEPTING_ORDERS | BOOLEAN | Indicates if the market is accepting orders. |
| ACCEPTING_ORDER_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the market started accepting orders. |
| MINIMUM_ORDER_SIZE | NUMBER | Minimum size of an order in the market. |
| MINIMUM_TICK_SIZE | NUMBER | Minimum tick size for the market. |
| QUESTION_ID | TEXT | ID of the question associated with the market (primary join key for event-market mapping). |
| MARKET_SLUG | TEXT | URL-friendly slug for the market. |
| END_DATE_ISO | TIMESTAMP_NTZ | End date of the market in ISO format. |
| GAME_START_TIME | TIMESTAMP_NTZ | Start time of the game/event associated with the market, used to trigger delay. |
| SECONDS_DELAY | NUMBER | Seconds of match delay for in-game trading. |
| FPMM | TEXT | Fixed Product Market Maker (FPMM) Polygon address. |
| MAKER_BASE_FEE | NUMBER | Base fee for makers in the market. |
| TAKER_BASE_FEE | NUMBER | Base fee for takers in the market. |
| NOTIFICATIONS_ENABLED | BOOLEAN | Indicates if notifications are enabled for the market. |
| NEG_RISK | BOOLEAN | Indicates if negative risk is present in the market. |
| NEG_RISK_MARKET_ID | TEXT | Market ID for negative risk. |
| NEG_RISK_REQUEST_ID | TEXT | Request ID for negative risk. |
| REWARDS | VARIANT | Rewards associated with the market. |
| TAGS | VARIANT | All the associated tags in the market, contained in an object. |
| EVENT_ID | TEXT | Unique identifier for the parent event (from Gamma API). |
| EVENT_SLUG | TEXT | URL-friendly slug for the parent event. |
| EVENT_TITLE | TEXT | Title of the parent event. |
| EVENT_SUBTITLE | TEXT | Subtitle of the parent event. |
| EVENT_DESCRIPTION | TEXT | Description of the parent event. |
| EVENT_CATEGORY | TEXT | Category classification of the event. |
| EVENT_SUBCATEGORY | TEXT | Subcategory classification of the event. |
| EVENT_ACTIVE | BOOLEAN | Indicates if the event is currently active. |
| EVENT_CLOSED | BOOLEAN | Indicates if the event is closed. |
| EVENT_RESTRICTED | BOOLEAN | Indicates if the event is restricted. |
| EVENT_ARCHIVED | BOOLEAN | Indicates if the event is archived. |
| EVENT_FEATURED | BOOLEAN | Indicates if the event is featured. |
| EVENT_ENABLE_NEG_RISK | BOOLEAN | Indicates if negative risk is enabled for the event. |
| EVENT_START_DATE | TIMESTAMP_NTZ | Start date/timestamp of the event. |
| EVENT_END_DATE | TIMESTAMP_NTZ | End date/timestamp of the event. |
| EVENT_CREATION_DATE | TIMESTAMP_NTZ | Creation date/timestamp of the event. |
| EVENT_TAGS | TEXT | Tags associated with the event (comma-separated). |
| MARKET_ID | TEXT | MARKET_ID column |
| MARKET_SLUG_FROM_EVENT | TEXT | Market slug as provided in the event data (may differ from market_slug). |
| MARKET_CLOB_TOKEN_IDS | TEXT | CLOB token IDs for connecting markets to trading data. |
| MARKET_OUTCOMES | VARIANT | Available outcomes for the market (JSON array). |
| MARKET_OUTCOME_PRICES | VARIANT | Current prices for each outcome (JSON array). |
| GROUP_ITEM_TITLE | TEXT | Title for grouped market items. |
| GROUP_ITEM_THRESHOLD | FLOAT | Threshold value for grouped market items. |
| MARKET_ACTIVE | BOOLEAN | Active status of the market as reported in event data. |
| MARKET_CLOSED | BOOLEAN | Closed status of the market as reported in event data. |
| MARKET_RESTRICTED | BOOLEAN | Restricted status of the market as reported in event data. |
| MARKET_NEG_RISK_OTHER | BOOLEAN | Negative risk flag for the market from event data. |
| MARKET_END_DATE_FROM_EVENT | TIMESTAMP_NTZ | End date of the market as reported in event data. |
| MARKET_CREATED_AT | TIMESTAMP_NTZ | Creation timestamp of the market as reported in event data. |
| MARKETS_IN_EVENT | NUMBER | Total number of markets in the parent event. |
| DIM_MARKETS_ID | TEXT | Surrogate key for the dimension table (conditionid + inserted_timestamp). |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted into the silver table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified. |
