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

​
Description

This table contains curated hourly price data for Bitcoin and other assets, providing a simplified view of market prices with one price per hour per unique asset and blockchain. Each row represents a single asset’s price for a specific hour, including the closing price in USD and associated metadata. This easy view aggregates data from multiple price providers and applies curation logic to ensure data quality and consistency, making it the preferred table for price analysis in most analytical scenarios.

​
Key Use Cases

  • Simplified price analysis and market trend identification
  • Asset valuation and market performance tracking
  • Price impact analysis for blockchain events and transactions
  • Cross-asset price comparison and correlation studies
  • Historical price data for backtesting and modeling
  • Market analysis and reporting for dashboards
  • Price-based filtering and analysis of blockchain activity

​
Important Relationships

  • Curated view of price.fact_prices_ohlc_hourly with provider prioritization
  • Referenced by price.ez_asset_metadata for asset-specific context
  • Supports core.fact_transactions for price-impact analysis
  • Used by core.fact_clustered_transfers for value-based transfer analysis
  • Enables integration with stats.ez_core_metrics_hourly for price-based metrics
  • Provides curated price context for all market-related analytics

​
Commonly-used Fields

  • hour: Essential for time-series analysis and chronological ordering
  • price: Core field for market analysis and value calculations
  • symbol: Critical for asset identification and market analysis
  • blockchain: Important for multi-chain price comparison
  • token_address: Key for blockchain-specific asset identification
  • Curated price data ensures consistency and quality across analyses

​
Columns

Column NameData TypeDescription
HOURTIMESTAMP_NTZHour that the price was recorded at.
TOKEN_ADDRESSTEXTThe specific address representing the asset on a specific platform. This will be NULL if referring to a native asset.
SYMBOLTEXTThe symbol of asset.
NAMETEXT
DECIMALSNUMBERThe number of decimals for the asset. May be NULL.
PRICEFLOATClosing price of the recorded hour in USD.
BLOCKCHAINTEXTThe Blockchain, Network, or Platform for this asset.
IS_NATIVEBOOLEANA flag indicating assets native to the respective blockchain.
IS_DEPRECATEDBOOLEANA flag indicating if the asset is deprecated or no longer supported by the provider.
IS_IMPUTEDBOOLEANA flag indicating if the price was imputed, or derived, from the last arriving record. This is generally used for tokens with low-liquidity or inconsistent reporting.
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 | | EZ_PRICES_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 |