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_daily720,552 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 | IWM | 2026-10-01 | 0.0568260000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | IWM | 2026-10-01 | 0.0040663572 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | IWM | 2026-10-01 | 0.1149206111 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | IWM | 2026-10-01 | -0.0451594081 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | IWM | 2026-10-01 | -0.0224505155 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | IWM | 2026-10-01 | 0.0147473423 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | IWM | 2026-10-01 | 0.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | IWM | 2026-10-01 | -15.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | IWM | 2026-10-01 | 0.1980000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | IWM | 2026-10-01 | 0.1980000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| drawdown_252d | IWM | 2026-10-01 | -0.0830601959 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| dollar_volume_21d | IWM | 2026-10-01 | 6624827218.4325600000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| close_adj | IWM | 2026-10-01 | 279.0200000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| zero_dte_volume_share | IWM | 2026-09-30 | 0.4276453451 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| vrp_30d | IWM | 2026-09-30 | 0.0635650000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| rr_25d | IWM | 2026-09-30 | 0.0147821412 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| rr_10d | IWM | 2026-09-30 | 0.0239866703 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | IWM | 2026-09-30 | -0.0040141930 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | IWM | 2026-09-30 | 0.1174965091 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | IWM | 2026-09-30 | -0.0499370269 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | IWM | 2026-09-30 | -0.0288292880 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | IWM | 2026-09-30 | 0.0111474875 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| put_wall_distance_pct | IWM | 2026-09-30 | 0.0075929325 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| net_gex | IWM | 2026-09-30 | -4632506890.2029800000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_expiry_dte | IWM | 2026-09-30 | 16.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_distance_pct | IWM | 2026-09-30 | 0.0363813020 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_slope_30_90 | IWM | 2026-09-30 | -0.0010000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_term_regime_days | IWM | 2026-09-30 | -14.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_90d | IWM | 2026-09-30 | 0.1970000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| iv_cm_30d | IWM | 2026-09-30 | 0.1960000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_state | IWM | 2026-09-30 | 1.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_level | IWM | 2026-09-30 | 293.4372934856 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| gamma_flip_distance_atr | IWM | 2026-09-30 | 4.3863541830 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| drawdown_252d | IWM | 2026-09-30 | -0.0867737003 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| dollar_volume_21d | IWM | 2026-09-30 | 6499402484.5283300000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| close_adj | IWM | 2026-09-30 | 277.8900000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| call_wall_distance_pct | IWM | 2026-09-30 | 0.0075929325 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| zero_dte_volume_share | IWM | 2026-09-29 | 0.4982936921 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| vrp_30d | IWM | 2026-09-29 | 0.0419980000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| rr_25d | IWM | 2026-09-29 | 0.0073270465 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| rr_10d | IWM | 2026-09-29 | 0.0238225456 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| ret_1d | IWM | 2026-09-29 | -0.0036068852 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| realized_vol_21d | IWM | 2026-09-29 | 0.1180720696 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_50dma | IWM | 2026-09-29 | -0.0472725138 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_20dma | IWM | 2026-09-29 | -0.0269423405 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| px_vs_200dma | IWM | 2026-09-29 | 0.0156419377 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| put_wall_distance_pct | IWM | 2026-09-29 | 0.0035482599 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| net_gex | IWM | 2026-09-29 | -5048524295.3775400000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_expiry_dte | IWM | 2026-09-29 | 17.0000000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| max_pain_distance_pct | IWM | 2026-09-29 | 0.0358051683 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |