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,000 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-28 |
| 0.0420140047 |
| metric_daily |
| — |
| — |
| 2026-09-15 12:17 |
| 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-27 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-27 | 0.0141640000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-27 | 0.0426993652 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-27 | 0.5196013539 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-27 | -0.3530755023 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-27 | 0.0008340284 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-27 | -11069054.0624671000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-27 | 25.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-27 | 0.1676396997 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | ORCL | 2026-07-27 | -0.0450000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-27 | -31.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-27 | 0.7000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-27 | 0.6550000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-27 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-27 | 122.9932939851 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-27 | 0.4621026292 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-27 | -0.6306564127 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-27 | 5287358406.3801600000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-27 | 119.9000000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | ORCL | 2026-07-27 | 0.1676396997 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-24 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-24 | 0.0589730000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-24 | -0.0420693102 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-24 | 0.4863252621 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-24 | -0.3822529788 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-24 | 0.0435690060 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-24 | -15982720.1783249000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-24 | 28.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-24 | 0.2174971737 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | ORCL | 2026-07-24 | -0.0580000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-24 | -30.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-24 | 0.7200000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-24 | 0.6620000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-24 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-24 | 122.7045992114 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-24 | 1.1405188373 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-24 | -0.6457813252 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-24 | 5343651011.1361700000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-24 | 114.9900000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | ORCL | 2026-07-24 | 0.2174971737 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-23 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-23 | 0.0586610000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-23 | -0.0460902734 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-23 | 0.4894992290 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-23 | -0.3581116958 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-23 | -0.0003332223 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-23 | -34336970.9356562000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-23 | 29.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-23 | 0.2495834722 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |