crosschain.defi Table: ez_prediction_market_hourly_ohlc Type: View
What
This table contains hourly OHLC (Open, High, Low, Close) price data for prediction market orders, aggregated by hour, question, outcome, and question_id. It includes event metadata from the dim_prediction_markets table. This is one of the best places to track Polymarket odds, providing a comprehensive and reliable view of how market sentiment and prices evolve over time.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | BLOCKCHAIN column |
| PLATFORM | TEXT | PLATFORM column |
| PROTOCOL | TEXT | PROTOCOL column |
| PROTOCOL_VERSION | TEXT | PROTOCOL_VERSION column |
| HOUR | TIMESTAMP_NTZ | The hourly time bucket for the aggregation, truncated to the start of the hour. |
| OUTCOME | TEXT | The specific result direction for a token within the market, typically indicating either ‘yes’ or ‘no.‘ |
| QUESTION | TEXT | The human-readable question that defines the market. This question outlines the specific event or scenario that the market is based on. |
| QUESTION_ID | TEXT | The unique identifier for the question in the prediction market. |
| 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_ID | TEXT | The unique identifier for the event, from the dimpredictionmarkets table. |
| OPEN_PRICE | FLOAT | The opening price per share for the hour, calculated as the pricepershare of the first order in the hour, multiplied by 100 to convert to percentage. |
| HIGH_PRICE | FLOAT | The highest price per share during the hour, calculated as the maximum pricepershare in the hour, multiplied by 100 to convert to percentage. |
| LOW_PRICE | FLOAT | The lowest price per share during the hour, calculated as the minimum pricepershare in the hour, multiplied by 100 to convert to percentage. |
| CLOSE_PRICE | FLOAT | The closing price per share for the hour, calculated as the pricepershare of the last order in the hour, multiplied by 100 to convert to percentage. |
| TOTAL_ORDERS | NUMBER | The total number of orders in the hour. |
| TOTAL_SHARES | FLOAT | TOTAL_SHARES column |
| TOTAL_AMOUNT_USD | FLOAT | TOTAL_AMOUNT_USD column |
| AVG_AMOUNT_USD | FLOAT | AVG_AMOUNT_USD column |
| DIM_CONDITION_ID | TEXT | DIM_CONDITION_ID column |
| EZ_PREDICTION_MARKET_HOURLY_OHLC_ID | TEXT | EZ_PREDICTION_MARKET_HOURLY_OHLC_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when the record was last modified. |