movement.price Table: fact_prices_ohlc_hourly Type: View
Hourly OHLC (Open, High, Low, Close) pricing data. Contains candlestick price data for assets.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| HOUR | TIMESTAMP_NTZ | The hourly time bucket. |
| ASSET_ID | TEXT | Unique asset identifier. |
| OPEN | FLOAT | Opening price for the hour. |
| HIGH | FLOAT | Highest price during the hour. |
| LOW | FLOAT | Lowest price during the hour. |
| CLOSE | FLOAT | Closing price for the hour. |
| FACT_PRICES_OHLC_HOURLY_ID | TEXT | Unique identifier for the row. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified. |