Skip to main content
Schema: bitcoin.price Table: fact_prices_ohlc_hourly Type: View

​
Description

This table contains comprehensive hourly OHLC (Open, High, Low, Close) price data for Bitcoin and other assets from multiple price providers, providing detailed market information for each hour. Each row represents a single asset’s price data for a specific hour, including opening, highest, lowest, and closing prices in USD. This fact table serves as the raw price data foundation, enabling detailed market analysis, volatility studies, and price trend analysis across different time periods and assets.

​
Key Use Cases

  • Hourly price analysis and market trend identification
  • Volatility analysis and price movement studies
  • Cross-provider price comparison and data quality assessment
  • Technical analysis and chart pattern recognition
  • Market performance tracking and benchmarking
  • Price impact analysis for blockchain events
  • Historical price data for backtesting and modeling

​
Important Relationships

  • Primary fact table for hourly price data in the price ecosystem
  • Referenced by price.dim_asset_metadata for asset identification
  • Supports price.ez_prices_hourly for curated price analysis
  • Used by price.ez_asset_metadata for asset-specific price context
  • Enables integration with core.fact_transactions for price-impact analysis
  • Provides price context for stats.ez_core_metrics_hourly aggregated metrics

​
Commonly-used Fields

  • hour: Essential for time-series analysis and chronological ordering
  • asset_id: Critical for asset-specific price analysis and filtering
  • open, high, low, close: Core fields for OHLC price analysis
  • close: Key metric for end-of-period price analysis and trend detection
  • high and low: Important for volatility analysis and price range studies
  • open: Essential for price gap analysis and market opening studies

​
Columns

Column NameData TypeDescription
ASSET_IDTEXTThe unique identifier representing the asset.
HOURTIMESTAMP_NTZHour that the price was recorded at.
OPENFLOATOpening price of the recorded hour in USD.
HIGHFLOATHighest price of the recorded hour in USD
LOWFLOATLowest price of the recorded hour in USD
CLOSEFLOATClosing price of the recorded hour in USD
PROVIDERTEXT
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp (TIMESTAMP_NTZ, UTC) when this record was initially created and inserted into the table.
Example: 2024-06-01 12:34:56.000 | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp (TIMESTAMP_NTZ, UTC) when this record was last modified by an internal process. Example: 2024-06-01 12:35:00.000 | | FACT_PRICES_OHLC_HOURLY_ID | TEXT | A unique identifier (STRING or NUMBER) for the record, used as a primary key for this table. Not a blockchain-native field. Example: 123456789 |