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_at |
|---|
| drawdown_252d | CAT | 2026-09-25 | -0.2270596973 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-24 | -0.2424229183 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-23 | -0.2360537201 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-22 | -0.2398263176 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-21 | -0.2318389479 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-18 | -0.2389043361 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-17 | -0.2487074447 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-16 | -0.2636190830 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-15 | -0.2628476292 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | CAT | 2026-09-14 | -0.2624148624 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| drawdown_252d | CAT | 2026-09-11 | -0.2298914974 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| drawdown_252d | CAT | 2026-09-10 | -0.2426581177 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | CAT | 2026-09-09 | -0.2327232974 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | CAT | 2026-09-08 | -0.2262129796 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | CAT | 2026-09-04 | -0.2342473892 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-09-03 | -0.2472303929 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-09-02 | -0.2546250602 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-09-01 | -0.2669683217 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-31 | -0.2497423218 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-28 | -0.2471269052 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-27 | -0.2313685492 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-26 | -0.2267304182 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-25 | -0.2367405022 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-24 | -0.2369945175 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-21 | -0.2211138579 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-20 | -0.2328832330 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-19 | -0.2321682270 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-18 | -0.2089117160 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-17 | -0.1705459993 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-14 | -0.1941411973 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-13 | -0.1959945681 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-12 | -0.1950537708 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-11 | -0.2065597226 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-10 | -0.2120069394 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-07 | -0.2076698635 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-06 | -0.1937742863 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-05 | -0.1804902275 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-04 | -0.1753534738 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-08-03 | -0.2191099595 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-31 | -0.2334288955 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-30 | -0.2387632165 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-29 | -0.2636284910 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-28 | -0.2089305320 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-27 | -0.1784204733 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-24 | -0.1638851539 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-23 | -0.1584191212 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-22 | -0.1633394914 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-21 | -0.1627185652 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-20 | -0.1868688336 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | CAT | 2026-07-17 | -0.1733683914 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |