Derived 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
active:entity_id = US×
as_of_date leads no index, so this sort reads every matching row and keeps only the top 200 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 |
|---|---|---|---|---|---|---|---|---|
| vix3m | US | 2026-09-08 | 18.3900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-08 | 0.8548123980 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-08 | 15.7200000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sofr_effr_spread_bp | US | 2026-09-08 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-08 | 0.0561130867 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-08 | 0.0482905726 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-08 | 0.7500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-08 | 0.6260000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-08 | 0.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| regime_code | US | 2026-09-08 | 1.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| occ_equity_put_call | US | 2026-09-08 | 0.7427776852 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_oi | US | 2026-09-08 | 628709868.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-08 | 2.6700000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_3m | US | 2026-09-08 | 0.8600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_2y | US | 2026-09-08 | 0.4100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-08 | 148.8600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-07 | 15.3000000000 | metric_daily | — | — | 2026-09-17 18:30 | 2026-09-17 18:30 |
| sofr_effr_spread_bp | US | 2026-09-07 | — | metric_daily | — | — | 2026-09-17 18:30 | 2026-09-17 18:30 |
| rrp | US | 2026-09-07 | — | metric_daily | — | — | 2026-09-17 18:30 | 2026-09-17 18:30 |
| hy_oas | US | 2026-09-07 | 2.6800000000 | metric_daily | — | — | 2026-09-17 18:30 | 2026-09-17 18:30 |
| curve_10y_3m | US | 2026-09-07 | — | metric_daily | — | — | 2026-09-17 18:30 | 2026-09-17 18:30 |
| curve_10y_2y | US | 2026-09-07 | — | metric_daily | — | — | 2026-09-17 18:30 | 2026-09-17 18:30 |
| vvix | US | 2026-09-04 | 84.4200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix9d | US | 2026-09-04 | 11.9700000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix3m | US | 2026-09-04 | 17.6100000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix_term_ratio | US | 2026-09-04 | 0.8250993754 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 2026-09-04 | 14.5300000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sofr_effr_spread_bp | US | 2026-09-04 | 2.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_dispersion_21d | US | 2026-09-04 | 0.0464675313 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_corr_63d | US | 2026-09-04 | 0.0477310590 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2026-09-04 | 0.7500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| rrp | US | 2026-09-04 | 0.6750000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| regime_flags | US | 2026-09-04 | 0.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| regime_code | US | 2026-09-04 | 1.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| occ_equity_put_call | US | 2026-09-04 | 0.7458891565 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| occ_equity_oi | US | 2026-09-04 | 616764775.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| hy_oas | US | 2026-09-04 | 2.6800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_3m | US | 2026-09-04 | 0.8700000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| curve_10y_2y | US | 2026-09-04 | 0.4100000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| cboe_skew | US | 2026-09-04 | 151.5800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vvix | US | 2026-09-03 | 83.8000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix9d | US | 2026-09-03 | 11.6800000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix3m | US | 2026-09-03 | 17.4200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix_term_ratio | US | 2026-09-03 | 0.8220436280 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| vix | US | 2026-09-03 | 14.3200000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sofr_effr_spread_bp | US | 2026-09-03 | 3.0000000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_dispersion_21d | US | 2026-09-03 | 0.0571106593 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_corr_63d | US | 2026-09-03 | 0.0465946327 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| sector_breadth_200dma | US | 2026-09-03 | 0.7500000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |
| rrp | US | 2026-09-03 | 0.7020000000 | metric_daily | — | — | 2026-09-16 22:44 | 2026-09-16 22:44 |