Bitcoin Historical OHLCV – KuCoin BTC/USDT Daily
- Rows
- 1,861
- Columns
- 9
- Data range
- 2017-10-19 to 2022-11-29
- Auto-refresh
- Re-checks its source daily
Daily Bitcoin BTC/USDT OHLCV data from KuCoin exchange. Historical daily candles with open, high, low, close, volume. Free, Creative Commons licensed.
AI analysis
Bitcoin KuCoin OHLCV Daily – Dataset Analysis
1. Dataset Overview & Value for Correlation Studies
This dataset represents approximately five years of daily Bitcoin price and volume activity (2017-10-19 through 2022-11-29) sourced from the KuCoin BTC/USDT trading pair via [CryptoDataDownload](https://www.cryptodatadownload.com/cdd/KucoinBTCUSDTd.csv), a well-known aggregator of free exchange-level OHLCV data under Creative Commons licensing. The 1,861 daily candles span two full Bitcoin market cycles — the 2017–2018 bull-and-crash and the 2020–2021 all-time-high cycle — making this particularly rich for studying cyclical price behavior, momentum patterns, and macro correlations. Because the data comes directly from KuCoin's API rather than a third-party price index, it reflects real exchange-level liquidity and spread conditions, which adds value when studying market microstructure. The coverage endpoint of late November 2022 is notable: it captures the FTX collapse period, one of the most significant crypto market events in history, giving the dataset strong signal for stress-testing correlations under extreme conditions.
2. Data Quality Observations
Data quality here is excellent by most measures. All 9 columns report zero null cells across 1,861 rows, and the date and unix columns each show 1,861 distinct values, confirming there are no duplicate trading days — a clean, gapless daily series. The symbol column carries a single distinct value (BTC/USDT), making it structurally redundant but harmless as a filter anchor. The OHLC price columns show very high distinct-value counts (1,831–1,861), consistent with continuous decimal pricing and no suspicious rounding artifacts. The one quality flag worth noting is the volume columns: Volume BTC reports 69 flagged outliers and Volume USDT reports 64 flagged outliers, both with extreme right skew (7.56 and 3.37 respectively). These outliers likely correspond to high-volume events around major price dislocations and should be treated as real signal rather than errors, but any correlation or regression model using volume will require log-transformation or winsorization to avoid distortion.
3. Key Column Distributions
The close price column tells the core story of Bitcoin's volatility: a mean of $20,023 versus a median of only $10,768 confirms strong right skew (skew = 1.06), reflecting the long tail of the 2021 bull run where prices exceeded $67,000. The interquartile range of $7,529 (Q1) to $33,101 (Q3) spans a factor of ~4.4×, illustrating how dramatically price regimes shifted across this period. The high-low spread implied by comparing daily high (max $69,028) to daily low (min $3,160) across this period captures both the 2018 bear market floor and the 2021 peak. Volume BTC is the most statistically unusual column: its mean of 4,562 BTC/day is nearly double its median of 2,313 BTC/day, and its skew of 7.56 — far exceeding the price skew — suggests a small number of extremely high-volume days dominate the distribution. Volume USDT tells a complementary story, with a median of ~$24M/day but a mean of ~$134M/day, reflecting how dollar-denominated volume spikes disproportionately during high-price, high-volatility regimes. The near-symmetric unix timestamp distribution (skew = -0.0008) confirms clean temporal coverage with no gaps or clustering.
4. Recommended Join Key Columns
The date column is the primary recommended join key for cross-dataset correlation — it is fully populated, 100% distinct, and formatted as a standard date type, making it immediately usable for time-series alignment with daily-granularity datasets. The unix timestamp column serves as a reliable secondary or fallback join key for systems that prefer epoch time, and its tight statistical symmetry confirms it is well-formed. For any join involving sub-daily data, unix would become the preferred key with appropriate floor/ceiling rounding. Both keys together allow duplicate-safe joins since their 1:1 correspondence with distinct rows is confirmed. Analysts should standardize the date column to UTC when joining with datasets from other exchanges or geographies, as KuCoin candles are denominated in UTC by convention.
5. Suggested Companion Datasets for Correlation Discovery
Several dataset categories would pair powerfully with this data. Macro financial indicators — such as the S&P 500, NASDAQ, or DXY (US Dollar Index) daily closes — would test Bitcoin's evolving correlation with risk assets, a relationship that notably strengthened post-2020. On-chain Bitcoin metrics (e.g., active addresses, hash rate, miner revenue from Glassnode or CoinMetrics) shared on a daily date key would allow investigation of whether network activity leads or lags price. Fear & Greed Index data (available daily from alternative.me) would be a natural behavioral companion for studying momentum and sentiment-driven volume spikes. Stablecoin supply data (USDT, USDC total issuance) could reveal whether liquidity injections into the crypto ecosystem correlate with BTC price pumps. Finally, Google Trends data for the search term "Bitcoin" — also daily-aggregatable — has historically shown strong lagged correlation with retail-driven price rallies and would be an accessible, free pairing for a sentiment-vs-price correlation study.
Columns
- date (date)
- unix (integer)
- symbol (string)
- open (decimal)
- high (decimal)
- low (decimal)
- close (decimal)
- Volume BTC (decimal)
- Volume USDT (decimal)