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_attimestamp with time zone |
|---|
| vix | US | 1990-01-02 | 17.2400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-03 | 18.1900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-04 | 19.2200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-05 | 20.1100000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-08 | 20.2600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-09 | 22.2000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-10 | 22.4400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-11 | 20.0500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-12 | 24.6400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-15 | 26.3400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-16 | 24.1800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-17 | 24.1600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-18 | 24.3400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-19 | 22.5000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-22 | 26.7000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-23 | 24.7200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-24 | 25.3900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-25 | 25.6300000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-26 | 26.2800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-29 | 26.4400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-30 | 27.2500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-01-31 | 25.3600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-01 | 24.8700000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-02 | 24.3200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-05 | 24.5400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-06 | 24.6900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-07 | 24.2900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-08 | 23.7700000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-09 | 23.6900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-12 | 24.3800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-13 | 23.7600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-14 | 22.0500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-15 | 19.7100000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-16 | 20.7800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-20 | 22.7800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-21 | 23.8900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-22 | 22.5400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-23 | 23.6900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-26 | 23.5600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-27 | 22.6900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-02-28 | 21.9900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-01 | 21.9000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-02 | 21.3400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-05 | 22.0300000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-06 | 20.5500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-07 | 19.1000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-08 | 19.7400000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-09 | 20.3000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-12 | 20.0700000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 1990-03-13 | 21.0500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |