SQLite Coverage Across Share, Financial, Price, and Event Data
| Table | Rows | Distinct Entities | Date Range |
|---|---|---|---|
market_share |
36 | 9 companies, 3 markets, 4 segments | 2024-12-31 to 2025-12-31 |
vendor_metrics |
2,869 | Vendor-period-metric observations | SEC-driven fundamentals timeline |
prices |
106,413 | 14 tickers | 1972-01-07 to 2026-02-05 |
events |
10 | 6 companies | 2024-01-25 to 2025-05-02 |
| Column | Type | Description |
|---|---|---|
metric_date | TEXT | Snapshot date (e.g., 2025-12-31) |
market | TEXT | CPU, GPU, Foundry |
segment | TEXT | Client, DataCenter, Discrete, Wafer |
company | TEXT | Vendor label (e.g., NVIDIA, AMD) |
share_pct | REAL | Market share percentage |
source | TEXT | Source family for the observation |
| Column | Type | Description |
|---|---|---|
metric_date | TEXT | Period end date |
period | TEXT | Reporting period (quarter/annual) |
company | TEXT | Vendor name |
ticker | TEXT | Trading symbol |
metric_name | TEXT | Revenue, GrossProfit, OperatingIncomeLoss, NetIncomeLoss |
metric_value | REAL | Reported numeric metric value |
| Table | Key Fields | Purpose |
|---|---|---|
prices |
trade_date, ticker, OHLCV |
Price trend, relative performance, event windows |
events |
event_date, company, event_type, title |
Catalyst-aware analysis and SOP note generation |
scripts/pull_sec_companyfacts.py pulls company facts and normalizes vendor metrics.
scripts/pull_stooq_prices.py loads daily price history for benchmark and vendor tickers.
scripts/sources/normalize_authoritative_sources.sh maps source snapshots into data/manual/*_market_share.csv.
scripts/init_db.py creates and refreshes SQLite tables via idempotent inserts.