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 = LMT×

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_30dLMT2026-09-180.0288190000metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dLMT2026-09-18-0.0087531826metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dLMT2026-09-180.2233875361metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaLMT2026-09-18-0.0368517701metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90LMT2026-09-18-0.0160000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysLMT2026-09-18-40.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dLMT2026-09-180.2770000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dLMT2026-09-180.2610000000metric_daily2026-09-18 18:302026-09-18 18:30
drawdown_252dLMT2026-09-18-0.2017253668metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dLMT2026-09-18625338907.9097160000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjLMT2026-09-18533.3800000000metric_daily2026-09-18 18:302026-09-18 18:30
zero_dte_volume_shareLMT2026-09-17metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dLMT2026-09-17-0.0020490000metric_daily2026-09-18 18:302026-09-18 18:30
rr_25dLMT2026-09-170.0214479343metric_daily2026-09-18 18:302026-09-18 18:30
rr_10dLMT2026-09-170.0372923713metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dLMT2026-09-170.0015635179metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dLMT2026-09-170.2397605298metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaLMT2026-09-17-0.0274510435metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-17-0.0057425338metric_daily2026-09-18 18:302026-09-18 18:30
net_gexLMT2026-09-176436920.6294096600metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteLMT2026-09-1729.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-170.0035495921metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90LMT2026-09-17-0.0200000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysLMT2026-09-17-39.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dLMT2026-09-170.2890000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dLMT2026-09-170.2690000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_stateLMT2026-09-171.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_levelLMT2026-09-17537.5596958382metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrLMT2026-09-17-0.0412748328metric_daily2026-09-18 18:302026-09-18 18:30
drawdown_252dLMT2026-09-17-0.1946762208metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dLMT2026-09-17581865388.6448450000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjLMT2026-09-17538.0900000000metric_daily2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctLMT2026-09-170.0035495921metric_daily2026-09-18 18:302026-09-18 18:30
zero_dte_volume_shareLMT2026-09-16metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dLMT2026-09-16-0.0105130000metric_daily2026-09-18 18:302026-09-18 18:30
rr_25dLMT2026-09-160.0244838803metric_daily2026-09-18 18:302026-09-18 18:30
rr_10dLMT2026-09-160.0127946906metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dLMT2026-09-160.0071045627metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dLMT2026-09-160.2578080686metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaLMT2026-09-16-0.0281633572metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-16-0.0041879944metric_daily2026-09-18 18:302026-09-18 18:30
net_gexLMT2026-09-16-4633998.1019011700metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteLMT2026-09-1630.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-160.0051186598metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90LMT2026-09-16-0.0180000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysLMT2026-09-16-38.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dLMT2026-09-160.2740000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dLMT2026-09-160.2560000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_stateLMT2026-09-16-1.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_levelLMT2026-09-16metric_daily2026-09-18 18:302026-09-18 18:30