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 | RSP | 2026-10-01 | 0.0401700000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | RSP | 2026-10-01 | 0.0047110855 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | RSP | 2026-10-01 | 0.0943623283 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | RSP | 2026-10-01 | -0.0325939268 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | RSP | 2026-10-01 | -0.0166721335 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | RSP | 2026-10-01 | 0.0238084173 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | RSP | 2026-10-01 | -0.0130000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | RSP | 2026-10-01 | -1.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | RSP | 2026-10-01 | 0.1460000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | RSP | 2026-10-01 | 0.1330000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| drawdown_252d | RSP | 2026-10-01 | -0.0582855833 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| dollar_volume_21d | RSP | 2026-10-01 | 1446282723.9378400000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| close_adj | RSP | 2026-10-01 | 209.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| zero_dte_volume_share | RSP | 2026-09-30 | — | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| vrp_30d | RSP | 2026-09-30 | 0.0370540000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | RSP | 2026-09-30 | -0.0070644391 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | RSP | 2026-09-30 | 0.0938751623 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | RSP | 2026-09-30 | -0.0373888181 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | RSP | 2026-09-30 | -0.0233005768 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | RSP | 2026-09-30 | 0.0194730328 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| put_wall_distance_pct | RSP | 2026-09-30 | 0.0095183155 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| net_gex | RSP | 2026-09-30 | -81775036.4380544000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_expiry_dte | RSP | 2026-09-30 | 16.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_distance_pct | RSP | 2026-09-30 | 0.0335544659 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | RSP | 2026-09-30 | 0.0030000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | RSP | 2026-09-30 | 1.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | RSP | 2026-09-30 | 0.1430000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | RSP | 2026-09-30 | 0.1460000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_state | RSP | 2026-09-30 | 1.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_level | RSP | 2026-09-30 | 220.3439839252 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_distance_atr | RSP | 2026-09-30 | 6.6186473780 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| drawdown_252d | RSP | 2026-09-30 | -0.0627012777 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| dollar_volume_21d | RSP | 2026-09-30 | 1377935092.8330500000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| close_adj | RSP | 2026-09-30 | 208.0200000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| call_wall_distance_pct | RSP | 2026-09-30 | 0.0335544659 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| zero_dte_volume_share | RSP | 2026-09-29 | — | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| vrp_30d | RSP | 2026-09-29 | 0.0238190000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | RSP | 2026-09-29 | -0.0011442739 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | RSP | 2026-09-29 | 0.0932159417 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | RSP | 2026-09-29 | -0.0308937906 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | RSP | 2026-09-29 | -0.0183692415 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | RSP | 2026-09-29 | 0.0271378717 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| put_wall_distance_pct | RSP | 2026-09-29 | 0.0023866348 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| net_gex | RSP | 2026-09-29 | -95514762.8850329000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_expiry_dte | RSP | 2026-09-29 | 17.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_distance_pct | RSP | 2026-09-29 | 0.0262529833 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | RSP | 2026-09-29 | -0.0020000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | RSP | 2026-09-29 | -3.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | RSP | 2026-09-29 | 0.1450000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | RSP | 2026-09-29 | 0.1430000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |