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.
Simplify Analyticsmetric_daily700,356 rowsrestricted — hover for the licenceas_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_at |
|---|
| vrp_30d | CRWD | 2026-09-24 | -0.3254390000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| ret_1d | CRWD | 2026-09-24 | -0.0107432664 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| realized_vol_21d | CRWD | 2026-09-24 | 0.9961721542 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_50dma | CRWD | 2026-09-24 | 0.2268040166 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_20dma | CRWD | 2026-09-24 | 0.1335613523 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_200dma | CRWD | 2026-09-24 | 0.7369832033 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_slope_30_90 | CRWD | 2026-09-24 | -0.0530000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_regime_days | CRWD | 2026-09-24 | -20.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_90d | CRWD | 2026-09-24 | 0.5960000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_30d | CRWD | 2026-09-24 | 0.5430000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| drawdown_252d | CRWD | 2026-09-24 | -0.0107432664 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| dollar_volume_21d | CRWD | 2026-09-24 | 2967297770.6576200000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| close_adj | CRWD | 2026-09-24 | 259.6700000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| zero_dte_volume_share | CRWD | 2026-09-23 | — | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| vrp_30d | CRWD | 2026-09-23 | -0.3444910000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| ret_1d | CRWD | 2026-09-23 | 0.0497080701 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| realized_vol_21d | CRWD | 2026-09-23 | 1.0040756933 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_50dma | CRWD | 2026-09-23 | 0.2463569379 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_20dma | CRWD | 2026-09-23 | 0.1637774329 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_200dma | CRWD | 2026-09-23 | 0.7636129441 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| put_wall_distance_pct | CRWD | 2026-09-23 | -0.1237761439 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | CRWD | 2026-09-23 | 85053322.5464057000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| max_pain_expiry_dte | CRWD | 2026-09-23 | 23.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| max_pain_distance_pct | CRWD | 2026-09-23 | -0.2571145567 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_slope_30_90 | CRWD | 2026-09-23 | -0.0520000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_regime_days | CRWD | 2026-09-23 | -19.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_90d | CRWD | 2026-09-23 | 0.6120000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_30d | CRWD | 2026-09-23 | 0.5600000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| gamma_flip_state | CRWD | 2026-09-23 | 1.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| gamma_flip_level | CRWD | 2026-09-23 | 224.6155479654 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| gamma_flip_distance_atr | CRWD | 2026-09-23 | -3.0245568966 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| drawdown_252d | CRWD | 2026-09-23 | 0.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| dollar_volume_21d | CRWD | 2026-09-23 | 2937751236.4976200000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| close_adj | CRWD | 2026-09-23 | 262.4900000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| call_wall_distance_pct | CRWD | 2026-09-23 | -0.0475827651 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| zero_dte_volume_share | CRWD | 2026-09-22 | — | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| vrp_30d | CRWD | 2026-09-22 | -0.3184770000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| ret_1d | CRWD | 2026-09-22 | 0.0028474032 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| realized_vol_21d | CRWD | 2026-09-22 | 0.9999875394 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_50dma | CRWD | 2026-09-22 | 0.1932017182 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_20dma | CRWD | 2026-09-22 | 0.1279485959 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| px_vs_200dma | CRWD | 2026-09-22 | 0.6877077544 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| put_wall_distance_pct | CRWD | 2026-09-22 | -0.0802207470 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | CRWD | 2026-09-22 | 67059446.5192702000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| max_pain_expiry_dte | CRWD | 2026-09-22 | 24.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| max_pain_distance_pct | CRWD | 2026-09-22 | -0.2201871551 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_slope_30_90 | CRWD | 2026-09-22 | -0.0610000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_term_regime_days | CRWD | 2026-09-22 | -18.0000000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_90d | CRWD | 2026-09-22 | 0.5880000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| iv_cm_30d | CRWD | 2026-09-22 | 0.5270000000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |