Fact Prices Ohlc Hourly

price.fact_prices_ohlc_hourly

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