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.
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 = META×
as_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_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|
| put_wall_distance_pct | META | 2026-09-10 | 0.0087215618 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | META | 2026-09-10 | 904465428.9037980000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | META | 2026-09-10 | 8.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | META | 2026-09-10 | -0.0688724045 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | META | 2026-09-10 | -0.0400000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | META | 2026-09-10 | -30.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | META | 2026-09-10 | 0.4300000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | META | 2026-09-10 | 0.3900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | META | 2026-09-10 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | META | 2026-09-10 | 576.2527561987 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | META | 2026-09-10 | -3.2965209352 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | META | 2026-09-10 | -0.1714297024 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | META | 2026-09-10 | 10257915188.8462000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | META | 2026-09-10 | 644.3800000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | META | 2026-09-10 | 0.0087215618 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | META | 2026-09-09 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | META | 2026-09-09 | -0.0476140000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | META | 2026-09-09 | -0.0269018747 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | META | 2026-09-09 | -0.0525768758 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | META | 2026-09-09 | 0.0655441090 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | META | 2026-09-09 | 0.3892489364 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | META | 2026-09-09 | 0.0509184192 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | META | 2026-09-09 | -0.0821337331 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | META | 2026-09-09 | 1088781780.0885100000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | META | 2026-09-09 | 9.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | META | 2026-09-09 | -0.0897826187 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | META | 2026-09-09 | -0.0370000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | META | 2026-09-09 | -29.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | META | 2026-09-09 | 0.4320000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | META | 2026-09-09 | 0.3950000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | META | 2026-09-09 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | META | 2026-09-09 | 565.9971910669 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | META | 2026-09-09 | -4.4059194641 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | META | 2026-09-09 | -0.1594585216 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | META | 2026-09-09 | 10006931194.6176000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | META | 2026-09-09 | 653.6900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | META | 2026-09-09 | -0.0056448775 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | META | 2026-09-08 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | META | 2026-09-08 | 0.0190970000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | META | 2026-09-08 | -0.0365740607 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | META | 2026-09-08 | -0.0494119285 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | META | 2026-09-08 | -0.0053342413 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | META | 2026-09-08 | 0.3205885581 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | META | 2026-09-08 | -0.0132112217 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | META | 2026-09-08 | -0.0219730065 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | META | 2026-09-08 | 686079606.3369420000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| 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 |