stellar.price Table: fact_prices_ohlc_hourly Type: Base Table
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 |
|---|---|---|
| PROVIDER_ASSET_ID | TEXT | The unique identifier representing the asset. |
| HOUR | TIMESTAMP_NTZ | The hour at which the token price was recorded on this EVM blockchain. |
| 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 | The provider or source of the data. |
| FACT_PRICES_OHLC_HOURLY_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |