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_daily720,552 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 | SOXX | 2025-10-10 | -0.0751800000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-13 | -0.0999960000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-14 | -0.1024590000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-15 | -0.1105210000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-16 | -0.1060560000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-17 | -0.0980870000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-20 | -0.0858400000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-21 | -0.0815190000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-22 | -0.0982850000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-23 | -0.0930290000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-24 | -0.1075130000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-27 | -0.1110960000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-28 | -0.1129620000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-29 | -0.1026730000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-30 | -0.0975330000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-10-31 | -0.0941490000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-03 | -0.0624760000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-04 | -0.0860020000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-05 | -0.0832980000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-06 | -0.0921740000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-07 | -0.0436600000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-10 | 0.0060260000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-11 | 0.0510440000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-12 | 0.0532830000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-13 | 0.0590970000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-14 | 0.0413050000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-17 | 0.0301110000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-18 | 0.0145350000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-19 | -0.0055840000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-20 | -0.0325810000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-21 | -0.0201180000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-24 | -0.0522650000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-25 | -0.0502150000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-26 | -0.0533020000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-11-28 | -0.0451760000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-01 | -0.0590070000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-02 | -0.0653920000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-03 | -0.0549580000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-04 | -0.0573080000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-05 | -0.0252090000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-08 | -0.0023110000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-09 | -0.0076380000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-10 | -0.0052390000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-11 | 0.0153890000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-12 | -0.0018150000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-15 | 0.0301860000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-16 | 0.0315500000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-17 | 0.0399540000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-18 | 0.0190480000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| vrp_30d | SOXX | 2025-12-19 | 0.0410870000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |