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 | PANW | 2016-09-01 | -0.2732251731 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-02 | -0.2498708277 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-06 | -0.2509558748 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-07 | -0.2387620130 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-08 | -0.2405704247 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-09 | -0.2538493335 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-12 | -0.2396920533 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-13 | -0.2401570735 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-14 | -0.2335951225 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-15 | -0.2327684200 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-16 | -0.2296166167 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-19 | -0.2211429162 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-20 | -0.2246047329 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-21 | -0.2269298336 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-22 | -0.2116358376 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-23 | -0.2186628087 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-26 | -0.2257931177 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-27 | -0.2151493231 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-28 | -0.2014053942 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-29 | -0.1935517206 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-30 | -0.1767593262 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-03 | -0.1780510489 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-04 | -0.1731941717 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-05 | -0.1663222073 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-06 | -0.1753642658 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-07 | -0.1737108608 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-10 | -0.1746409011 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-11 | -0.1966518549 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-12 | -0.2031621370 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-13 | -0.2179394440 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-14 | -0.2224346388 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-17 | -0.2456339775 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-18 | -0.2329234267 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-19 | -0.2344734939 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-20 | -0.2325100754 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-21 | -0.2240880438 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-24 | -0.2170610726 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-25 | -0.2258964555 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-26 | -0.2174744239 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-27 | -0.2267748269 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-28 | -0.2167510592 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-10-31 | -0.2051772243 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-01 | -0.2156143433 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-02 | -0.2413971272 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-03 | -0.2477007337 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-04 | -0.2353001963 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-07 | -0.2124108711 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-08 | -0.2098274259 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-09 | -0.1783610623 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-11-10 | -0.2150976542 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |