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.
696,350 rowsexport restricted — no row in this table may be redistributed
Sources in this table
metric_daily696,350 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 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 |
|---|---|---|---|---|---|---|---|---|
| occ_equity_put_call | US | 2026-09-15 | 0.7446564760 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_oi | US | 2026-09-15 | 653426907.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-15 | 2.7600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_3m | US | 2026-09-15 | 0.8900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_2y | US | 2026-09-15 | 0.3300000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-15 | 146.6100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-14 | 94.8900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-14 | 16.9100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix3m | US | 2026-09-14 | 19.2800000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-14 | 0.8869294606 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-14 | 17.1000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sofr_effr_spread_bp | US | 2026-09-14 | -1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-14 | 0.0415291729 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-14 | 0.0496722193 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-14 | 0.6250000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-14 | 1.4200000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-14 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_code | US | 2026-09-14 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_put_call | US | 2026-09-14 | 0.7448906867 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_oi | US | 2026-09-14 | 643942489.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-14 | 2.7100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_3m | US | 2026-09-14 | 0.8600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_2y | US | 2026-09-14 | 0.3200000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-14 | 152.0900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-11 | 91.2800000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-11 | 14.4700000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix3m | US | 2026-09-11 | 18.6000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-11 | 0.8516129032 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-11 | 15.8400000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sofr_effr_spread_bp | US | 2026-09-11 | -1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-11 | 0.0400770205 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-11 | 0.0544914761 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-11 | 0.7500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-11 | 5.2550000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-11 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_code | US | 2026-09-11 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_put_call | US | 2026-09-11 | 0.7463177875 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_oi | US | 2026-09-11 | 633586048.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-11 | 2.6500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_3m | US | 2026-09-11 | 0.8900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_2y | US | 2026-09-11 | 0.3300000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-11 | 154.4900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-10 | 102.6600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-10 | 17.7000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix3m | US | 2026-09-10 | 19.7300000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-10 | 0.9042067917 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-10 | 17.8400000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sofr_effr_spread_bp | US | 2026-09-10 | -1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-10 | 0.0433075952 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-10 | 0.0584938282 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |