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_daily717,674 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 850 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_attimestamp with time zone |
|---|
| sector_breadth_200dma | US | 2019-11-06 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-07 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-08 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-11 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-12 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-13 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-14 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-15 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-18 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-19 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-20 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-21 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-22 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-25 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-26 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-27 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-11-29 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-02 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-03 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-04 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-05 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-06 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-09 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-10 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-11 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-12 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-13 | 0.8750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-16 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-17 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-18 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-19 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-20 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-23 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-24 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-26 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-27 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-30 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2019-12-31 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-02 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-03 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-06 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-07 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-08 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-09 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-10 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-13 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-14 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-15 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-16 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2020-01-17 | 1.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |