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.
Simplify Analyticsmetric_daily699,474 rowsrestricted — hover for the licenceas_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_at |
|---|
| vrp_30d | DE | 2026-09-23 | 0.0112070000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| ret_1d | DE | 2026-09-23 | 0.0090453977 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| realized_vol_21d | DE | 2026-09-23 | 0.2946843315 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_50dma | DE | 2026-09-23 | 0.1139333995 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_20dma | DE | 2026-09-23 | 0.0496531756 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_200dma | DE | 2026-09-23 | 0.2257422444 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_slope_30_90 | DE | 2026-09-23 | -0.0270000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_regime_days | DE | 2026-09-23 | -24.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_90d | DE | 2026-09-23 | 0.3280000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_30d | DE | 2026-09-23 | 0.3010000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| drawdown_252d | DE | 2026-09-23 | 0.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| dollar_volume_21d | DE | 2026-09-23 | 891605130.1904760000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| close_adj | DE | 2026-09-23 | 709.4800000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| zero_dte_volume_share | DE | 2026-09-22 | — | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| vrp_30d | DE | 2026-09-22 | 0.0106580000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| ret_1d | DE | 2026-09-22 | 0.0268573014 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| realized_vol_21d | DE | 2026-09-22 | 0.2943259669 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_50dma | DE | 2026-09-22 | 0.1083008124 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_20dma | DE | 2026-09-22 | 0.0463445577 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_200dma | DE | 2026-09-22 | 0.2171806062 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| put_wall_distance_pct | DE | 2026-09-22 | -0.0755489817 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| net_gex | DE | 2026-09-22 | 14818451.0540940000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_expiry_dte | DE | 2026-09-22 | 24.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_distance_pct | DE | 2026-09-22 | -0.0613266583 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_slope_30_90 | DE | 2026-09-22 | -0.0410000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_regime_days | DE | 2026-09-22 | -23.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_90d | DE | 2026-09-22 | 0.3350000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_30d | DE | 2026-09-22 | 0.2940000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| gamma_flip_state | DE | 2026-09-22 | 1.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| gamma_flip_level | DE | 2026-09-22 | 674.9856647746 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| gamma_flip_distance_atr | DE | 2026-09-22 | -1.7849065955 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| drawdown_252d | DE | 2026-09-22 | 0.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| dollar_volume_21d | DE | 2026-09-22 | 875017128.6457140000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| close_adj | DE | 2026-09-22 | 703.1200000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| call_wall_distance_pct | DE | 2026-09-22 | -0.0044373649 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| zero_dte_volume_share | DE | 2026-09-21 | — | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| vrp_30d | DE | 2026-09-21 | -0.0165870000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| ret_1d | DE | 2026-09-21 | 0.0010818872 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| realized_vol_21d | DE | 2026-09-21 | 0.3142465611 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_50dma | DE | 2026-09-21 | 0.0833255546 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_20dma | DE | 2026-09-21 | 0.0231250191 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_200dma | DE | 2026-09-21 | 0.1876645641 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| put_wall_distance_pct | DE | 2026-09-21 | -0.0507207220 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| net_gex | DE | 2026-09-21 | 4627834.8494542400 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_expiry_dte | DE | 2026-09-21 | 25.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_distance_pct | DE | 2026-09-21 | -0.0361164255 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_slope_30_90 | DE | 2026-09-21 | -0.0340000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_regime_days | DE | 2026-09-21 | -22.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_90d | DE | 2026-09-21 | 0.3280000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_30d | DE | 2026-09-21 | 0.2940000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |