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_daily701,610 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 1,250 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_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|
| ORCL |
| 2026-07-09 |
| -0.0500000000 |
| metric_daily |
| — |
| — |
| 2026-09-15 12:17 |
| 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-09 | -19.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-09 | 0.6510000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-09 | 0.6010000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-09 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-09 | 139.9719895351 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-09 | -0.5486360379 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-09 | -0.5572805641 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-09 | 5663475956.8025400000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-09 | 143.7200000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | ORCL | 2026-07-09 | 0.0054084038 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-08 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-08 | 0.3104640000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-08 | -0.0078389831 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-08 | 0.4433011878 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-08 | -0.2858076910 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-08 | -0.0034877927 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-08 | -14666645.7862774000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-08 | 9.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-08 | 0.1744608157 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | ORCL | 2026-07-08 | -0.0370000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-08 | -18.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-08 | 0.6490000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-08 | 0.6120000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-08 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-08 | 142.9513880117 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-08 | 0.3207617254 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-08 | -0.5687307339 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-08 | 5595587111.0460200000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-08 | 140.0029316322 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | ORCL | 2026-07-08 | 0.0676916507 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-07 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-07 | 0.2327820000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-07 | -0.0150250417 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-07 | 0.5137094405 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-07 | -0.2829681290 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-07 | -0.0112994350 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-07 | -19215695.8562931000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-07 | 10.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-07 | 0.2005649718 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | ORCL | 2026-07-07 | -0.0520000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-07 | -17.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-07 | 0.6610000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-07 | 0.6090000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-07 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-07 | 145.2331654331 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-07 | 0.4590849412 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-07 | -0.5653233107 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-07 | 5659127339.4568300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-07 | 141.1090833449 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |