Fact Prices Ohlc Hourly

price.fact_prices_ohlc_hourly

Schema: solana.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 when this transaction record was first inserted into the analytics database. Used for data freshness tracking and incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process.
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	The timestamp when this transaction record was last updated in the analytics database. Used for tracking updates and supporting incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process.
FACT_PRICES_OHLC_HOURLY_ID	TEXT	A unique, stable identifier for each record in this table. The primary key (PK) ensures that every row is uniquely identifiable and supports efficient joins, lookups, and data integrity across models. The PK may be a natural key (such as a blockchain transaction hash) or a surrogate key generated from one or more fields, depending on the table’s structure and requirements.