Skip to main content

OHLCV Dataset

Overview​

The "OHLCV" dataset provides comprehensive information about price movements and trading activity across markets. It includes detailed data about opening, high, low, and closing prices, along with trading volumes across different timeframes.

This dataset helps users:

  • Track price movements and trading ranges
  • Access standardized price data across multiple intervals
  • Monitor trading volume and market activity patterns
  • Analyze price trends and market momentum
  • Evaluate market volatility and trading intensity across periods

Table Details​

Name: LISTINGS.PUBLIC.OHLCV

Schema​

CREATE OR REPLACE TABLE LISTINGS.PUBLIC.OHLCV (
    time_period_start     TIMESTAMP_NTZ(9),
    time_period_end       TIMESTAMP_NTZ(9),
    time_open             TIMESTAMP_NTZ(9),
    time_close            TIMESTAMP_NTZ(9),
    price_open            NUMBER(38,8),
    price_high            NUMBER(38,8),
    price_low             NUMBER(38,8),
    price_close           NUMBER(38,8),
    volume_traded         NUMBER(38,8),
    trades_count          NUMBER(38,0)
);