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_daily717,674 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 1,300 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-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 |
| call_wall_distance_pct | ORCL | 2026-07-07 | 0.0593220339 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-06 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-06 | 0.1985100000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-06 | 0.0248805874 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-06 | 0.5413448674 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-06 | -0.2749208592 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-06 | -0.0261547023 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-06 | -22780353.1040405000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_expiry_dte | ORCL | 2026-07-06 | 11.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| max_pain_distance_pct | ORCL | 2026-07-06 | 0.1825264329 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_slope_30_90 | ORCL | 2026-07-06 | -0.0570000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_term_regime_days | ORCL | 2026-07-06 | -16.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| iv_cm_90d | ORCL | 2026-07-06 | 0.6430000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| iv_cm_30d | ORCL | 2026-07-06 | 0.5860000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| gamma_flip_state | ORCL | 2026-07-06 | 1.0000000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | ORCL | 2026-07-06 | 150.6332351259 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_distance_atr | ORCL | 2026-07-06 | 0.8442666529 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| drawdown_252d | ORCL | 2026-07-06 | -0.5586926493 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | ORCL | 2026-07-06 | 5566203334.3037900000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | ORCL | 2026-07-06 | 143.2615947857 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| call_wall_distance_pct | ORCL | 2026-07-06 | 0.0434056761 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| zero_dte_volume_share | ORCL | 2026-07-02 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| vrp_30d | ORCL | 2026-07-02 | 0.2355630000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| ret_1d | ORCL | 2026-07-02 | -0.0156491228 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| realized_vol_21d | ORCL | 2026-07-02 | 0.5277946920 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| px_vs_200dma | ORCL | 2026-07-02 | -0.2953751071 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| put_wall_distance_pct | ORCL | 2026-07-02 | -0.0019248592 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | ORCL | 2026-07-02 | -37409209.4419552000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |