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.
metric_daily718,603 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 | XLE | 2026-09-29 | -0.0610334890 | metric_daily | — | — | 2026-09-29 18:30 | 2026-09-29 18:30 |
| drawdown_252d | XLE | 2026-09-28 | -0.0524891074 | metric_daily | — | — | 2026-09-29 18:30 | 2026-09-29 18:30 |
| drawdown_252d | XLE | 2026-09-25 | -0.0534045769 | metric_daily | — | — | 2026-09-29 18:30 | 2026-09-29 18:30 |
| drawdown_252d | XLE | 2026-09-24 | -0.0448601952 | metric_daily | — | — | 2026-09-29 18:30 | 2026-09-29 18:30 |
| drawdown_252d | XLE | 2026-09-23 | -0.0483694948 | metric_daily | — | — | 2026-09-29 18:30 | 2026-09-29 18:30 |
| drawdown_252d | XLE | 2026-09-22 | -0.0573716112 | metric_daily | — | — | 2026-09-29 18:30 | 2026-09-29 18:30 |
| drawdown_252d | XLE | 2026-09-21 | -0.0469962906 | metric_daily | — | — | 2026-09-29 18:30 | 2026-09-29 18:30 |
| drawdown_252d | XLE | 2026-09-18 | -0.0245715152 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| drawdown_252d | XLE | 2026-09-17 | -0.0219930229 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | XLE | 2026-09-16 | -0.0288184438 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | XLE | 2026-09-15 | 0.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | XLE | 2026-09-14 | -0.0119430409 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| drawdown_252d | XLE | 2026-09-11 | -0.0026029704 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| drawdown_252d | XLE | 2026-09-10 | -0.0058184045 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | XLE | 2026-09-09 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | XLE | 2026-09-08 | -0.0050691244 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | XLE | 2026-09-04 | -0.0159754224 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-09-03 | -0.0073732719 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-09-02 | 0.0000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-09-01 | 0.0000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-31 | 0.0000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-28 | -0.0167843137 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-27 | -0.0229019608 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-26 | -0.0207058824 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-25 | -0.0265098039 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-24 | -0.0100392157 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-21 | -0.0017254902 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-20 | 0.0000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-19 | -0.0015703518 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-18 | 0.0000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-17 | 0.0000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-14 | -0.0032555076 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-13 | -0.0169404182 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-12 | -0.0174234151 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-11 | -0.0190334046 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-10 | -0.0311083257 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-07 | -0.0742560440 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-06 | -0.0636301134 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-05 | -0.0773150240 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-04 | -0.0578341512 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-08-03 | -0.0534871796 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-31 | -0.0412512595 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-30 | -0.0507501975 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-29 | -0.0557411649 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-28 | -0.0731290514 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-27 | -0.0604101344 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-24 | -0.0401242669 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-23 | -0.0439882416 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-22 | -0.0468862227 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| drawdown_252d | XLE | 2026-07-21 | -0.0581561491 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |