AAPL PRICES 2020-2025 - Daily AI Feature Feed

What You Get

• 1,508 trading days from January 2, 2020 to December 31, 2025
• 94 columns (3 metadata + 84 features + 7 forward labels)
• Single CSV file, chronological order
• One row per trading day — clean, ready for ML ingestion

Feature Groups (94 columns)

Why Apple Sentiment Is Different

• iPhone launch cycles — annual product announcements (September) and initial sales data create predictable sentiment waves; our AI tracks the upgrade cycle narrative months in advance
• Services revenue trajectory — App Store, iCloud, Apple TV+, Apple Pay growth narratives shift analyst sentiment independently of hardware cycles
• China sales exposure — geopolitical tensions, Huawei competition, and Chinese consumer sentiment create a persistent risk narrative tracked daily in financial media
• Supply chain disruptions — chip shortages (2020-2022), factory shutdowns, and logistics bottlenecks generate multi-week sentiment cycles captured by our pipeline
• App Store regulation — EU DMA, Epic Games lawsuits, and antitrust actions create regulatory sentiment shocks with direct revenue implications
• Apple Intelligence AI pivot — the 2024-2025 on-device AI strategy creates a new narrative dimension; sentiment captures market reception of AI features vs competitors

Collection Methodology

1. News Collection: GDELT (Global Database of Events, Language, and Tone) provides 100+ Apple-related articles daily from global financial media
2. AI Sentiment Analysis: Google Gemini processes each article batch, scoring overall market sentiment and AAPL-specific sentiment on a -1.0 to +1.0 scale
3. Price Data: Yahoo Finance provides AAPL closing prices, S&P 100 cross-asset data, sector returns, VIX, yields, credit spreads, and options data
4. Feature Engineering: 91 features are computed from raw inputs using numpy — technical indicators, sentiment derivatives, cross-asset correlations, macro signals, and forward labels
5. Quality Control: Automated audit checks coverage, NaN rates, column integrity, and data consistency

Complete Column Reference

# | Column | Type | Group | Description
---|--------|------|-------|------------
1 | date | date | Metadata | Trading date (YYYY-MM-DD)
2 | year | int | Metadata | Calendar year
3 | day_of_week | string | Metadata | Day name (Monday-Friday)
4 | price_close | float | Price Action | Closing price (USD)
5 | price_return_1d | float | Price Action | 1-day return (%)
6 | price_return_3d | float | Price Action | 3-day return (%)
7 | price_return_5d | float | Price Action | 5-day return (%)
8 | price_return_10d | float | Price Action | 10-day return (%)
9 | price_return_20d | float | Price Action | 20-day return (%)
10 | price_log_return_1d | float | Price Action | 1-day log return
11 | price_dist_high_10d | float | Price Action | Distance from 10-day high (%)
12 | price_dist_high_20d | float | Price Action | Distance from 20-day high (%)
13 | price_dist_low_10d | float | Price Action | Distance from 10-day low (%)
14 | price_dist_low_20d | float | Price Action | Distance from 20-day low (%)
15 | tech_rsi_14 | float | Technical | RSI 14-day (0-100, >70 overbought, <30 oversold)
16 | tech_sma_5 | float | Technical | 5-day Simple Moving Average (USD)
17 | tech_sma_20 | float | Technical | 20-day Simple Moving Average (USD)
18 | tech_sma_5_dist | float | Technical | Distance from 5-day SMA (%)
19 | tech_sma_20_dist | float | Technical | Distance from 20-day SMA (%)
20 | tech_ema_20 | float | Technical | 20-day Exponential Moving Average (USD)
21 | tech_ema_20_dist | float | Technical | Distance from 20-day EMA (%)
22 | tech_bollinger_pos | float | Technical | Position within Bollinger Bands (0=lower, 0.5=middle, 1=upper)
23 | tech_bollinger_bw | float | Technical | Bollinger Band width (%)
24 | tech_bollinger_squeeze | float | Technical | Squeeze indicator (1 = bandwidth in bottom 10th percentile, upcoming breakout)
25 | tech_macd | float | Technical | MACD line
26 | tech_macd_signal | float | Technical | MACD signal line
27 | tech_macd_hist | float | Technical | MACD histogram (positive = bullish momentum)
28 | tech_adx | float | Technical | ADX trend strength (>25 trending, <20 ranging)
29 | tech_roc_5 | float | Technical | 5-day Rate of Change (%)
30 | tech_roc_10 | float | Technical | 10-day Rate of Change (%)
31 | tech_roc_20 | float | Technical | 20-day Rate of Change (%)
32 | tech_streak | int | Technical | Consecutive up/down days (positive = up streak)
33 | tech_vol_5d | float | Technical | 5-day realized volatility (annualized %)
34 | tech_vol_10d | float | Technical | 10-day realized volatility (%)
35 | tech_vol_20d | float | Technical | 20-day realized volatility (%)
36 | tech_momentum_quality | float | Technical | Momentum consistency score (ROC adjusted for volatility)
37 | sent_overall | float | AI Sentiment | Overall market sentiment (-1.0 bearish to +1.0 bullish)
38 | sent_aapl | float | AI Sentiment | Apple-specific sentiment (-1.0 bearish to +1.0 bullish)
39 | sent_spread | float | AI Sentiment | Ticker minus overall sentiment (positive = stock more bullish than market)
40 | sent_overall_ma3 | float | AI Sentiment | 3-day MA of overall sentiment
41 | sent_aapl_ma3 | float | AI Sentiment | 3-day MA of aapl sentiment
42 | sent_overall_ma5 | float | AI Sentiment | 5-day MA of overall sentiment
43 | sent_aapl_ma5 | float | AI Sentiment | 5-day MA of aapl sentiment
44 | sent_overall_mom3 | float | AI Sentiment | 3-day overall sentiment momentum
45 | sent_aapl_mom3 | float | AI Sentiment | 3-day aapl sentiment momentum
46 | sent_overall_mom5 | float | AI Sentiment | 5-day overall sentiment momentum
47 | sent_aapl_mom5 | float | AI Sentiment | 5-day aapl sentiment momentum
48 | sent_overall_vol5 | float | AI Sentiment | 5-day overall sentiment volatility
49 | sent_overall_vol10 | float | AI Sentiment | 10-day overall sentiment volatility
50 | sent_aapl_vol5 | float | AI Sentiment | 5-day aapl sentiment volatility
51 | sent_price_corr_10d | float | Sent x Price | 10-day rolling sentiment-price correlation
52 | sent_price_corr_20d | float | Sent x Price | 20-day rolling sentiment-price correlation
53 | sent_price_diverge | float | Sent x Price | Divergence flag (1 when sentiment and price disagree 3+ consecutive days)
54 | news_count | int | News Volume | Articles collected that day
55 | news_count_ma20 | float | News Volume | 20-day article count moving average
56 | news_count_zscore | float | News Volume | Z-score vs 20-day window (>2 = unusual volume)
57 | news_count_mom5 | float | News Volume | 5-day article count momentum
58 | news_spike | float | News Volume | Binary flag for abnormal news volume (count > 2x MA)
59 | mkt_sp100_breadth | float | Cross-Asset | S&P 100 market breadth (% of stocks up, 0-100)
60 | mkt_sp100_return | float | Cross-Asset | S&P 100 equal-weight return (%)
61 | mkt_dispersion | float | Cross-Asset | Cross-sectional return dispersion (%)
62 | mkt_tech_return | float | Cross-Asset | Tech sector return (%)
63 | mkt_finance_return | float | Cross-Asset | Finance sector return (%)
64 | mkt_health_return | float | Cross-Asset | Healthcare sector return (%)
65 | mkt_energy_return | float | Cross-Asset | Energy sector return (%)
66 | mkt_consumer_return | float | Cross-Asset | Consumer sector return (%)
67 | mkt_industrial_return | float | Cross-Asset | Industrial sector return (%)
68 | mkt_aapl_vs_tech | float | Cross-Asset | Apple minus tech sector return (%)
69 | mkt_aapl_vs_market | float | Cross-Asset | Apple minus S&P 100 return (%)
70 | mkt_aapl_beta_20d | float | Cross-Asset | 20-day rolling beta vs S&P 100
71 | vol_of_vol_20d | float | Vol Regime | Volatility of volatility (20-day rolling)
72 | vol_regime | int | Vol Regime | Regime: 0=low, 1=normal, 2=high, 3=extreme
73 | sent_vol_regime_interaction | float | Interaction | Apple sentiment x volatility regime (amplified signal in high-vol periods)
74 | macro_vix | float | Macro | VIX level (CBOE Volatility Index)
75 | macro_vix_change_1d | float | Macro | 1-day VIX percentage change
76 | macro_vix_ma5 | float | Macro | VIX 5-day moving average
77 | macro_yield_spread | float | Macro | 10Y minus short-term Treasury yield spread (%)
78 | macro_credit_spread | float | Macro | High-yield credit spread proxy (LQD/HYG ratio)
79 | macro_dxy_change | float | Macro | US Dollar Index 1-day percentage change (%)
80 | options_iv_atm | float | Options | ATM implied volatility (%) via VIX x beta approximation
81 | options_iv_rv_spread | float | Options | IV minus realized vol (positive = fear premium)
82 | earnings_days_to_next | float | Earnings | Days to next quarterly earnings (0 = earnings day, capped at 90)
83 | earnings_is_earnings_day | float | Earnings | Binary flag: 1 on earnings day, 0 otherwise
84 | attention_wikipedia_views | float | Social Attention | Daily Wikipedia pageviews (1-day lagged)
85 | attention_wikipedia_zscore | float | Social Attention | Wikipedia views z-score (>2 = unusual interest)
86 | attention_google_trends | float | Social Attention | Google Trends index (0-100)
87 | attention_google_trends_change | float | Social Attention | Google Trends change vs prior period
88 | label_return_1d | float | Forward Labels | Next-day return (%)
89 | label_dir_1d | string | Forward Labels | Next-day direction (UP/DOWN/FLAT)
90 | label_return_3d | float | Forward Labels | 3-day forward return (%)
91 | label_dir_3d | string | Forward Labels | 3-day forward direction
92 | label_return_5d | float | Forward Labels | 5-day forward return (%)
93 | label_dir_5d | string | Forward Labels | 5-day forward direction
94 | label_flat_1d | float | Forward Labels | Flat flag (1 if next-day |return| < 0.3%)

Data Quality

• NaN values limited to first ~30 rows (indicator warmup period for rolling windows)
• Last 1-5 rows may have empty forward labels (not yet realized)
• Zero gaps in sentiment coverage — every trading day has article data
• Cross-asset features sourced from Yahoo Finance; occasional NaN on mismatched trading holidays
• Quality rating: 5/5 (automated audit verified)

Known Limitations

• Apple-specific sentiment (sent_aapl) is derived from AI analysis of English-language financial news via GDELT. Non-English sources (critical for China coverage) and social media are not included.
• Options IV (options_iv_atm) is approximated using VIX x AAPL beta, not from actual AAPL options chains. This may understate IV around product launches and earnings.
• iPhone launch cycles create strong seasonal patterns in sentiment — models should incorporate calendar features for optimal performance.
• Earnings dates are pattern-estimated with yfinance confirmation. Accuracy is +/- 3 days for some historical quarters.
• Apple's relatively low volatility vs other mega-caps means the flat zone flag (label_flat_1d) triggers more frequently — approximately 25-30% of trading days.

Use Cases

• ML model training for AAPL price direction and magnitude prediction across 6 years of product and macro cycles
• iPhone cycle analysis: how pre-launch sentiment, supply chain signals, and initial sales coverage predict quarterly revenue surprises
• Regulatory event study: EU DMA, App Store lawsuits, and antitrust actions — sentiment impact vs price recovery
• Cross-asset analysis: AAPL as market bellwether — correlation between Apple sentiment and broad market direction
• China risk modeling using sentiment proxies for geopolitical and competitive threats
• Feature engineering baseline for consumer tech or mega-cap portfolio strategies
• Services revenue narrative tracking — sentiment as leading indicator for subscription and ad revenue growth

Pairs Well With

License

AI Training Rights