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_daily723,600 rowsas_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 |
|---|
| px_vs_200dma | PANW | 2016-09-01 | -0.0395143627 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-02 | -0.0080406240 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-06 | -0.0088422728 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-07 | 0.0079842368 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-08 | 0.0064155740 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-09 | -0.0102463932 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-12 | 0.0097682988 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-13 | 0.0103692355 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-14 | 0.0204120241 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-15 | 0.0228796034 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-16 | 0.0284929095 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-19 | 0.0412439391 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-20 | 0.0379620062 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-21 | 0.0363566405 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-22 | 0.0583060168 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-23 | 0.0504146227 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-26 | 0.0422854599 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-27 | 0.0580164247 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-28 | 0.0776874902 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-29 | 0.0893344263 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-09-30 | 0.1130434540 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-03 | 0.1123927107 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-04 | 0.1200054873 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-05 | 0.1301662994 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-06 | 0.1187905286 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-07 | 0.1218881844 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-10 | 0.1214735435 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-11 | 0.0924573158 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-12 | 0.0844582895 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-13 | 0.0653363101 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-14 | 0.0601941447 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-17 | 0.0296554886 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-18 | 0.0478565384 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-19 | 0.0465664131 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-20 | 0.0499466863 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-21 | 0.0619903355 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-24 | 0.0720330814 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-25 | 0.0603929229 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-26 | 0.0723069042 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-27 | 0.0597256114 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-28 | 0.0737497269 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-10-31 | 0.0896544103 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-01 | 0.0752478733 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-02 | 0.0399073844 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-03 | 0.0312297592 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-04 | 0.0482466128 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-07 | 0.0793991819 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-08 | 0.0827611720 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-09 | 0.1253742814 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | PANW | 2016-11-10 | 0.0745960361 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |