near.price Table: fact_prices_ohlc_hourly Type: View
Description
This table contains hourly OHLC (Open, High, Low, Close) price data for all tracked assets on the NEAR Protocol blockchain, capturing price movements and volatility patterns across different time periods. The data includes comprehensive price information from multiple providers, enabling detailed market analysis, volatility assessment, and price trend identification. This table provides the foundation for price analytics, market analysis, and economic calculations across the NEAR ecosystem.Key Use Cases
- Asset price trend analysis and market movement tracking
- Volatility analysis and risk assessment
- Price correlation analysis across different assets
- Market timing analysis and trading pattern identification
- Cross-provider price validation and data quality assessment
- Economic impact analysis of price movements
- Portfolio performance tracking and value calculations
Important Relationships
- Links to
price.dim_asset_metadatathrough asset_id for asset identification - Provides price data for
price.ez_prices_hourlywith enhanced metadata - Supports
price.ez_asset_metadatawith comprehensive price context - Enables analysis in
stats.ez_core_metrics_hourlyfor price metrics - Powers value calculations across all token-related models
- Supports cross-asset analysis and market correlation studies
Commonly-used Fields
hour: Essential for time-series analysis and trend detectionopen,high,low,close: Critical for price movement analysis and volatility calculationasset_id: Important for asset-specific price analysis and correlationprovider: Useful for price data source identification and reliability assessmentinserted_timestamp: Important for data freshness and update trackingfact_prices_ohlc_hourly_id: Essential for unique price record identification
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 at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which this record was last modified by an internal process. |
| FACT_PRICES_OHLC_HOURLY_ID | TEXT | A unique identifier for the record. |