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 = AVGO×
as_of_date leads no index, so this sort reads every matching row and keeps only the top 50 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 |
|---|---|---|---|---|---|---|---|---|
| vrp_30d | AVGO | 2026-09-18 | 0.1680810000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AVGO | 2026-09-18 | 0.0296861503 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | AVGO | 2026-09-18 | 0.3337512759 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AVGO | 2026-09-18 | -0.0292519393 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | AVGO | 2026-09-18 | -0.0600000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | AVGO | 2026-09-18 | -11.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | AVGO | 2026-09-18 | 0.4060000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | AVGO | 2026-09-18 | 0.3460000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | AVGO | 2026-09-18 | -0.2562327878 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AVGO | 2026-09-18 | 9324725773.8997600000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | AVGO | 2026-09-18 | 357.6100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | AVGO | 2026-09-17 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AVGO | 2026-09-17 | 0.1428290000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | AVGO | 2026-09-17 | -0.0194777632 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | AVGO | 2026-09-17 | -0.0497705300 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AVGO | 2026-09-17 | 0.0229448323 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | AVGO | 2026-09-17 | 0.3504216016 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AVGO | 2026-09-17 | -0.0575755330 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | AVGO | 2026-09-17 | 0.0077742586 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | AVGO | 2026-09-17 | -71181695.1346974000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | AVGO | 2026-09-17 | 29.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | AVGO | 2026-09-17 | 0.0653613591 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | AVGO | 2026-09-17 | -0.0570000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | AVGO | 2026-09-17 | -10.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | AVGO | 2026-09-17 | 0.4030000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | AVGO | 2026-09-17 | 0.3460000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | AVGO | 2026-09-17 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | AVGO | 2026-09-17 | 350.0283250652 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | AVGO | 2026-09-17 | 0.2551739242 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | AVGO | 2026-09-17 | -0.2776758122 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AVGO | 2026-09-17 | 9183810948.2088100000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | AVGO | 2026-09-17 | 347.3000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | AVGO | 2026-09-17 | 0.0077742586 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | AVGO | 2026-09-16 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AVGO | 2026-09-16 | 0.1444980000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | AVGO | 2026-09-16 | 0.0033800243 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | AVGO | 2026-09-16 | 0.0255479306 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AVGO | 2026-09-16 | 0.0007074012 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | AVGO | 2026-09-16 | 0.3484952165 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AVGO | 2026-09-16 | -0.0793814690 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | AVGO | 2026-09-16 | 0.0014432565 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | AVGO | 2026-09-16 | -209766569.5766710000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | AVGO | 2026-09-16 | 30.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | AVGO | 2026-09-16 | 0.0898058967 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | AVGO | 2026-09-16 | -0.0550000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | AVGO | 2026-09-16 | -9.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | AVGO | 2026-09-16 | 0.4090000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | AVGO | 2026-09-16 | 0.3540000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | AVGO | 2026-09-16 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | AVGO | 2026-09-16 | 351.2370293688 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |