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 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 |
|---|---|---|---|---|---|---|---|---|
| sector_dispersion_21d | US | 2026-09-18 | 0.0371834875 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-18 | 0.0491649542 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-18 | 0.5000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-18 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_code | US | 2026-09-18 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-17 | 87.7200000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-17 | 13.3900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix3m | US | 2026-09-17 | 18.5500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-17 | 0.8323450135 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-17 | 15.4400000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-17 | 0.0324073816 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-17 | 0.0461423110 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-17 | 0.6250000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-17 | 0.2760000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-17 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_code | US | 2026-09-17 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-17 | 2.7000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-17 | 145.7000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-16 | 95.4100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-16 | 17.4000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix3m | US | 2026-09-16 | 19.7300000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-16 | 0.8976178409 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-16 | 17.7100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| tga | US | 2026-09-16 | 877028.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sofr_effr_spread_bp | US | 2026-09-16 | -1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-16 | 0.0381530339 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-16 | 0.0585537228 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-16 | 0.6250000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-16 | 5.3750000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| reserves | US | 2026-09-16 | 3013794.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-16 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_code | US | 2026-09-16 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_put_call | US | 2026-09-16 | 0.7435390140 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_oi | US | 2026-09-16 | 660579074.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-16 | 2.7000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_3m | US | 2026-09-16 | 0.8700000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_2y | US | 2026-09-16 | 0.2700000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-16 | 145.9500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-15 | 94.9100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-15 | 17.2100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix3m | US | 2026-09-15 | 19.3600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-15 | 0.8884297521 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-15 | 17.2000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sofr_effr_spread_bp | US | 2026-09-15 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-15 | 0.0488427291 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-15 | 0.0517429498 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-15 | 0.6250000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-15 | 0.7000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-15 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_code | US | 2026-09-15 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |