Simplify AnalyticsDerived metrics
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.
697,178 rowsexport restricted — no row in this table may be redistributed
Sources in this table
metric_daily697,178 rowsrestricted — hover for the licence
as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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-17 | 24.1600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| tga | US | 1990-01-17 | 4108.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| reserves | US | 1990-01-17 | 34965.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_3m | US | 1990-01-17 | 0.2200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-17 | 0.1000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-17 | 123.0300000000 | 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 |
| curve_10y_3m | US | 1990-01-18 | 0.2800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-18 | 0.0700000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-18 | 131.1400000000 | 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 |
| curve_10y_3m | US | 1990-01-19 | 0.2600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-19 | 0.0600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-19 | 129.3100000000 | 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 |
| curve_10y_3m | US | 1990-01-22 | 0.2800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-22 | 0.0900000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-22 | 118.9500000000 | 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 |
| curve_10y_3m | US | 1990-01-23 | 0.3300000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-23 | 0.0800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-23 | 117.9400000000 | 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 |
| tga | US | 1990-01-24 | 5930.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| reserves | US | 1990-01-24 | 33918.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_3m | US | 1990-01-24 | 0.4500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-24 | 0.1800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-24 | 128.7500000000 | 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 |
| curve_10y_3m | US | 1990-01-25 | 0.4700000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-25 | 0.1800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-25 | 124.3300000000 | 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 |
| curve_10y_3m | US | 1990-01-26 | 0.5600000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-26 | 0.2100000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-26 | 122.7600000000 | 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 |
| curve_10y_3m | US | 1990-01-29 | 0.5000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-29 | 0.2000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-29 | 124.6000000000 | 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 |
| curve_10y_3m | US | 1990-01-30 | 0.5100000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-30 | 0.2100000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-30 | 120.9100000000 | 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 |
| tga | US | 1990-01-31 | 9550.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| reserves | US | 1990-01-31 | 29436.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_3m | US | 1990-01-31 | 0.4300000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 1990-01-31 | 0.1500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 1990-01-31 | 128.2200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |