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 | SPY | 2016-09-01 | -0.0077593547 | 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 | SPY | 2016-09-06 | -0.0002738464 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-07 | -0.0003651513 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-08 | -0.0026473185 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-09 | -0.0265187690 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-12 | -0.0125519195 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-13 | -0.0267469994 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-14 | -0.0271121553 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-15 | -0.0173901003 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-16 | -0.0211881674 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-19 | -0.0210046304 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-20 | -0.0209587840 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-21 | -0.0099490016 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-22 | -0.0037102126 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-23 | -0.0091691541 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-26 | -0.0171970903 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-27 | -0.0110958497 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-28 | -0.0061873768 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-29 | -0.0151786929 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-30 | -0.0077470718 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-03 | -0.0101325340 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-04 | -0.0151786929 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-05 | -0.0108206153 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-06 | -0.0101325340 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-07 | -0.0135272317 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-10 | -0.0083893021 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-11 | -0.0209129330 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-12 | -0.0196283990 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-13 | -0.0228396285 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-14 | -0.0223350154 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-17 | -0.0257296397 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-18 | -0.0196283990 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-19 | -0.0170136222 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-20 | -0.0188485515 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-21 | -0.0183898536 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-24 | -0.0142153130 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-25 | -0.0175182399 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-26 | -0.0194907864 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-27 | -0.0221056320 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-28 | -0.0249957120 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-10-31 | -0.0249497922 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-01 | -0.0320144127 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-02 | -0.0378403549 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-03 | -0.0422442788 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-04 | -0.0432993606 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-07 | -0.0221973982 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-08 | -0.0177934697 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-09 | -0.0073800712 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-11-10 | -0.0049029116 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |