Simplify Analytics
← Data Explorer

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.

697,178 rowsexport restricted — no row in this table may be redistributed

Sources in this table

as_of_dateto
column equals (exact text)
sort
chart against as_of_date
reset
active:entity_id = DIA×

as_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_idtextentity_idtextas_of_date ↓datevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
vrp_30dDIA2026-09-210.0106740000metric_daily——2026-09-21 18:302026-09-21 18:30
ret_1dDIA2026-09-210.0075598977metric_daily——2026-09-21 18:302026-09-21 18:30
realized_vol_21dDIA2026-09-210.1123743546metric_daily——2026-09-21 18:302026-09-21 18:30
px_vs_200dmaDIA2026-09-210.0439286863metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_slope_30_90DIA2026-09-21-0.0160000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_regime_daysDIA2026-09-21-37.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_90dDIA2026-09-210.1420000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_30dDIA2026-09-210.1260000000metric_daily——2026-09-21 18:302026-09-21 18:30
drawdown_252dDIA2026-09-21-0.0394236780metric_daily——2026-09-21 18:302026-09-21 18:30
dollar_volume_21dDIA2026-09-211708335764.3719300000metric_daily——2026-09-21 18:302026-09-21 18:30
close_adjDIA2026-09-21519.7800000000metric_daily——2026-09-21 18:302026-09-21 18:30
zero_dte_volume_shareDIA2026-09-18—metric_daily——2026-09-21 18:302026-09-21 18:30
vrp_30dDIA2026-09-180.0116050000metric_daily——2026-09-21 18:302026-09-21 18:30
ret_1dDIA2026-09-18-0.0024703882metric_daily——2026-09-21 18:302026-09-21 18:30
realized_vol_21dDIA2026-09-180.1158017765metric_daily——2026-09-21 18:302026-09-21 18:30
px_vs_200dmaDIA2026-09-180.0366235049metric_daily——2026-09-21 18:302026-09-21 18:30
put_wall_distance_pctDIA2026-09-18-0.0307823525metric_daily——2026-09-21 18:302026-09-21 18:30
net_gexDIA2026-09-18-60616377.1239159000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_expiry_dteDIA2026-09-1828.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_distance_pctDIA2026-09-180.0254322711metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_slope_30_90DIA2026-09-18-0.0180000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_regime_daysDIA2026-09-18-36.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_90dDIA2026-09-180.1440000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_30dDIA2026-09-180.1260000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_stateDIA2026-09-181.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_levelDIA2026-09-18517.4555616841metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_distance_atrDIA2026-09-180.2973820317metric_daily——2026-09-21 18:302026-09-21 18:30
drawdown_252dDIA2026-09-18-0.0466310497metric_daily——2026-09-21 18:302026-09-21 18:30
dollar_volume_21dDIA2026-09-181708456561.7628700000metric_daily——2026-09-21 18:302026-09-21 18:30
close_adjDIA2026-09-18515.8800000000metric_daily——2026-09-21 18:302026-09-21 18:30
call_wall_distance_pctDIA2026-09-180.0176785299metric_daily——2026-09-21 18:302026-09-21 18:30
zero_dte_volume_shareDIA2026-09-17—metric_daily——2026-09-21 18:302026-09-21 18:30
vrp_30dDIA2026-09-170.0044400000metric_daily——2026-09-21 18:302026-09-21 18:30
rr_25dDIA2026-09-170.0704612083metric_daily——2026-09-21 18:302026-09-21 18:30
rr_10dDIA2026-09-170.0760157902metric_daily——2026-09-21 18:302026-09-21 18:30
ret_1dDIA2026-09-170.0060750747metric_daily——2026-09-21 18:302026-09-21 18:30
realized_vol_21dDIA2026-09-170.1165716883metric_daily——2026-09-21 18:302026-09-21 18:30
px_vs_200dmaDIA2026-09-170.0396994050metric_daily——2026-09-21 18:302026-09-21 18:30
put_wall_distance_pctDIA2026-09-170.0031831774metric_daily——2026-09-21 18:302026-09-21 18:30
net_gexDIA2026-09-17-213960360.7524990000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_expiry_dteDIA2026-09-1729.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_distance_pctDIA2026-09-170.0224751616metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_slope_30_90DIA2026-09-17-0.0140000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_regime_daysDIA2026-09-17-35.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_90dDIA2026-09-170.1410000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_30dDIA2026-09-170.1270000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_stateDIA2026-09-171.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_levelDIA2026-09-17519.7278682199metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_distance_atrDIA2026-09-170.2583733603metric_daily——2026-09-21 18:302026-09-21 18:30
drawdown_252dDIA2026-09-17-0.0442700256metric_daily——2026-09-21 18:302026-09-21 18:30