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_daily698,194 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 |
|---|---|---|---|---|---|---|---|---|
| drawdown_252d |
| XOM |
| 2016-09-01 |
| -0.0792626746 |
| metric_daily |
| — |
| — |
| 2026-09-09 11:17 |
| 2026-09-09 11:17 |
| drawdown_252d | XLY | 2016-09-01 | -0.0175267770 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLV | 2016-09-01 | -0.0410940803 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLU | 2016-09-01 | -0.0755001888 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLP | 2016-09-01 | -0.0235146293 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLK | 2016-09-01 | -0.0042247571 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLI | 2016-09-01 | -0.0074475288 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-01 | -0.0040716612 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLE | 2016-09-01 | -0.0378873239 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | WDC | 2016-09-01 | -0.4449213127 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | STX | 2016-09-01 | -0.2801712120 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-01 | -0.0077593547 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SOXX | 2016-09-01 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SMH | 2016-09-01 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | QQQ | 2016-09-01 | -0.0081563297 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-01 | -0.2732251731 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | ORCL | 2016-09-01 | -0.0146037826 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | NVDA | 2016-09-01 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MU | 2016-09-01 | -0.1315240084 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MSFT | 2016-09-01 | -0.0099707753 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MRVL | 2016-09-01 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | META | 2016-09-01 | -0.0029239766 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | LMT | 2016-09-01 | -0.0796753174 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | IWM | 2016-09-01 | -0.0061250806 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | INTC | 2016-09-01 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | GOOG | 2016-09-01 | -0.0204752500 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | DIA | 2016-09-01 | -0.0094862599 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | DE | 2016-09-01 | -0.0515381996 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-01 | -0.0350669352 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AVGO | 2016-09-01 | -0.0017474634 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AMZN | 2016-09-01 | -0.0025111318 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AMD | 2016-09-01 | -0.0417209909 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AAPL | 2016-09-01 | -0.1106144249 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XOM | 2016-09-02 | -0.0731131162 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLY | 2016-09-02 | -0.0155793574 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLV | 2016-09-02 | -0.0400369979 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLU | 2016-09-02 | -0.0632314081 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLP | 2016-09-02 | -0.0159755879 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLK | 2016-09-02 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLI | 2016-09-02 | -0.0025389303 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-02 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLE | 2016-09-02 | -0.0270422535 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | WDC | 2016-09-02 | -0.4371319961 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | STX | 2016-09-02 | -0.2756869626 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-02 | -0.0032863253 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SOXX | 2016-09-02 | -0.0010021866 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SMH | 2016-09-02 | -0.0008979348 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | QQQ | 2016-09-02 | -0.0049277825 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-02 | -0.2498708277 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | ORCL | 2016-09-02 | -0.0124491262 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |