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 | ORCL | 2026-09-25 | 0.1855030000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | ORCL | 2026-09-25 | -0.0174860255 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | ORCL | 2026-09-25 | 0.5062389861 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | ORCL | 2026-09-25 | -0.0361713436 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | ORCL | 2026-09-25 | -0.0776031137 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | ORCL | 2026-09-25 | -0.1630614684 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | ORCL | 2026-09-25 | -0.0610000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | ORCL | 2026-09-25 | -11.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | ORCL | 2026-09-25 | 0.5540000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | ORCL | 2026-09-25 | 0.4930000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | ORCL | 2026-09-25 | -0.5577558735 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | ORCL | 2026-09-25 | 4774810557.4895200000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | ORCL | 2026-09-25 | 137.1000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | ORCL | 2026-09-24 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | ORCL | 2026-09-24 | 0.1704170000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | ORCL | 2026-09-24 | -0.0564906171 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | ORCL | 2026-09-24 | -0.0885341122 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | ORCL | 2026-09-24 | -0.0347260653 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | ORCL | 2026-09-24 | 0.5150585987 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | ORCL | 2026-09-24 | -0.0172367407 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | ORCL | 2026-09-24 | -0.0658503848 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | ORCL | 2026-09-24 | -0.1502757426 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | ORCL | 2026-09-24 | 0.0032965458 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | ORCL | 2026-09-24 | -64876019.1712738000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | ORCL | 2026-09-24 | 22.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | ORCL | 2026-09-24 | 0.0749605848 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_slope_30_90 | ORCL | 2026-09-24 | -0.0690000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_term_regime_days | ORCL | 2026-09-24 | -10.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_90d | ORCL | 2026-09-24 | 0.5610000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| iv_cm_30d | ORCL | 2026-09-24 | 0.4920000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_state | ORCL | 2026-09-24 | 1.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_level | ORCL | 2026-09-24 | 145.4289768645 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| gamma_flip_distance_atr | ORCL | 2026-09-24 | 0.7526536069 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| drawdown_252d | ORCL | 2026-09-24 | -0.5498851538 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | ORCL | 2026-09-24 | 4757231262.9381000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| close_adj | ORCL | 2026-09-24 | 139.5400000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| call_wall_distance_pct | ORCL | 2026-09-24 | 0.0749605848 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| zero_dte_volume_share | ORCL | 2026-09-23 | — | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| vrp_30d | ORCL | 2026-09-23 | 0.1919980000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_25d | ORCL | 2026-09-23 | -0.0257318811 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | ORCL | 2026-09-23 | -0.0311445856 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| ret_1d | ORCL | 2026-09-23 | -0.0310991957 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| realized_vol_21d | ORCL | 2026-09-23 | 0.5034348954 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_50dma | ORCL | 2026-09-23 | 0.0191305525 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_20dma | ORCL | 2026-09-23 | -0.0352569022 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| px_vs_200dma | ORCL | 2026-09-23 | -0.1217378802 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | ORCL | 2026-09-23 | -0.0315439956 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| net_gex | ORCL | 2026-09-23 | -11385093.6302978000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_expiry_dte | ORCL | 2026-09-23 | 23.0000000000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| max_pain_distance_pct | ORCL | 2026-09-23 | 0.0376314333 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |