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_daily699,474 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 | SNDK | 2026-09-23 | 0.0456120000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| ret_1d | SNDK | 2026-09-23 | -0.0373442004 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| realized_vol_21d | SNDK | 2026-09-23 | 0.7421224740 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_50dma | SNDK | 2026-09-23 | 0.2056997100 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_20dma | SNDK | 2026-09-23 | 0.1100785473 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_200dma | SNDK | 2026-09-23 | 0.6627275090 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_slope_30_90 | SNDK | 2026-09-23 | -0.0230000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_regime_days | SNDK | 2026-09-23 | -34.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_90d | SNDK | 2026-09-23 | 0.7490000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_30d | SNDK | 2026-09-23 | 0.7260000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| drawdown_252d | SNDK | 2026-09-23 | -0.2220256959 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| dollar_volume_21d | SNDK | 2026-09-23 | 17416581277.2719000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| close_adj | SNDK | 2026-09-23 | 1816.5700000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| zero_dte_volume_share | SNDK | 2026-09-22 | — | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| vrp_30d | SNDK | 2026-09-22 | 0.0324330000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| ret_1d | SNDK | 2026-09-22 | 0.0681519721 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| realized_vol_21d | SNDK | 2026-09-22 | 0.7695907957 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_50dma | SNDK | 2026-09-22 | 0.2534498200 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_20dma | SNDK | 2026-09-22 | 0.1650957194 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_200dma | SNDK | 2026-09-22 | 0.7399965860 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| put_wall_distance_pct | SNDK | 2026-09-22 | -0.0991181957 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| net_gex | SNDK | 2026-09-22 | 258553699.1739550000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_expiry_dte | SNDK | 2026-09-22 | 24.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_distance_pct | SNDK | 2026-09-22 | -0.1468119383 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_slope_30_90 | SNDK | 2026-09-22 | -0.0040000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_regime_days | SNDK | 2026-09-22 | -33.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_90d | SNDK | 2026-09-22 | 0.7720000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_30d | SNDK | 2026-09-22 | 0.7680000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| gamma_flip_state | SNDK | 2026-09-22 | 1.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| gamma_flip_level | SNDK | 2026-09-22 | 1688.0598044285 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| gamma_flip_distance_atr | SNDK | 2026-09-22 | -1.8950347854 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| drawdown_252d | SNDK | 2026-09-22 | -0.1918458244 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| dollar_volume_21d | SNDK | 2026-09-22 | 17751527435.4300000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| close_adj | SNDK | 2026-09-22 | 1887.0400000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| call_wall_distance_pct | SNDK | 2026-09-22 | 0.0598609462 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| zero_dte_volume_share | SNDK | 2026-09-21 | — | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| vrp_30d | SNDK | 2026-09-21 | 0.0435680000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| ret_1d | SNDK | 2026-09-21 | -0.0140527508 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| realized_vol_21d | SNDK | 2026-09-21 | 0.7396502522 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_50dma | SNDK | 2026-09-21 | 0.1768062378 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_20dma | SNDK | 2026-09-21 | 0.1041860586 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| px_vs_200dma | SNDK | 2026-09-21 | 0.6417907223 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| put_wall_distance_pct | SNDK | 2026-09-21 | -0.0377213241 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| net_gex | SNDK | 2026-09-21 | 136605830.5494630000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_expiry_dte | SNDK | 2026-09-21 | 25.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| max_pain_distance_pct | SNDK | 2026-09-21 | -0.0943259521 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_slope_30_90 | SNDK | 2026-09-21 | -0.0190000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_term_regime_days | SNDK | 2026-09-21 | -32.0000000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_90d | SNDK | 2026-09-21 | 0.7410000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |
| iv_cm_30d | SNDK | 2026-09-21 | 0.7220000000 | metric_daily | — | — | 2026-09-23 18:30 | 2026-09-23 18:30 |