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_daily718,603 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 |
|---|
| iv_cm_90d | SPCX | 2026-06-16 | 1.0390000000 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| iv_cm_90d | SPCX | 2026-06-17 | 0.8970000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-18 | 0.8330000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-22 | 0.8650000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-23 | 0.8240000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-24 | 0.7730000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-25 | 0.7270000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-26 | 0.7050000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-29 | 0.7280000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-06-30 | 0.7250000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-01 | 0.7670000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-02 | 0.7830000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-06 | 0.8000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-07 | 0.7750000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-08 | 0.7860000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-09 | 0.7990000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-10 | 0.7850000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-13 | 0.7840000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-14 | 0.7880000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-15 | 0.7760000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-16 | 0.7950000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-17 | 0.7930000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-20 | 0.8000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-21 | 0.8210000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-22 | 0.8670000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-23 | 0.8690000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-24 | 0.8960000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-27 | 0.9060000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-28 | 0.9030000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-29 | 0.8980000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-30 | 0.8910000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-07-31 | 0.8970000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-03 | 0.9140000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-04 | 0.8940000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-05 | 0.8110000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-06 | 0.7840000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-07 | 0.7960000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-10 | 0.7500000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-11 | 0.6880000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-12 | 0.7140000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-13 | 0.6920000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-14 | 0.6650000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-17 | 0.6680000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-18 | 0.6600000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-19 | 0.6500000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-20 | 0.6520000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-21 | 0.6310000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-24 | 0.6160000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-25 | 0.6010000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_90d | SPCX | 2026-08-26 | 0.5880000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |