❄ Snowflake
OHLCV Dataset
Access CoinAPI OHLCV data through Snowflake data warehouse
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)
);Example Query
SELECT
time_period_start,
time_period_end,
time_open,
time_close,
price_open,
price_high,
price_low,
price_close,
volume_traded,
trades_count,
FROM OHLCV
WHERE time_period_start IS NOT NULL
AND price_open > 0
AND volume_traded > 0
ORDER BY time_period_start DESC -- Most recent periods first
LIMIT 50;