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_daily719,554 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 | XLE | 2026-09-30 | 0.0569670000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| ret_1d | XLE | 2026-09-30 | -0.0006499838 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| realized_vol_21d | XLE | 2026-09-30 | 0.1899648636 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_50dma | XLE | 2026-09-30 | -0.0027311888 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_20dma | XLE | 2026-09-30 | -0.0307360781 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_200dma | XLE | 2026-09-30 | 0.1043429046 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_term_slope_30_90 | XLE | 2026-09-30 | -0.0070000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_term_regime_days | XLE | 2026-09-30 | -1.0000000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_cm_90d | XLE | 2026-09-30 | 0.2660000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_cm_30d | XLE | 2026-09-30 | 0.2590000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| drawdown_252d | XLE | 2026-09-30 | -0.0616438020 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| dollar_volume_21d | XLE | 2026-09-30 | 2102119779.6211800000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| close_adj | XLE | 2026-09-30 | 61.5000000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| zero_dte_volume_share | XLE | 2026-09-29 | — | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| vrp_30d | XLE | 2026-09-29 | 0.0288600000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| rr_25d | XLE | 2026-09-29 | 0.0440090824 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| rr_10d | XLE | 2026-09-29 | 0.0852446637 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| ret_1d | XLE | 2026-09-29 | -0.0090177134 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| realized_vol_21d | XLE | 2026-09-29 | 0.2046317507 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_50dma | XLE | 2026-09-29 | -0.0009985095 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_20dma | XLE | 2026-09-29 | -0.0323071777 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_200dma | XLE | 2026-09-29 | 0.1067319615 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| put_wall_distance_pct | XLE | 2026-09-29 | -0.0250243744 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| net_gex | XLE | 2026-09-29 | -135630551.0180090000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| max_pain_expiry_dte | XLE | 2026-09-29 | 17.0000000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| max_pain_distance_pct | XLE | 2026-09-29 | 0.0237244069 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_term_slope_30_90 | XLE | 2026-09-29 | 0.0050000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_term_regime_days | XLE | 2026-09-29 | 2.0000000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_cm_90d | XLE | 2026-09-29 | 0.2620000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| iv_cm_30d | XLE | 2026-09-29 | 0.2670000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| gamma_flip_state | XLE | 2026-09-29 | 1.0000000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| gamma_flip_level | XLE | 2026-09-29 | 63.6834174852 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| gamma_flip_distance_atr | XLE | 2026-09-29 | 1.6401714465 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| drawdown_252d | XLE | 2026-09-29 | -0.0610334890 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| dollar_volume_21d | XLE | 2026-09-29 | 2115803582.1668100000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| close_adj | XLE | 2026-09-29 | 61.5400000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| call_wall_distance_pct | XLE | 2026-09-29 | 0.0562235944 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| zero_dte_volume_share | XLE | 2026-09-28 | — | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| vrp_30d | XLE | 2026-09-28 | 0.0285820000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| rr_25d | XLE | 2026-09-28 | 0.0380344446 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| rr_10d | XLE | 2026-09-28 | 0.0904804092 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| ret_1d | XLE | 2026-09-28 | 0.0009671180 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| realized_vol_21d | XLE | 2026-09-28 | 0.2034712831 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_50dma | XLE | 2026-09-28 | 0.0093842257 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_20dma | XLE | 2026-09-28 | -0.0250664736 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| px_vs_200dma | XLE | 2026-09-28 | 0.1184765493 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| put_wall_distance_pct | XLE | 2026-09-28 | -0.0338164251 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| net_gex | XLE | 2026-09-28 | -78816418.7850511000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| max_pain_expiry_dte | XLE | 2026-09-28 | 18.0000000000 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |
| max_pain_distance_pct | XLE | 2026-09-28 | 0.0144927536 | metric_daily | — | — | 2026-09-30 18:30 | 2026-09-30 18:30 |