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_daily717,674 rowsrestricted — hover for the licenceas_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_at |
|---|
| gamma_flip_state | META | 2026-09-18 | 1.0000000000 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| gamma_flip_level | META | 2026-09-18 | 520.2746013757 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| gamma_flip_distance_atr | META | 2026-09-18 | -6.6767624478 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| drawdown_252d | META | 2026-09-18 | -0.1439512778 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| dollar_volume_21d | META | 2026-09-18 | 11261894203.2416000000 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| close_adj | META | 2026-09-18 | 665.2250000000 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| call_wall_distance_pct | META | 2026-09-18 | 0.1265490049 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| zero_dte_volume_share | META | 2026-09-17 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | META | 2026-09-17 | 0.0891180000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | META | 2026-09-17 | -0.0002602170 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | META | 2026-09-17 | 0.0050111608 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | META | 2026-09-17 | 0.0133667998 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | META | 2026-09-17 | 0.2727078164 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | META | 2026-09-17 | 0.1246368843 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | META | 2026-09-17 | 0.1210882431 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | META | 2026-09-17 | 0.0944729661 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | META | 2026-09-17 | -0.0180416526 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | META | 2026-09-17 | 1879166380.8960900000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | META | 2026-09-17 | 29.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | META | 2026-09-17 | -0.1206343158 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | META | 2026-09-17 | -0.0390000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | META | 2026-09-17 | -35.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | META | 2026-09-17 | 0.4120000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | META | 2026-09-17 | 0.3730000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_state | META | 2026-09-17 | 1.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_level | META | 2026-09-17 | 551.2352087714 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_distance_atr | META | 2026-09-17 | -6.2442818722 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | META | 2026-09-17 | -0.1226577489 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | META | 2026-09-17 | 10837596739.3124000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | META | 2026-09-17 | 681.7719410439 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| call_wall_distance_pct | META | 2026-09-17 | 0.0259266316 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | META | 2026-09-16 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | META | 2026-09-16 | 0.0268850000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | META | 2026-09-16 | -0.0099184134 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | META | 2026-09-16 | 0.0057208790 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | META | 2026-09-16 | 0.0045804488 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | META | 2026-09-16 | 0.3332771193 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | META | 2026-09-16 | 0.1127071484 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | META | 2026-09-16 | 0.1188268528 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | META | 2026-09-16 | 0.0803486223 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | META | 2026-09-16 | -0.0346200116 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | META | 2026-09-16 | 1125791172.8284400000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | META | 2026-09-16 | 30.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | META | 2026-09-16 | -0.1163060106 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | META | 2026-09-16 | -0.0310000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | META | 2026-09-16 | -34.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | META | 2026-09-16 | 0.4220000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | META | 2026-09-16 | 0.3910000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_state | META | 2026-09-16 | 1.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_level | META | 2026-09-16 | 588.6857936001 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |