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_daily699,474 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 | 2016-09-01 | -0.0350669352 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-02 | -0.0322236702 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-06 | -0.0276033645 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-07 | -0.0081743869 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-08 | -0.0103068357 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-09 | -0.0428859140 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-12 | -0.0294988745 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-13 | -0.0495201990 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-14 | -0.0401611184 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-15 | -0.0281957114 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-16 | -0.0279587727 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-19 | -0.0299727520 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-20 | -0.0321052008 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-21 | -0.0111361213 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-22 | -0.0107807132 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-23 | -0.0233384670 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-26 | -0.0241677526 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-27 | -0.0181258145 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-28 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-29 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-30 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-03 | -0.0055198828 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-04 | -0.0141939845 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-05 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-06 | -0.0014538135 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-07 | -0.0106240215 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-10 | -0.0134198166 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-11 | -0.0218072020 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-12 | -0.0205770521 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-13 | -0.0273987922 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-14 | -0.0195705659 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-17 | -0.0238201745 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-18 | -0.0246029971 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-19 | -0.0158801163 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-20 | -0.0226492546 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-21 | -0.0260338237 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-24 | -0.0298696687 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-25 | -0.0469053333 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-26 | -0.0508539973 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-27 | -0.0634897221 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-28 | -0.0536744716 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-10-31 | -0.0584128684 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-01 | -0.0721767828 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-02 | -0.0849253265 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-03 | -0.0831202230 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-04 | -0.0713870500 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-07 | -0.0551411182 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-08 | -0.0446489539 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-09 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-11-10 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |