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.
metric_daily718,603 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 400 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 |
|---|
| max_pain_expiry_dte | META | 2026-09-08 | 10.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | META | 2026-09-08 | -0.0301232314 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | META | 2026-09-08 | -0.0450000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | META | 2026-09-08 | -28.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | META | 2026-09-08 | 0.4230000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | META | 2026-09-08 | 0.3780000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | META | 2026-09-08 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | META | 2026-09-08 | 565.6427843019 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | META | 2026-09-08 | -2.6674917553 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | META | 2026-09-08 | -0.2111621929 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | META | 2026-09-08 | 9331189378.4500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | META | 2026-09-08 | 613.4800000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | META | 2026-09-08 | -0.0219730065 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | META | 2026-09-04 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | META | 2026-09-04 | 0.0261390000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | META | 2026-09-04 | -0.0132140761 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | META | 2026-09-04 | -0.0126282459 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | META | 2026-09-04 | 0.0099724897 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | META | 2026-09-04 | 0.3195520797 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | META | 2026-09-04 | -0.0077808470 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | META | 2026-09-04 | -0.0271900384 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | META | 2026-09-04 | 642905846.3113830000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | META | 2026-09-04 | 14.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | META | 2026-09-04 | -0.0352967881 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | META | 2026-09-04 | -0.0540000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | META | 2026-09-04 | -27.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | META | 2026-09-04 | 0.4070000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | META | 2026-09-04 | 0.3530000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | META | 2026-09-04 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | META | 2026-09-04 | 563.2083733160 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | META | 2026-09-04 | -2.8646115375 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | META | 2026-09-04 | -0.2069317756 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | META | 2026-09-04 | 9095977303.0728600000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | META | 2026-09-04 | 616.7700000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | META | 2026-09-04 | -0.0271900384 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | META | 2026-09-03 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | META | 2026-09-03 | 0.0513920000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | META | 2026-09-03 | -0.0087676569 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | META | 2026-09-03 | -0.0072905329 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | META | 2026-09-03 | 0.0300750611 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | META | 2026-09-03 | 0.3183369809 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | META | 2026-09-03 | -0.0174490445 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | META | 2026-09-03 | -0.0174887011 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | META | 2026-09-03 | 1001214506.5638000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | META | 2026-09-03 | 15.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | META | 2026-09-03 | -0.0256762953 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | META | 2026-09-03 | -0.0560000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | META | 2026-09-03 | -26.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | META | 2026-09-03 | 0.4030000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | META | 2026-09-03 | 0.3470000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |