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. |