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 = SPCX×sorted by as_of_date ↑×

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
ret_1dSPCX2026-06-12—metric_daily——2026-09-13 12:182026-09-13 12:18
realized_vol_21dSPCX2026-06-12—metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaSPCX2026-06-12—metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSPCX2026-06-12—metric_daily——2026-09-13 12:182026-09-13 12:18
dollar_volume_21dSPCX2026-06-12—metric_daily——2026-09-13 12:182026-09-13 12:18
close_adjSPCX2026-06-12160.9500000000metric_daily——2026-09-13 12:182026-09-13 12:18
ret_1dSPCX2026-06-150.1960236098metric_daily——2026-09-13 12:182026-09-13 12:18
realized_vol_21dSPCX2026-06-15—metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaSPCX2026-06-15—metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSPCX2026-06-15—metric_daily——2026-09-13 12:182026-09-13 12:18
dollar_volume_21dSPCX2026-06-15—metric_daily——2026-09-13 12:182026-09-13 12:18
close_adjSPCX2026-06-15192.5000000000metric_daily——2026-09-13 12:182026-09-13 12:18
ret_1dSPCX2026-06-160.0483116883metric_daily——2026-09-13 12:182026-09-13 12:18
realized_vol_21dSPCX2026-06-16—metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaSPCX2026-06-16—metric_daily——2026-09-13 12:182026-09-13 12:18
iv_term_slope_30_90SPCX2026-06-160.0570000000metric_daily——2026-09-13 12:182026-09-13 12:18
iv_term_regime_daysSPCX2026-06-161.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
iv_cm_90dSPCX2026-06-161.0390000000metric_daily——2026-09-13 12:182026-09-13 12:18
iv_cm_30dSPCX2026-06-161.0960000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSPCX2026-06-16—metric_daily——2026-09-13 12:182026-09-13 12:18
dollar_volume_21dSPCX2026-06-16—metric_daily——2026-09-13 12:182026-09-13 12:18
close_adjSPCX2026-06-16201.8000000000metric_daily——2026-09-13 12:182026-09-13 12:18
zero_dte_volume_shareSPCX2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
ret_1dSPCX2026-06-17-0.0494549058metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSPCX2026-06-17—metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaSPCX2026-06-17—metric_daily——2026-09-15 12:152026-09-15 12:15
put_wall_distance_pctSPCX2026-06-170.0426441456metric_daily——2026-09-15 12:172026-09-15 12:17
net_gexSPCX2026-06-17-11689862.3492255000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSPCX2026-06-1730.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctSPCX2026-06-170.0947763528metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SPCX2026-06-170.0460000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysSPCX2026-06-172.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_cm_90dSPCX2026-06-170.8970000000metric_daily——2026-09-15 12:152026-09-15 12:15
iv_cm_30dSPCX2026-06-170.9430000000metric_daily——2026-09-15 12:152026-09-15 12:15
gamma_flip_stateSPCX2026-06-171.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSPCX2026-06-17193.8521191239metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
drawdown_252dSPCX2026-06-17—metric_daily——2026-09-15 12:152026-09-15 12:15
dollar_volume_21dSPCX2026-06-17—metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSPCX2026-06-17191.8200000000metric_daily——2026-09-15 12:152026-09-15 12:15
call_wall_distance_pctSPCX2026-06-170.0687102492metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSPCX2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
ret_1dSPCX2026-06-18-0.0355541654metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSPCX2026-06-18—metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaSPCX2026-06-18—metric_daily——2026-09-15 12:152026-09-15 12:15
put_wall_distance_pctSPCX2026-06-180.0810810811metric_daily——2026-09-15 12:172026-09-15 12:17
net_gexSPCX2026-06-184247165.5866711400metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSPCX2026-06-1829.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctSPCX2026-06-180.0810810811metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SPCX2026-06-180.0230000000metric_daily——2026-09-15 12:172026-09-15 12:17