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_daily719,554 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 | SMH | 2016-09-01 | 0.2117910292 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-02 | 0.2091653035 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-06 | 0.2074817184 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-07 | 0.1981255493 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-08 | 0.1944220449 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-09 | 0.1499900103 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-12 | 0.1723932813 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-13 | 0.1584859913 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-14 | 0.1670480328 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-15 | 0.1947110738 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-16 | 0.1940384636 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-19 | 0.1969036776 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-20 | 0.1911571167 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-21 | 0.2063451348 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-22 | 0.2106985563 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-23 | 0.1952685143 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-26 | 0.1829068168 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-27 | 0.2009203993 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-28 | 0.2009891874 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-29 | 0.2140649799 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-09-30 | 0.2316863295 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-03 | 0.2205030983 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-04 | 0.2137234565 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-05 | 0.2213058456 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-06 | 0.2266304161 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-07 | 0.2257970234 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-10 | 0.2202734186 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-11 | 0.1936833306 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-12 | 0.1922271072 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-13 | 0.1772518292 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-14 | 0.1833874246 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-17 | 0.1770391714 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-18 | 0.1887254367 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-19 | 0.1749508839 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-20 | 0.1834710916 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-21 | 0.1799953426 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-24 | 0.1930164215 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-25 | 0.1877000823 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-26 | 0.1822922430 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-27 | 0.1767751735 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-28 | 0.1681707504 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-10-31 | 0.1742598525 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-01 | 0.1613632110 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-02 | 0.1521647654 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-03 | 0.1454845850 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-04 | 0.1377528399 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-07 | 0.1698808969 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-08 | 0.1699162448 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-09 | 0.1585639994 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | SMH | 2016-11-10 | 0.1351313742 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |