Derived metrics
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.
696,350 rowsexport restricted — no row in this table may be redistributed
Sources in this table
metric_daily696,350 rowsrestricted — hover for the licence
as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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 | LMT | 2026-07-09 | -0.2291225304 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-07-08 | -0.2146944220 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-07-07 | -0.2036576628 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-07-06 | -0.1997605861 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-07-02 | -0.1879949843 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-07-01 | -0.2238272659 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-30 | -0.2422119483 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-29 | -0.2532040845 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-26 | -0.2452760621 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-25 | -0.2488161546 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-24 | -0.2687180196 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-23 | -0.2508241903 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-22 | -0.2658026493 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-18 | -0.2399956719 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-17 | -0.2082092104 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | LMT | 2026-06-16 | -0.2028098255 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-15 | -0.2111245808 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-12 | -0.1962948652 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-11 | -0.1838747925 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-10 | -0.2190674775 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-09 | -0.2114666905 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-08 | -0.2264302751 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-05 | -0.2209416442 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-04 | -0.2279474577 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-03 | -0.2383892433 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-02 | -0.2363068359 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-06-01 | -0.2317404140 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-29 | -0.2161223585 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-28 | -0.2061327028 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-27 | -0.2151027043 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-26 | -0.2125018472 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-22 | -0.2119994089 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-21 | -0.2274419979 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-20 | -0.2277375499 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-19 | -0.2217674006 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-18 | -0.2192847643 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-15 | -0.2374612088 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-14 | -0.2309590661 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-13 | -0.2316536131 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-12 | -0.2300871878 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-11 | -0.2430175853 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-08 | -0.2514999261 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-07 | -0.2427811438 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-06 | -0.2400472883 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-05 | -0.2479237476 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-04 | -0.2342988030 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-05-01 | -0.2422491503 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-04-30 | -0.2345647998 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-04-29 | -0.2466233190 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| drawdown_252d | LMT | 2026-04-28 | -0.2429584750 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |