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 950 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-30 |
| -0.0490000000 |
| metric_daily |
| — |
| — |
| 2026-09-15 12:17 |
| 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-30 | -34.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-30 | 0.7140000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-30 | 0.6650000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-30 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-30 | 121.1988236519 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-30 | -0.9030722393 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-30 | -0.6070603169 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-30 | 5134585379.0678100000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-30 | 127.5600000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | ORCL | 2026-07-30 | 0.0191282534 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-29 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-29 | 0.0409750000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-29 | -0.0185061687 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-29 | 0.5186376069 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-29 | -0.3588175262 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-29 | 0.0191948361 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-29 | -11112384.0990590000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-29 | 23.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-29 | 0.1890606421 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | ORCL | 2026-07-29 | -0.0370000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-29 | -33.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-29 | 0.7010000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-29 | 0.6640000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-29 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-29 | 120.1110627007 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-29 | 0.3515103278 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-29 | -0.6373101420 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-29 | 5133333106.5452700000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-29 | 117.7400000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | ORCL | 2026-07-29 | 0.0616612876 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-28 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-28 | 0.0374440000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-28 | 0.0005004170 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-28 | 0.5179634933 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-28 | -0.3498504291 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-28 | 0.0003334445 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-28 | -7636781.1492032400 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-28 | 24.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-28 | 0.1670556852 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | ORCL | 2026-07-28 | -0.0490000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-28 | -32.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-28 | 0.7040000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-28 | 0.6550000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-28 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-28 | 121.9648492123 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-28 | 0.2885705623 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-28 | -0.6304715869 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-28 | 5216464910.6994500000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-28 | 119.9600000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |