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_daily720,552 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 50 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 |
|---|
| vrp_30d | STX | 2026-10-01 | 0.1391730000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | STX | 2026-10-01 | 0.0251859401 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | STX | 2026-10-01 | 0.5295840183 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | STX | 2026-10-01 | 0.1054046974 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | STX | 2026-10-01 | 0.0874693057 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | STX | 2026-10-01 | 0.4616823267 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | STX | 2026-10-01 | 0.0510000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | STX | 2026-10-01 | 4.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | STX | 2026-10-01 | 0.6620000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | STX | 2026-10-01 | 0.7130000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| drawdown_252d | STX | 2026-10-01 | -0.1343984313 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| dollar_volume_21d | STX | 2026-10-01 | 3151449742.8959200000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| close_adj | STX | 2026-10-01 | 945.5700000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| zero_dte_volume_share | STX | 2026-09-30 | — | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| vrp_30d | STX | 2026-09-30 | 0.1444240000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | STX | 2026-09-30 | 0.0097323335 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | STX | 2026-09-30 | 0.5306325118 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | STX | 2026-09-30 | 0.0792118319 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | STX | 2026-09-30 | 0.0692181616 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | STX | 2026-09-30 | 0.4330790753 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| put_wall_distance_pct | STX | 2026-09-30 | -0.0459049808 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| net_gex | STX | 2026-09-30 | 28652352.2250609000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_expiry_dte | STX | 2026-09-30 | 16.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_distance_pct | STX | 2026-09-30 | -0.0974044279 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | STX | 2026-09-30 | 0.0650000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | STX | 2026-09-30 | 3.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | STX | 2026-09-30 | 0.6830000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | STX | 2026-09-30 | 0.7480000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_state | STX | 2026-09-30 | 1.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_level | STX | 2026-09-30 | 887.4261784137 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_distance_atr | STX | 2026-09-30 | -0.7567300560 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| drawdown_252d | STX | 2026-09-30 | -0.1556638314 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| dollar_volume_21d | STX | 2026-09-30 | 3134802109.5910200000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| close_adj | STX | 2026-09-30 | 922.3400000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| call_wall_distance_pct | STX | 2026-09-30 | 0.0841988854 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| zero_dte_volume_share | STX | 2026-09-29 | — | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| vrp_30d | STX | 2026-09-29 | 0.1362880000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | STX | 2026-09-29 | -0.0087465139 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | STX | 2026-09-29 | 0.5310070415 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | STX | 2026-09-29 | 0.0695913685 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | STX | 2026-09-29 | 0.0654806542 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | STX | 2026-09-29 | 0.4260942274 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| put_wall_distance_pct | STX | 2026-09-29 | -0.0366194099 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| net_gex | STX | 2026-09-29 | 24088136.3326576000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_expiry_dte | STX | 2026-09-29 | 17.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_distance_pct | STX | 2026-09-29 | -0.0968306968 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | STX | 2026-09-29 | 0.0490000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | STX | 2026-09-29 | 2.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | STX | 2026-09-29 | 0.6780000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | STX | 2026-09-29 | 0.7270000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |