Derived metrics
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.
696,350 rowsexport restricted — no row in this table may be redistributed
Sources in this table
metric_daily696,350 rowsrestricted — hover for the licence
active:entity_id = ORCL×
as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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 |
|---|---|---|---|---|---|---|---|---|
| gamma_flip_distance_atr | ORCL | 2026-09-16 | 0.0270215504 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | ORCL | 2026-09-16 | -0.5587637065 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | ORCL | 2026-09-16 | 4144379086.9238100000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | ORCL | 2026-09-16 | 143.1600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | ORCL | 2026-09-16 | 0.0477787091 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | ORCL | 2026-09-15 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | ORCL | 2026-09-15 | 0.2062490000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | ORCL | 2026-09-15 | -0.0456789236 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | ORCL | 2026-09-15 | -0.0790100704 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | ORCL | 2026-09-15 | -0.0306651012 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | ORCL | 2026-09-15 | 0.4856731986 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | ORCL | 2026-09-15 | -0.1559196196 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | ORCL | 2026-09-15 | -0.0024937656 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | ORCL | 2026-09-15 | -27285798.7409835000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | ORCL | 2026-09-15 | 31.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | ORCL | 2026-09-15 | 0.1043819024 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | ORCL | 2026-09-15 | -0.0530000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | ORCL | 2026-09-15 | -3.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | ORCL | 2026-09-15 | 0.5510000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | ORCL | 2026-09-15 | 0.4980000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | ORCL | 2026-09-15 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | ORCL | 2026-09-15 | 143.6448770353 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | ORCL | 2026-09-15 | 0.4197295586 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | ORCL | 2026-09-15 | -0.5674244636 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | ORCL | 2026-09-15 | 4056666045.1890500000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | ORCL | 2026-09-15 | 140.3500000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | ORCL | 2026-09-15 | 0.0687566797 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | ORCL | 2026-09-14 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | ORCL | 2026-09-14 | 0.1869670000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | ORCL | 2026-09-14 | -0.0399632399 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | ORCL | 2026-09-14 | -0.0626800821 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | ORCL | 2026-09-14 | -0.0365318073 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | ORCL | 2026-09-14 | 0.4902669975 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | ORCL | 2026-09-14 | -0.1306494827 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | ORCL | 2026-09-14 | -0.0330823952 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | ORCL | 2026-09-14 | -5698968.4284859700 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | ORCL | 2026-09-14 | 32.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | ORCL | 2026-09-14 | 0.0705159196 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | ORCL | 2026-09-14 | -0.0530000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | ORCL | 2026-09-14 | -2.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | ORCL | 2026-09-14 | 0.5470000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | ORCL | 2026-09-14 | 0.4940000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | ORCL | 2026-09-14 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | ORCL | 2026-09-14 | 145.1744835482 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | ORCL | 2026-09-14 | 0.0494172107 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | ORCL | 2026-09-14 | -0.5537398510 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | ORCL | 2026-09-14 | 4006721251.3395200000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | ORCL | 2026-09-14 | 144.7900000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | ORCL | 2026-09-14 | 0.0359831480 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | ORCL | 2026-09-11 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |