Dow Jones Industrial Average Daily (FRED)
- Rows
- 2,610
- Columns
- 2
- Data range
- 2016-11-14 to 2026-11-13
- Auto-refresh
- Re-checks its source daily
- Last refreshed with new data
- 2026-11-14
Daily Dow Jones Industrial Average closing values from 1896 to present, one of the oldest and most widely tracked U.S. equity indices, distributed via FRED.
AI analysis
Dataset Analysis: Dow Jones Industrial Average Daily (FRED)
1. Dataset Overview & Correlation Value This dataset captures the daily closing values of the Dow Jones Industrial Average (DJIA) spanning from 1896 to the present, making it one of the longest continuous financial time series publicly available. Sourced directly from the Federal Reserve Bank of St. Louis Economic Data platform (FRED) via https://fred.stlouisfed.org/graph/fredgraph.csv?id=DJIA, the FRED provenance is a strong signal of institutional reliability and regular maintenance — FRED datasets are typically updated on a near-real-time or daily basis, suggesting the data is likely current through recent trading days. With 2,608 rows representing weekly or sampled daily observations (notably fewer than the ~33,000+ trading days since 1896, implying this may be a weekly or reduced-frequency snapshot rather than full daily granularity), this dataset offers exceptional longitudinal depth for macro-financial correlation studies, regime analysis, and economic cycle research.
2. Data Quality Observations Overall data quality is good but not pristine. The most notable issue is 96 null values in the DJIA column (3.7% of 2,608 rows), which is the dataset's only quality concern since the Date column is fully populated with zero nulls and 2,608 distinct values — confirming no duplicate dates exist. The null DJIA values likely correspond to non-trading days (weekends, federal holidays) that appear in the date index, or potentially to early historical periods where closing values were not recorded or have since been lost. Duplicate row counts are pending recomputation against the Parquet source, but the 1:1 ratio of distinct dates to total rows strongly suggests no duplicate records are present. The 3.7% null rate is manageable and unlikely to materially bias most analyses, though imputation strategy (forward-fill, interpolation, or exclusion) should be deliberate given the time-series nature of the data.
3. Key Column Distributions The DJIA column tells a compelling statistical story. The mean of 31,613.5 and median of 31,516.1 are remarkably close, indicating a relatively symmetric central distribution despite the enormous historical range. The min of 17,140.2 and max of 50,579.7 reflect only the modern era — this is a critical observation suggesting the dataset may be truncated to recent decades rather than the full 1896–present history, since the DJIA traded below 1,000 for most of the 20th century. The interquartile range spans 25,177.8 (Q1) to 36,248.9 (Q3), a relatively tight band suggesting a substantial portion of observations cluster in the post-2017 bull market era. The skewness of 0.358 is mild positive skew, consistent with equity indices that drift upward over time and occasionally spike to new highs. The standard deviation of 8,286.49 (~26% of the mean) reflects meaningful volatility across the sample window.
4. Recommended Join Key Columns The Date column is the unambiguous join key for cross-dataset correlation — it is fully populated (0 nulls), entirely distinct (2,608 unique values), and typed correctly as a Date field. For time-series joins, care should be taken to align on trading-day calendars, as joining to datasets with different temporal frequencies (monthly GDP, weekly unemployment claims) will require aggregation or resampling. A derived Year-Month or Year-Week key would be valuable for joining to lower-frequency economic series without introducing look-ahead bias.
5. Suggested Pairing Datasets for Correlation Analysis Several dataset categories would pair powerfully with this data. Macroeconomic indicators from FRED — such as the Federal Funds Rate, CPI, or Unemployment Rate — would allow exploration of how monetary policy and inflation regimes correlate with equity performance. S&P 500 or NASDAQ Composite daily data would enable inter-index correlation and divergence analysis, particularly useful for identifying sector rotation. Corporate earnings or EPS aggregates (e.g., from Compustat or Bloomberg) could test the relationship between earnings cycles and index levels. VIX (volatility index) data would complement the DJIA to study fear/greed dynamics. Finally, Treasury yield data (10-year, 2-year spreads) would support yield curve vs. equity market correlation studies — a classic macro-finance research pairing that has strong predictive literature behind it.
Columns
- Date (date)
- DJIA (decimal)