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 450 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-03 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | META | 2026-09-03 | 566.0316385179 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | META | 2026-09-03 | -2.2724480582 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | META | 2026-09-03 | -0.2147625480 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | META | 2026-09-03 | 8958839191.2580900000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | META | 2026-09-03 | 610.6800000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | META | 2026-09-03 | -0.0174887011 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | META | 2026-09-02 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | META | 2026-09-02 | 0.0768440000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | META | 2026-09-02 | -0.0160868363 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | META | 2026-09-02 | -0.0131291613 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | META | 2026-09-02 | 0.0247346769 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | META | 2026-09-02 | 0.3014487016 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | META | 2026-09-02 | -0.0461150521 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | META | 2026-09-02 | -0.0722779793 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | META | 2026-09-02 | 588735459.7185820000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | META | 2026-09-02 | 16.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | META | 2026-09-02 | -0.0048072868 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | META | 2026-09-02 | -0.0540000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | META | 2026-09-02 | -25.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | META | 2026-09-02 | 0.4070000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | META | 2026-09-02 | 0.3530000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | META | 2026-09-02 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | META | 2026-09-02 | 561.3084302632 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | META | 2026-09-02 | -1.6917054256 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | META | 2026-09-02 | -0.2376890951 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | META | 2026-09-02 | 8802549954.4114300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | META | 2026-09-02 | 592.8500000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | META | 2026-09-02 | 0.0120603863 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | META | 2026-09-01 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | META | 2026-09-01 | 0.0954840000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | META | 2026-09-01 | -0.0042028671 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | META | 2026-09-01 | 0.0006019361 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | META | 2026-09-01 | 0.0108327218 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | META | 2026-09-01 | 0.2885710259 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | META | 2026-09-01 | -0.0692553287 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | META | 2026-09-01 | -0.0493310748 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | META | 2026-09-01 | 443961822.6564720000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | META | 2026-09-01 | 17.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | META | 2026-09-01 | 0.0198084834 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | META | 2026-09-01 | -0.0550000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | META | 2026-09-01 | -24.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | META | 2026-09-01 | 0.4080000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | META | 2026-09-01 | 0.3530000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | META | 2026-09-01 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | META | 2026-09-01 | 559.9745527861 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | META | 2026-09-01 | -1.0206896076 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | META | 2026-09-01 | -0.2560894814 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | META | 2026-09-01 | 8838059441.9076200000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | META | 2026-09-01 | 578.5400000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |