| BLOCKCHAIN | TEXT | Blockchain, Network, or Platform the transaction or event occurs on. |
| PLATFORM | TEXT | The platform on which the prediction market operates. |
| PROTOCOL | TEXT | The protocol name for the prediction market. |
| PROTOCOL_VERSION | TEXT | The version of the protocol being used. |
| CONDITION_ID | TEXT | ID of the specific market, linking it to the event or question it is based on. |
| QUESTION | TEXT | The actual question the market is based on, which defines the event participants are betting on. |
| DESCRIPTION | TEXT | A detailed description of the market, providing context and additional information about the question. |
| TOKENS | VARIANT | The tokens associated with the market outcomes. |
| TOKEN_1_TOKEN_ID | TEXT | Token ID for the first outcome in the market, making on-chain data human-readable. |
| TOKEN_1_OUTCOME | TEXT | Outcome associated with the first token, typically indicating ‘yes’ or ‘no.‘ |
| TOKEN_1_WINNER | TEXT | Indicates the winner status of the first token, showing if it was the successful outcome. |
| TOKEN_2_TOKEN_ID | TEXT | Token ID for the second outcome in the market, making on-chain data human-readable. |
| TOKEN_2_OUTCOME | TEXT | Outcome associated with the second token, typically indicating ‘yes’ or ‘no.‘ |
| TOKEN_2_WINNER | TEXT | Indicates the winner status of the second token, showing if it was the successful outcome. |
| ENABLE_ORDER_BOOK | TEXT | Indicates if the order book feature is enabled for this market. |
| ACTIVE | BOOLEAN | Indicates if the market is currently live and accepting participation. |
| CLOSED | BOOLEAN | Indicates if the market is not currently live or has concluded. |
| ARCHIVED | BOOLEAN | Indicates if the market has been archived. |
| ACCEPTING_ORDERS | BOOLEAN | Indicates if the market is currently accepting new orders. |
| ACCEPTING_ORDER_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the market started accepting orders. |
| MINIMUM_ORDER_SIZE | NUMBER | Minimum size of an order in the market, determining the smallest amount participants can trade. |
| MINIMUM_TICK_SIZE | NUMBER | Minimum tick size for the market, indicating the smallest price increment for orders. |
| QUESTION_ID | TEXT | ID of the question associated with the market, used to link market data with the underlying event or scenario. |
| MARKET_SLUG | TEXT | The URL-friendly identifier for the market. |
| END_DATE_ISO | TIMESTAMP_NTZ | End date of the market in ISO 8601 format, indicating when the market will resolve. |
| GAME_START_TIME | TIMESTAMP_NTZ | Start time of the event associated with the market, used for timing-related aspects of trading. |
| SECONDS_DELAY | NUMBER | The delay in seconds before the market resolves after the event occurs. |
| FPMM | TEXT | Fixed Product Market Maker indicator for the market. |
| MAKER_BASE_FEE | NUMBER | Base fee charged to makers in the market for providing liquidity. |
| TAKER_BASE_FEE | NUMBER | Base fee charged to takers in the market for executing trades against maker orders. |
| NOTIFICATIONS_ENABLED | BOOLEAN | Indicates if notifications are enabled for this market. |
| NEG_RISK | BOOLEAN | Indicates if negative risk is present in the market, highlighting specific risk conditions. |
| NEG_RISK_MARKET_ID | TEXT | The ID of the negative risk market associated with this market. |
| NEG_RISK_REQUEST_ID | TEXT | The ID of the negative risk request associated with this market. |
| REWARDS | VARIANT | Rewards information for the market. |
| TAGS | VARIANT | Tags associated with the market for categorization and filtering. |
| EVENT_ID | TEXT | The unique identifier for the event, from the dimpredictionmarkets table. |
| EVENT_SLUG | TEXT | The URL-friendly identifier for the event, from the dimpredictionmarkets table. |
| EVENT_TITLE | TEXT | The plain text title of the event associated with the market, from the dimpredictionmarkets table. Questions will typically roll up to event titles. A good column to track an entire specific polymarket market (ie. Fed decision in January?). This is the best representation of a market when it is a multi-choice market with multiple questions/outcomes. |
| EVENT_SUBTITLE | TEXT | The subtitle of the event associated with the market. |
| EVENT_DESCRIPTION | TEXT | A detailed description of the event associated with the market. |
| EVENT_CATEGORY | TEXT | The category of the event (e.g., politics, sports, crypto). |
| EVENT_SUBCATEGORY | TEXT | The subcategory of the event, providing more specific classification. |
| EVENT_ACTIVE | BOOLEAN | Indicates if the event is currently active. |
| EVENT_CLOSED | BOOLEAN | Indicates if the event has been closed. |
| EVENT_RESTRICTED | BOOLEAN | Indicates if the event has restrictions. |
| EVENT_ARCHIVED | BOOLEAN | Indicates if the event has been 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 | The start date of the event. |
| EVENT_END_DATE | TIMESTAMP_NTZ | The end date of the event. |
| EVENT_CREATION_DATE | TIMESTAMP_NTZ | The date when the event was created. |
| EVENT_TAGS | TEXT | Tags associated with the event for categorization and filtering. |
| MARKET_ID | TEXT | The unique identifier for the market from the event data. |
| MARKET_SLUG_FROM_EVENT | TEXT | The market slug from the event data. |
| MARKET_CLOB_TOKEN_IDS | TEXT | The CLOB token IDs for the market from the event data. |
| MARKET_OUTCOMES | VARIANT | The outcomes available in the market from the event data. |
| MARKET_OUTCOME_PRICES | VARIANT | The prices for each outcome in the market from the event data. |
| GROUP_ITEM_TITLE | TEXT | The title of the group item associated with the market. |
| GROUP_ITEM_THRESHOLD | FLOAT | The threshold value for the group item associated with the market. |
| MARKET_ACTIVE | BOOLEAN | Indicates if the market is active from the event data. |
| MARKET_CLOSED | BOOLEAN | Indicates if the market is closed from the event data. |
| MARKET_RESTRICTED | BOOLEAN | Indicates if the market is restricted from the event data. |
| MARKET_NEG_RISK_OTHER | BOOLEAN | Other negative risk information for the market from the event data. |
| MARKET_END_DATE_FROM_EVENT | TIMESTAMP_NTZ | The end date of the market from the event data. |
| MARKET_CREATED_AT | TIMESTAMP_NTZ | The timestamp when the market was created from the event data. |
| MARKETS_IN_EVENT | NUMBER | The number of markets associated with the event. |
| DIM_MARKETS_ID | TEXT | The unique identifier for the prediction market. |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was inserted into the source table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was last modified. |
