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.
696,350 rowsexport restricted — no row in this table may be redistributed
Sources in this table
metric_daily696,350 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 100 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 |
|---|---|---|---|---|---|---|---|---|
| gamma_flip_distance_atr | META | 2026-09-16 | -3.9690223721 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | META | 2026-09-16 | -0.1342303190 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | META | 2026-09-16 | 11040079868.2352000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | META | 2026-09-16 | 673.3100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | META | 2026-09-16 | 0.0396399875 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | META | 2026-09-15 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | META | 2026-09-15 | -0.0267410000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | META | 2026-09-15 | -0.0016147860 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | META | 2026-09-15 | -0.0057902199 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | META | 2026-09-15 | 0.0069711538 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | META | 2026-09-15 | 0.3660038162 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | META | 2026-09-15 | 0.0757795251 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | META | 2026-09-15 | -0.0301981380 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | META | 2026-09-15 | 1173909083.8550400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | META | 2026-09-15 | 31.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | META | 2026-09-15 | -0.1197183099 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | META | 2026-09-15 | -0.0350000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | META | 2026-09-15 | -33.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | META | 2026-09-15 | 0.4190000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | META | 2026-09-15 | 0.3840000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | META | 2026-09-15 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | META | 2026-09-15 | 594.1807717770 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | META | 2026-09-15 | -3.3816296770 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | META | 2026-09-15 | -0.1381778512 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | META | 2026-09-15 | 10959684579.9300000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | META | 2026-09-15 | 670.2400000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | META | 2026-09-15 | 0.0444020053 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | META | 2026-09-14 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | META | 2026-09-14 | -0.0503750000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | META | 2026-09-14 | -0.0161152593 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | META | 2026-09-14 | -0.0196527708 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | META | 2026-09-14 | 0.0271129423 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | META | 2026-09-14 | 0.3696325241 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | META | 2026-09-14 | 0.0686379339 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | META | 2026-09-14 | -0.0234375000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | META | 2026-09-14 | 1036638687.4862500000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | META | 2026-09-14 | 32.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | META | 2026-09-14 | -0.1210937500 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | META | 2026-09-14 | -0.0400000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | META | 2026-09-14 | -32.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | META | 2026-09-14 | 0.4200000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | META | 2026-09-14 | 0.3800000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | META | 2026-09-14 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | META | 2026-09-14 | 583.9634476162 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | META | 2026-09-14 | -3.7596225922 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | META | 2026-09-14 | -0.1441441540 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | META | 2026-09-14 | 10583223031.4681000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | META | 2026-09-14 | 665.6000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | META | 2026-09-14 | 0.0516826923 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | META | 2026-09-11 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |