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

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_30dXLF2026-09-210.0110410000metric_daily——2026-09-21 18:302026-09-21 18:30
ret_1dXLF2026-09-210.0042494122metric_daily——2026-09-21 18:302026-09-21 18:30
realized_vol_21dXLF2026-09-210.1311082758metric_daily——2026-09-21 18:302026-09-21 18:30
px_vs_200dmaXLF2026-09-210.0491207551metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_slope_30_90XLF2026-09-21-0.0110000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_regime_daysXLF2026-09-21-37.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_90dXLF2026-09-210.1610000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_30dXLF2026-09-210.1500000000metric_daily——2026-09-21 18:302026-09-21 18:30
drawdown_252dXLF2026-09-21-0.0420530709metric_daily——2026-09-21 18:302026-09-21 18:30
dollar_volume_21dXLF2026-09-211730776294.5507100000metric_daily——2026-09-21 18:302026-09-21 18:30
close_adjXLF2026-09-2155.9000000000metric_daily——2026-09-21 18:302026-09-21 18:30
zero_dte_volume_shareXLF2026-09-18—metric_daily——2026-09-21 18:302026-09-21 18:30
vrp_30dXLF2026-09-180.0079610000metric_daily——2026-09-21 18:302026-09-21 18:30
rr_25dXLF2026-09-180.0725648207metric_daily——2026-09-21 18:302026-09-21 18:30
rr_10dXLF2026-09-180.0601264212metric_daily——2026-09-21 18:302026-09-21 18:30
ret_1dXLF2026-09-18-0.0003579098metric_daily——2026-09-21 18:302026-09-21 18:30
realized_vol_21dXLF2026-09-180.1330094673metric_daily——2026-09-21 18:302026-09-21 18:30
px_vs_200dmaXLF2026-09-180.0450620000metric_daily——2026-09-21 18:302026-09-21 18:30
put_wall_distance_pctXLF2026-09-180.0025062657metric_daily——2026-09-21 18:302026-09-21 18:30
net_gexXLF2026-09-18-183199624.8192710000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_expiry_dteXLF2026-09-1828.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_distance_pctXLF2026-09-180.0025062657metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_slope_30_90XLF2026-09-18-0.0110000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_regime_daysXLF2026-09-18-36.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_90dXLF2026-09-180.1550000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_30dXLF2026-09-180.1440000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_stateXLF2026-09-181.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_levelXLF2026-09-1858.0329890852metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_distance_atrXLF2026-09-182.8629632216metric_daily——2026-09-21 18:302026-09-21 18:30
drawdown_252dXLF2026-09-18-0.0461065574metric_daily——2026-09-21 18:302026-09-21 18:30
dollar_volume_21dXLF2026-09-181735594606.2180100000metric_daily——2026-09-21 18:302026-09-21 18:30
close_adjXLF2026-09-1855.6634630000metric_daily——2026-09-21 18:302026-09-21 18:30
call_wall_distance_pctXLF2026-09-180.0204081633metric_daily——2026-09-21 18:302026-09-21 18:30
zero_dte_volume_shareXLF2026-09-17—metric_daily——2026-09-21 18:302026-09-21 18:30
vrp_30dXLF2026-09-170.0049860000metric_daily——2026-09-21 18:302026-09-21 18:30
rr_25dXLF2026-09-17-0.0223318208metric_daily——2026-09-21 18:302026-09-21 18:30
rr_10dXLF2026-09-170.0253836675metric_daily——2026-09-21 18:302026-09-21 18:30
ret_1dXLF2026-09-17-0.0008939746metric_daily——2026-09-21 18:302026-09-21 18:30
realized_vol_21dXLF2026-09-170.1340194027metric_daily——2026-09-21 18:302026-09-21 18:30
px_vs_200dmaXLF2026-09-170.0457890488metric_daily——2026-09-21 18:302026-09-21 18:30
put_wall_distance_pctXLF2026-09-170.0021474588metric_daily——2026-09-21 18:302026-09-21 18:30
net_gexXLF2026-09-17-330130425.8757250000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_expiry_dteXLF2026-09-1729.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
max_pain_distance_pctXLF2026-09-170.0021474588metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_slope_30_90XLF2026-09-17-0.0160000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_term_regime_daysXLF2026-09-17-35.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_90dXLF2026-09-170.1680000000metric_daily——2026-09-21 18:302026-09-21 18:30
iv_cm_30dXLF2026-09-170.1520000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_stateXLF2026-09-171.0000000000metric_daily——2026-09-21 18:302026-09-21 18:30
gamma_flip_levelXLF2026-09-1757.5583087409metric_daily——2026-09-21 18:302026-09-21 18:30