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_attimestamp with time zone |
|---|
| vrp_30d | STX | 2025-10-10 | -0.1862190000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-13 | -0.1401820000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-14 | -0.1058340000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-15 | -0.1285850000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-16 | -0.1392240000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-17 | -0.1416740000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-20 | -0.1192030000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-21 | -0.0836100000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-22 | -0.0878510000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-23 | -0.1215770000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-24 | -0.1301730000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-27 | -0.0840780000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-28 | -0.0420000000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-29 | -0.2285570000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-30 | -0.1804770000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-10-31 | -0.2021950000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-03 | -0.2003800000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-04 | -0.2128020000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-05 | -0.2436220000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-06 | -0.2483920000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-07 | -0.2140560000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-10 | -0.2166880000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-11 | -0.2138560000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-12 | -0.2119950000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-13 | -0.2146580000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-14 | -0.2412290000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-17 | -0.2208080000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-18 | -0.2138270000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-19 | -0.2244400000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-20 | -0.2599530000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-21 | -0.2352150000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-24 | -0.2659220000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-25 | -0.2621860000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-26 | -0.3128460000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-11-28 | -0.1138960000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-01 | -0.1177970000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-02 | -0.0731990000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-03 | -0.0870180000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-04 | -0.0212390000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-05 | 0.0678240000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-08 | 0.0442850000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-09 | 0.0473240000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-10 | 0.0288040000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-11 | 0.0212860000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-12 | 0.0121860000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-15 | 0.0609470000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-16 | 0.1025830000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-17 | 0.0785150000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-18 | 0.0879670000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | STX | 2025-12-19 | 0.0942790000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |