Simplify Analytics
A point-in-time market-data warehouse. 1,772,609 rows across 16 registered tables, collected on a schedule and adjusted at query time rather than in storage.
What is in the store
| Table | Rows | Covers | Last run |
|---|---|---|---|
| corporate_actions Corporate actions | 3,253 | 1964-07-06 … 2026-09-18 | success · 2026-09-18 |
| price_daily Daily bars (unadjusted) | 277,637 | 1962-01-02 … 2026-09-18 | success · 2026-09-18 |
| metric_daily Derived metrics | 696,350 | 1990-01-01 … 2026-09-18 | success · 2026-09-18 |
| earnings_events Earnings events (vintaged) | 2,196 | 1995-07-19 … 2026-12-10 | success · 2026-09-18 |
| economic_calendar Economic calendar snapshots | 104 | 2026-09-14 … 2026-09-19 | success · 2026-09-19 |
| etf_profile ETF fund profile | 126 | 2026-09-08 … 2026-09-18 | success · 2026-09-18 |
| etf_holdings ETF holdings | 16,657 | 2026-09-06 … 2026-09-18 | success · 2026-09-18 |
| etf_weights ETF sector and country weights | 3,511 | 2026-09-08 … 2026-09-18 | success · 2026-09-18 |
| fred_observations FRED / ALFRED vintages | 115,477 | 1939-01-01 … 2026-09-17 | success · 2026-09-18 |
| multileg_trades Multi-leg option trades | 312,778 | 2026-09-04 … 2026-09-18 | success · 2026-09-18 |
| news_headlines News headlines | 55,783 | 2026-07-27 … 2026-09-20 | success · 2026-09-19 |
| occ_open_interest OCC open interest | 527 | 2024-08-13 … 2026-09-17 | success · 2026-09-18 |
| flow_alerts Options flow alerts (market-wide) | 231,528 | 2026-08-14 … 2026-09-18 | success · 2026-09-18 |
| prediction_snapshots Prediction markets (Finance/Politics) | 529 | 2026-09-14 … 2026-09-19 | success · 2026-09-19 |
| borrow_rates Short borrow rates | 44,576 | 2025-10-14 … 2026-09-18 | success · 2026-09-18 |
| trading_sessions XNYS session calendar | 11,577 | 1990-01-02 … 2035-12-31 | success · 2026-09-19 |
Every row count above is an exact count(*), not an estimate. All 16 were taken together at 2026-09-20 01:03 ET — one statement, one transaction, one instant. The page reuses that count for a minute before taking another, so a load just after a collector runs can show the store as it was up to a minute earlier.
“Last run” is the newest row in core.collection_logs, not a health verdict — a lane can have succeeded yesterday and still be overdue today. The worker’s /status decides that, because it reads the declared cadences and the trading calendar.