core.metric_daily
Derived from the tables above via the registry in app/core/metrics.py. Export is decided per METRIC here, not per source - see core.metric_registry.
Simplify Analyticsmetric_daily701,610 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.
| metric_idtext | entity_idtext | as_of_date ↑date | valuenumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|
| max_pain_expiry_dte | XOM | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLY | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLV | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLU | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLP | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLK | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLI | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLF | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLE | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | WDC | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | STX | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | SPY | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | SPCX | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | SOXX | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | SNDK | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | SMH | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | QQQ | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | PLTR | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | PANW | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | NVDA | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | MU | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | MSFT | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | MRVL | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | META | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | LMT | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | IWM | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | INTC | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | GOOG | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | DIA | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | DELL | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | DE | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | CRWD | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | CRSR | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | CAT | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | AVGO | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | AMZN | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | AMD | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | AAPL | 2026-06-17 | 30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XOM | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLY | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLV | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLU | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLP | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLK | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLI | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLF | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | XLE | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | WDC | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | STX | 2026-06-18 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |