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_daily723,100 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 | TSM | 2026-10-02 | 0.0379170000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| ret_1d | TSM | 2026-10-02 | 0.0295731707 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| realized_vol_21d | TSM | 2026-10-02 | 0.2657589440 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_50dma | TSM | 2026-10-02 | 0.1148625871 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_20dma | TSM | 2026-10-02 | 0.0727458137 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_200dma | TSM | 2026-10-02 | 0.2266858638 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_term_slope_30_90 | TSM | 2026-10-02 | -0.0240000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_term_regime_days | TSM | 2026-10-02 | -2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_cm_90d | TSM | 2026-10-02 | 0.3440000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_cm_30d | TSM | 2026-10-02 | 0.3200000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| drawdown_252d | TSM | 2026-10-02 | -0.0073730522 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | TSM | 2026-10-02 | 4400954353.6360800000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| close_adj | TSM | 2026-10-02 | 472.7800000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| zero_dte_volume_share | TSM | 2026-10-01 | — | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| vrp_30d | TSM | 2026-10-01 | 0.0597540000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| rr_25d | TSM | 2026-10-01 | -0.0142245499 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| rr_10d | TSM | 2026-10-01 | -0.0085248907 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| ret_1d | TSM | 2026-10-01 | 0.0065981280 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| realized_vol_21d | TSM | 2026-10-01 | 0.2521405768 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_50dma | TSM | 2026-10-01 | 0.0858257462 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_20dma | TSM | 2026-10-01 | 0.0487006528 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_200dma | TSM | 2026-10-01 | 0.1943527653 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| put_wall_distance_pct | TSM | 2026-10-01 | -0.0853658537 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| net_gex | TSM | 2026-10-01 | 372934073.7315860000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| max_pain_expiry_dte | TSM | 2026-10-01 | 15.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| max_pain_distance_pct | TSM | 2026-10-01 | -0.0635888502 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_term_slope_30_90 | TSM | 2026-10-01 | -0.0190000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_term_regime_days | TSM | 2026-10-01 | -1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_cm_90d | TSM | 2026-10-01 | 0.3460000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| iv_cm_30d | TSM | 2026-10-01 | 0.3270000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| gamma_flip_state | TSM | 2026-10-01 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| gamma_flip_level | TSM | 2026-10-01 | 431.6007415286 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| gamma_flip_distance_atr | TSM | 2026-10-01 | -2.7464193059 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| drawdown_252d | TSM | 2026-10-01 | -0.0358849900 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | TSM | 2026-10-01 | 4308710624.8761100000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| close_adj | TSM | 2026-10-01 | 459.2000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| call_wall_distance_pct | TSM | 2026-10-01 | 0.0017421603 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| zero_dte_volume_share | TSM | 2026-09-30 | — | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| vrp_30d | TSM | 2026-09-30 | 0.0613410000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| rr_25d | TSM | 2026-09-30 | -0.0135924085 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| rr_10d | TSM | 2026-09-30 | 0.0103686301 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| ret_1d | TSM | 2026-09-30 | -0.0016413534 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| realized_vol_21d | TSM | 2026-09-30 | 0.2537245075 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_50dma | TSM | 2026-09-30 | 0.0807075387 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_20dma | TSM | 2026-09-30 | 0.0471849924 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| px_vs_200dma | TSM | 2026-09-30 | 0.1891442063 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| put_wall_distance_pct | TSM | 2026-09-30 | -0.0793309805 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| net_gex | TSM | 2026-09-30 | 291459356.1796620000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| max_pain_expiry_dte | TSM | 2026-09-30 | 16.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| max_pain_distance_pct | TSM | 2026-09-30 | -0.0574102896 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |