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 | XLV | 2026-09-25 | 0.0252430000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | XLV | 2026-09-25 | 0.0048860894 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | XLV | 2026-09-25 | 0.1362996116 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | XLV | 2026-09-25 | 0.0213588425 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | XLV | 2026-09-25 | 0.0116342788 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | XLV | 2026-09-25 | 0.1009163848 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | XLV | 2026-09-25 | -0.0030000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | XLV | 2026-09-25 | -9.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | XLV | 2026-09-25 | 0.1710000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | XLV | 2026-09-25 | 0.1680000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | XLV | 2026-09-25 | -0.0246269999 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | XLV | 2026-09-25 | 1254706840.2791700000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | XLV | 2026-09-25 | 170.7000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | XLV | 2026-09-24 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | XLV | 2026-09-24 | 0.0352130000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | XLV | 2026-09-24 | -0.0258029728 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | XLV | 2026-09-24 | 0.0624491357 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | XLV | 2026-09-24 | 0.0063388626 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | XLV | 2026-09-24 | 0.1385171656 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | XLV | 2026-09-24 | 0.0175515293 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | XLV | 2026-09-24 | 0.0066480811 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | XLV | 2026-09-24 | 0.0963326160 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLV | 2026-09-24 | -0.0110084182 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | XLV | 2026-09-24 | 16462455.8206088000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | XLV | 2026-09-24 | 22.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | XLV | 2026-09-24 | -0.0110084182 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | XLV | 2026-09-24 | -0.0120000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | XLV | 2026-09-24 | -8.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | XLV | 2026-09-24 | 0.1790000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | XLV | 2026-09-24 | 0.1670000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_state | XLV | 2026-09-24 | 1.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_level | XLV | 2026-09-24 | 164.8848723360 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_distance_atr | XLV | 2026-09-24 | -2.2069630356 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | XLV | 2026-09-24 | -0.0293695868 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | XLV | 2026-09-24 | 1252750364.5371900000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | XLV | 2026-09-24 | 169.8700000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| call_wall_distance_pct | XLV | 2026-09-24 | -0.0110084182 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | XLV | 2026-09-23 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | XLV | 2026-09-23 | 0.0340510000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | XLV | 2026-09-23 | 0.0106363540 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | XLV | 2026-09-23 | 0.0311875476 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | XLV | 2026-09-23 | -0.0064159162 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | XLV | 2026-09-23 | 0.1368353451 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | XLV | 2026-09-23 | 0.0126201111 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | XLV | 2026-09-23 | -0.0005835173 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | XLV | 2026-09-23 | 0.0900997907 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLV | 2026-09-23 | -0.0047393365 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | XLV | 2026-09-23 | 2048779.1980277500 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | XLV | 2026-09-23 | 23.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | XLV | 2026-09-23 | -0.0047393365 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |