Fact Prices Ohlc Hourly

price.fact_prices_ohlc_hourly

Schema: aurora.price Table: fact_prices_ohlc_hourly Type: View

A comprehensive fact table holding id and provider specific open, high, low, close hourly prices, from multiple providers. This data set includes raw, non-transformed data coming directly from the provider APIs and rows are not intended to be unique. As a result, there may be data quality issues persisting in the APIs that flow through to this fact based model. If you are interested in using a curated data set instead, please utilize ez_prices_hourly.

Columns

Column Name	Data Type	Description
ASSET_ID	TEXT	The unique identifier representing the asset.
HOUR	TIMESTAMP_NTZ	Hour that the price was recorded at.
OPEN	FLOAT	Opening price of the recorded hour in USD.
HIGH	FLOAT	Highest price of the recorded hour in USD
LOW	FLOAT	Lowest price of the recorded hour in USD
CLOSE	FLOAT	Closing price of the recorded hour in USD
PROVIDER	TEXT
INSERTED_TIMESTAMP	TIMESTAMP_NTZ	The timestamp at which the record was initially created and inserted into this table.
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	The timestamp at which this record was last modified by an internal process.
FACT_PRICES_OHLC_HOURLY_ID	TEXT	A uniquely generated identifier assigned by a surrogate key