| 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. |
| BLOCK_NUMBER | NUMBER | The block number at which the transaction is finalized. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this transaction in UTC |
| ORIGIN_FROM_ADDRESS | TEXT | The address that initiates the transaction. If a transaction generates multiple events, all of them will have the same originfromaddress. |
| ORIGIN_TO_ADDRESS | TEXT | The address that receives the transaction. If a transaction generates multiple events, all of them will have the same origintoaddress. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of this transaction. |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| EVENT_INDEX | NUMBER | Event number within a transaction. |
| EVENT_NAME | TEXT | The name of the event. |
| CONTRACT_ADDRESS | TEXT | The address of the contract interacted with. |
| QUESTION | TEXT | The human-readable question that defines the market. This question outlines the specific event or scenario that the market is based on, and participants bet on the outcome. |
| MARKET_SLUG | TEXT | The URL-friendly identifier for the market. |
| END_DATE_ISO | TIMESTAMP_NTZ | The date and time when the market will resolve, formatted in ISO 8601 (YYYY-MM-DDTHH:MM:SSZ). This marks the point at which the outcome is determined based on the question. |
| OUTCOME | TEXT | The specific result direction for a token within the market, typically indicating either ‘yes’ or ‘no.’ This represents the outcome of the market question. |
| ORDER_HASH | TEXT | A unique cryptographic hash that identifies the order within the prediction market system. It serves as a unique reference for transactions related to buying or selling shares in the market. |
| MAKER | TEXT | The address or identifier of the maker in the transaction, who provides liquidity or initiates an order within the market, setting the initial terms for others to take. |
| TAKER | TEXT | The address or identifier of the taker in the transaction, who accepts the order created by the maker and completes the trade under the terms specified. |
| CONDITION_ID | TEXT | The unique identifier for the market’s specific condition, linking it to a particular event or question. This ID is used to manage and resolve market outcomes. |
| QUESTION_ID | TEXT | The unique identifier for the question in the prediction market. |
| ASSET_ID | TEXT | The unique identifier of the asset addressing the question outcome, used to join with off-chain API data. |
| MAKER_ASSET_ID | TEXT | The unique identifier of the asset provided by the maker in the transaction. |
| TAKER_ASSET_ID | TEXT | The unique identifier of the asset provided by the taker in the transaction. |
| AMOUNT_USD | FLOAT | The total value of the bet placed, expressed in USD. |
| SHARES | FLOAT | The number of shares purchased in the order. |
| PRICE_PER_SHARE | FLOAT | The cost per individual share in the transaction, which also serves as a proxy for the current market percentage chance of the outcome associated with this question. |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was inserted into the source table. |
| _LOG_ID | TEXT | The unique identifier for the log entry in the source 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. |
| MARKET_DESCRIPTION | TEXT | A detailed description of the market, providing context and additional information about the question, from the dimpredictionmarkets table. |
| DIM_CONDITION_ID | TEXT | The condition ID from the dimpredictionmarkets table, linking it to the market metadata. |
| 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. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was last modified. |
| EZ_PREDICTION_MARKET_ORDERS_ID | TEXT | The unique identifier for the prediction market order. |
