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 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 | AVGO | 2026-09-16 | 1.0634122609 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | AVGO | 2026-09-16 | -0.2938776706 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AVGO | 2026-09-16 | 9228833062.2802400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | AVGO | 2026-09-16 | 339.5100000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | AVGO | 2026-09-16 | 0.0308974699 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | AVGO | 2026-09-15 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AVGO | 2026-09-15 | 0.1488490000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | AVGO | 2026-09-15 | 0.0008153274 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | AVGO | 2026-09-15 | 0.0093538681 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AVGO | 2026-09-15 | -0.0158099327 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | AVGO | 2026-09-15 | 0.3480064312 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AVGO | 2026-09-15 | -0.0807282733 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | AVGO | 2026-09-15 | 0.0316267280 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | AVGO | 2026-09-15 | -221070958.7556410000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | AVGO | 2026-09-15 | 31.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | AVGO | 2026-09-15 | 0.0905768267 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | AVGO | 2026-09-15 | -0.0510000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | AVGO | 2026-09-15 | -8.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | AVGO | 2026-09-15 | 0.4060000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | AVGO | 2026-09-15 | 0.3550000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | AVGO | 2026-09-15 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | AVGO | 2026-09-15 | 354.2160782266 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | AVGO | 2026-09-15 | 1.3459487452 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | AVGO | 2026-09-15 | -0.2943768293 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AVGO | 2026-09-15 | 9234432797.3388100000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | AVGO | 2026-09-15 | 339.2700000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | AVGO | 2026-09-15 | 0.0611017773 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | AVGO | 2026-09-14 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AVGO | 2026-09-14 | 0.0891990000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_25d | AVGO | 2026-09-14 | -0.0008627347 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | AVGO | 2026-09-14 | 0.0234398277 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AVGO | 2026-09-14 | -0.0477085002 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | AVGO | 2026-09-14 | 0.3923037518 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AVGO | 2026-09-14 | -0.0665127585 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | AVGO | 2026-09-14 | 0.0153167788 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | AVGO | 2026-09-14 | -156562328.1834690000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_expiry_dte | AVGO | 2026-09-14 | 32.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| max_pain_distance_pct | AVGO | 2026-09-14 | 0.1023439313 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_slope_30_90 | AVGO | 2026-09-14 | -0.0550000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_term_regime_days | AVGO | 2026-09-14 | -7.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_90d | AVGO | 2026-09-14 | 0.4140000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| iv_cm_30d | AVGO | 2026-09-14 | 0.3590000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_state | AVGO | 2026-09-14 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_level | AVGO | 2026-09-14 | 358.1215189678 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| gamma_flip_distance_atr | AVGO | 2026-09-14 | 1.2200390521 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| drawdown_252d | AVGO | 2026-09-14 | -0.2830417679 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AVGO | 2026-09-14 | 9411887420.2921400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| close_adj | AVGO | 2026-09-14 | 344.7200000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| call_wall_distance_pct | AVGO | 2026-09-14 | 0.0443258297 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| zero_dte_volume_share | AVGO | 2026-09-11 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |