| 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. |
| SIX_HOUR_PERIOD | TIMESTAMP_NTZ | The 6-hour time bucket for the aggregation, calculated by rounding down block_timestamp to the nearest 6-hour interval. |
| HALF_DAY | TIMESTAMP_NTZ | The 12-hour (half-day) time bucket for the aggregation, calculated by rounding down block_timestamp to the nearest 12-hour interval. |
| DAY | TIMESTAMP_NTZ | The daily time bucket for the aggregation, truncated to the start of the day. |
| WEEK | TIMESTAMP_NTZ | The weekly time bucket for the aggregation, truncated to the start of the week. |
| MONTH | TIMESTAMP_NTZ | The monthly time bucket for the aggregation, truncated to the start of the month. |
| QUESTION | TEXT | The human-readable question that defines the market. This question outlines the specific event or scenario that the market is based on. |
| 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. |
| TOTAL_AMOUNT_USD | FLOAT | The total USD value of all orders in the time period. |
| AVG_AMOUNT_USD | FLOAT | The average USD value per order in the time period. |
| TOTAL_SHARE_AMOUNT | FLOAT | The total number of shares traded in the time period. |
| AVG_SHARE_AMOUNT | FLOAT | The average number of shares per order in the time period. |
| TOTAL_PRICE_PER_SHARE | FLOAT | The sum of all pricepershare values in the time period. |
| AVG_PRICE_PER_SHARE | FLOAT | The average price per share across all orders in the time period. |
| MIN_PRICE_PER_SHARE | FLOAT | The minimum price per share in the time period. |
| MAX_PRICE_PER_SHARE | FLOAT | The maximum price per share in the time period. |
| YES_AVG_PRICE_PER_SHARE | FLOAT | The average price per share for Yes outcome tokens in the time period. |
| YES_AVG_SHARE_AMOUNT | FLOAT | The average number of shares for Yes outcome tokens in the time period. |
| YES_SHARE_AMOUNT | FLOAT | The total number of shares for Yes outcome tokens in the time period. |
| YES_AMOUNT_USD | FLOAT | The total USD value of Yes outcome token orders in the time period. |
| NO_AVG_PRICE_PER_SHARE | FLOAT | The average price per share for No outcome tokens in the time period. |
| NO_AVG_SHARE_AMOUNT | FLOAT | The average number of shares for No outcome tokens in the time period. |
| NO_SHARE_AMOUNT | FLOAT | The total number of shares for No outcome tokens in the time period. |
| NO_AMOUNT_USD | FLOAT | The total USD value of No outcome token orders in the time period. |
| SPREAD | FLOAT | The difference between Yes and No average price per share, calculated as yesavgpricepershare - noavgpricepershare. |
| YES_NO_USD_DELTA | FLOAT | The difference in USD value between Yes and No outcomes, calculated as yesamountusd - noamountusd. |
| YES_NO_SHARE_AMOUNT_DELTA | FLOAT | The difference in share amounts between Yes and No outcomes, calculated as yesshareamount - noshareamount. |
| 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. |
| EZ_PREDICTION_MARKET_Y_N_DELTAS_ID | TEXT | The unique identifier for the prediction market yes/no deltas record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was last modified. |
