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 250 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_distance_atr | META | 2026-09-16 | -3.9690223721 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | META | 2026-09-16 | -0.1342303190 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | META | 2026-09-16 | 11031373834.5427000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | META | 2026-09-16 | 672.7790383027 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| call_wall_distance_pct | META | 2026-09-16 | 0.0396399875 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | META | 2026-09-15 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | META | 2026-09-15 | -0.0267410000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | META | 2026-09-15 | -0.0016147860 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | META | 2026-09-15 | -0.0057902199 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | META | 2026-09-15 | 0.0069711538 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | META | 2026-09-15 | 0.3660038162 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | META | 2026-09-15 | 0.1097511868 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | META | 2026-09-15 | 0.1258520656 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | META | 2026-09-15 | 0.0757795251 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | META | 2026-09-15 | -0.0301981380 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | META | 2026-09-15 | 1173909083.8550400000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | META | 2026-09-15 | 31.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | META | 2026-09-15 | -0.1197183099 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | META | 2026-09-15 | -0.0350000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | META | 2026-09-15 | -33.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | META | 2026-09-15 | 0.4190000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | META | 2026-09-15 | 0.3840000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_state | META | 2026-09-15 | 1.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_level | META | 2026-09-15 | 594.1807717770 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_distance_atr | META | 2026-09-15 | -3.3816296770 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | META | 2026-09-15 | -0.1381778512 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | META | 2026-09-15 | 10951041944.6999000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | META | 2026-09-15 | 669.7114592565 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| call_wall_distance_pct | META | 2026-09-15 | 0.0444020053 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | META | 2026-09-14 | — | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| vrp_30d | META | 2026-09-14 | -0.0503750000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| rr_25d | META | 2026-09-14 | -0.0161152593 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| rr_10d | META | 2026-09-14 | -0.0196527708 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| ret_1d | META | 2026-09-14 | 0.0271129423 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| realized_vol_21d | META | 2026-09-14 | 0.3696325241 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_50dma | META | 2026-09-14 | 0.1046272530 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_20dma | META | 2026-09-14 | 0.1276491751 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_200dma | META | 2026-09-14 | 0.0686379339 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| put_wall_distance_pct | META | 2026-09-14 | -0.0234375000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | META | 2026-09-14 | 1036638687.4862500000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| max_pain_expiry_dte | META | 2026-09-14 | 32.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| max_pain_distance_pct | META | 2026-09-14 | -0.1210937500 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_slope_30_90 | META | 2026-09-14 | -0.0400000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_regime_days | META | 2026-09-14 | -32.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_90d | META | 2026-09-14 | 0.4200000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_30d | META | 2026-09-14 | 0.3800000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| gamma_flip_state | META | 2026-09-14 | 1.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| gamma_flip_level | META | 2026-09-14 | 583.9634476162 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| gamma_flip_distance_atr | META | 2026-09-14 | -3.7596225922 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| drawdown_252d | META | 2026-09-14 | -0.1441441540 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |