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.

696,350 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 = CRSR×

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_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
vrp_30dCRSR2026-09-180.0133680000metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dCRSR2026-09-18-0.0096225019metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dCRSR2026-09-180.5615186107metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaCRSR2026-09-180.6909044380metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90CRSR2026-09-18-0.0760000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysCRSR2026-09-18-30.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dCRSR2026-09-180.6580000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dCRSR2026-09-180.5820000000metric_daily2026-09-18 18:302026-09-18 18:30
drawdown_252dCRSR2026-09-18-0.0675958188metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dCRSR2026-09-1814832332.6738095000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjCRSR2026-09-1813.3800000000metric_daily2026-09-18 18:302026-09-18 18:30
zero_dte_volume_shareCRSR2026-09-17metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dCRSR2026-09-170.1166930000metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dCRSR2026-09-170.0265957447metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dCRSR2026-09-170.5927136363metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaCRSR2026-09-170.7150274360metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctCRSR2026-09-17-0.0747594375metric_daily2026-09-18 18:302026-09-18 18:30
net_gexCRSR2026-09-17359204.8642038290metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteCRSR2026-09-1729.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctCRSR2026-09-17-0.0747594375metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90CRSR2026-09-17-0.0540000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysCRSR2026-09-17-29.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dCRSR2026-09-170.6840000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dCRSR2026-09-170.6300000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_stateCRSR2026-09-170.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_levelCRSR2026-09-17metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrCRSR2026-09-17metric_daily2026-09-18 18:302026-09-18 18:30
drawdown_252dCRSR2026-09-17-0.0585365854metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dCRSR2026-09-1714831995.2733333000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjCRSR2026-09-1713.5100000000metric_daily2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctCRSR2026-09-170.1102886751metric_daily2026-09-18 18:302026-09-18 18:30
zero_dte_volume_shareCRSR2026-09-16metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dCRSR2026-09-160.0934740000metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dCRSR2026-09-16-0.0149700599metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dCRSR2026-09-160.5979038370metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaCRSR2026-09-160.6780416896metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctCRSR2026-09-16-0.0501519757metric_daily2026-09-18 18:302026-09-18 18:30
net_gexCRSR2026-09-16337426.4073168670metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteCRSR2026-09-1630.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctCRSR2026-09-16-0.0501519757metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90CRSR2026-09-16-0.1090000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysCRSR2026-09-16-28.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dCRSR2026-09-160.6730000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dCRSR2026-09-160.5640000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_stateCRSR2026-09-160.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_levelCRSR2026-09-16metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrCRSR2026-09-16metric_daily2026-09-18 18:302026-09-18 18:30
drawdown_252dCRSR2026-09-16-0.0829268293metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dCRSR2026-09-1615235316.5838095000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjCRSR2026-09-1613.1600000000metric_daily2026-09-18 18:302026-09-18 18:30