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_daily701,610 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 | XLY | 2026-09-25 | 0.0270920000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | XLY | 2026-09-25 | 0.0021754895 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | XLY | 2026-09-25 | 0.1601696290 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | XLY | 2026-09-25 | -0.0352145429 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | XLY | 2026-09-25 | -0.0192789703 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | XLY | 2026-09-25 | -0.0481546602 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | XLY | 2026-09-25 | -0.0070000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | XLY | 2026-09-25 | -37.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | XLY | 2026-09-25 | 0.2110000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | XLY | 2026-09-25 | 0.2040000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | XLY | 2026-09-25 | -0.1065914216 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | XLY | 2026-09-25 | 684591471.3745390000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | XLY | 2026-09-25 | 110.5600000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | XLY | 2026-09-24 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | XLY | 2026-09-24 | 0.0385870000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | XLY | 2026-09-24 | -0.1550757655 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | XLY | 2026-09-24 | -0.0791631924 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | XLY | 2026-09-24 | -0.0029823769 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | XLY | 2026-09-24 | 0.1597822284 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | XLY | 2026-09-24 | -0.0384034267 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | XLY | 2026-09-24 | -0.0236014280 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | XLY | 2026-09-24 | -0.0504853178 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLY | 2026-09-24 | -0.0255620015 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | XLY | 2026-09-24 | -45579012.1328318000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | XLY | 2026-09-24 | 22.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | XLY | 2026-09-24 | 0.0605511240 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | XLY | 2026-09-24 | -0.0200000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | XLY | 2026-09-24 | -36.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | XLY | 2026-09-24 | 0.2150000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | XLY | 2026-09-24 | 0.1950000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_state | XLY | 2026-09-24 | 1.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_level | XLY | 2026-09-24 | 135.1308572154 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_distance_atr | XLY | 2026-09-24 | 15.3368130829 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | XLY | 2026-09-24 | -0.1085308035 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | XLY | 2026-09-24 | 670779731.7781600000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | XLY | 2026-09-24 | 110.3200000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| call_wall_distance_pct | XLY | 2026-09-24 | 0.0877447426 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | XLY | 2026-09-23 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | XLY | 2026-09-23 | 0.0265880000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | XLY | 2026-09-23 | 0.0229319071 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | XLY | 2026-09-23 | 0.0007626291 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | XLY | 2026-09-23 | -0.0149559334 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | XLY | 2026-09-23 | 0.1597823329 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | XLY | 2026-09-23 | -0.0366056943 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | XLY | 2026-09-23 | -0.0235251298 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | XLY | 2026-09-23 | -0.0479906193 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLY | 2026-09-23 | -0.0284681428 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | XLY | 2026-09-23 | -46869493.7549110000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | XLY | 2026-09-23 | 23.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | XLY | 2026-09-23 | 0.0573881609 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |