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
active:entity_id = US×
as_of_date leads no index, so this sort reads every matching row and keeps only the top 150 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_breadth_200dma | US | 2026-09-11 | 0.7500000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| rrp | US | 2026-09-11 | 5.2550000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| regime_flags | US | 2026-09-11 | 0.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| regime_code | US | 2026-09-11 | 1.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| occ_equity_put_call | US | 2026-09-11 | 0.7463177875 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| occ_equity_oi | US | 2026-09-11 | 633586048.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| hy_oas | US | 2026-09-11 | 2.6500000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| curve_10y_3m | US | 2026-09-11 | 0.8900000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| curve_10y_2y | US | 2026-09-11 | 0.3300000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| cboe_skew | US | 2026-09-11 | 154.4900000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 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 |
| sector_breadth_200dma | US | 2026-09-10 | 0.6250000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-10 | 4.7360000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-10 | 0.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| regime_code | US | 2026-09-10 | 1.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| occ_equity_put_call | US | 2026-09-10 | 0.7427678996 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_oi | US | 2026-09-10 | 646473210.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-10 | 2.7000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_3m | US | 2026-09-10 | 0.9500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_2y | US | 2026-09-10 | 0.3900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-10 | 147.0200000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-09 | 94.5000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-09 | 15.5900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix3m | US | 2026-09-09 | 18.8700000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix_term_ratio | US | 2026-09-09 | 0.8722840488 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix | US | 2026-09-09 | 16.4600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| tga | US | 2026-09-09 | 883335.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sofr_effr_spread_bp | US | 2026-09-09 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-09 | 0.0472800762 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-09 | 0.0531170739 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-09 | 0.7500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rrp | US | 2026-09-09 | 0.4320000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| reserves | US | 2026-09-09 | 2991310.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-09 | 0.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| regime_code | US | 2026-09-09 | 1.0000000000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| occ_equity_put_call | US | 2026-09-09 | 0.7438353004 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| occ_equity_oi | US | 2026-09-09 | 636349791.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| hy_oas | US | 2026-09-09 | 2.7100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_3m | US | 2026-09-09 | 0.8800000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| curve_10y_2y | US | 2026-09-09 | 0.4000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| cboe_skew | US | 2026-09-09 | 149.2500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vvix | US | 2026-09-08 | 88.6900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vix9d | US | 2026-09-08 | 14.8100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |