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 |
|---|
| px_vs_200dma | XLI | 2016-09-01 | 0.0779818699 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-02 | 0.0827432932 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-06 | 0.0791423290 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-07 | 0.0799667193 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-08 | 0.0786206555 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-09 | 0.0478767389 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-12 | 0.0609029322 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-13 | 0.0450361592 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-14 | 0.0438548313 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-15 | 0.0517594313 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-16 | 0.0426743083 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-19 | 0.0469308656 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-20 | 0.0474343949 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-21 | 0.0606361389 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-22 | 0.0676924034 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-23 | 0.0609066003 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-26 | 0.0557900705 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-27 | 0.0625987793 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-28 | 0.0701875617 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-29 | 0.0611413988 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-09-30 | 0.0700182836 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-03 | 0.0703603731 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-04 | 0.0607783581 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-05 | 0.0668302913 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-06 | 0.0661475234 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-07 | 0.0519014740 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-10 | 0.0525178779 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-11 | 0.0411384567 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-12 | 0.0427052929 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-13 | 0.0419487203 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-14 | 0.0436924335 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-17 | 0.0404906504 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-18 | 0.0421335359 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-19 | 0.0448632652 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-20 | 0.0386261034 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-21 | 0.0364571486 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-24 | 0.0376865664 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-25 | 0.0342095060 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-26 | 0.0371070846 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-27 | 0.0292266193 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-28 | 0.0346068076 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-10-31 | 0.0357237196 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-01 | 0.0260304145 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-02 | 0.0213757581 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-03 | 0.0189232784 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-04 | 0.0190344709 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-07 | 0.0431215700 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-08 | 0.0484826209 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-09 | 0.0736159972 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLI | 2016-11-10 | 0.0951822205 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |