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

as_of_date leads no index, so this sort reads every matching row and keeps only the top 150 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_30dMETA2026-09-11-0.0327920000metric_daily2026-09-18 18:302026-09-18 18:30
rr_25dMETA2026-09-110.0000575501metric_daily2026-09-18 18:302026-09-18 18:30
rr_10dMETA2026-09-110.0020606484metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dMETA2026-09-110.0056643595metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dMETA2026-09-110.3701798598metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaMETA2026-09-110.0408812326metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctMETA2026-09-110.0030399827metric_daily2026-09-18 18:302026-09-18 18:30
net_gexMETA2026-09-11809880050.5684230000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteMETA2026-09-117.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMETA2026-09-11-0.0741169390metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90META2026-09-11-0.0500000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMETA2026-09-11-31.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dMETA2026-09-110.4160000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dMETA2026-09-110.3660000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_stateMETA2026-09-111.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_levelMETA2026-09-11580.3066038629metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrMETA2026-09-11-3.1758130258metric_daily2026-09-18 18:302026-09-18 18:30
drawdown_252dMETA2026-09-11-0.1667363823metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dMETA2026-09-1110290941206.2819000000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjMETA2026-09-11648.0300000000metric_daily2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctMETA2026-09-110.0030399827metric_daily2026-09-18 18:302026-09-18 18:30
zero_dte_volume_shareMETA2026-09-10metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dMETA2026-09-10-0.0597640000metric_daily2026-09-18 18:302026-09-18 18:30
rr_25dMETA2026-09-10-0.0070566061metric_daily2026-09-18 18:302026-09-18 18:30
rr_10dMETA2026-09-10-0.0183560960metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dMETA2026-09-10-0.0142422249metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dMETA2026-09-100.3946350106metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaMETA2026-09-100.0354785724metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctMETA2026-09-100.0087215618metric_daily2026-09-18 18:302026-09-18 18:30
net_gexMETA2026-09-10904465428.9037980000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteMETA2026-09-108.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMETA2026-09-10-0.0688724045metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90META2026-09-10-0.0400000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMETA2026-09-10-30.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_90dMETA2026-09-100.4300000000metric_daily2026-09-18 18:302026-09-18 18:30
iv_cm_30dMETA2026-09-100.3900000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_stateMETA2026-09-101.0000000000metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_levelMETA2026-09-10576.2527561987metric_daily2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrMETA2026-09-10-3.2965209352metric_daily2026-09-18 18:302026-09-18 18:30
drawdown_252dMETA2026-09-10-0.1714297024metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dMETA2026-09-1010257915188.8462000000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjMETA2026-09-10644.3800000000metric_daily2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctMETA2026-09-100.0087215618metric_daily2026-09-18 18:302026-09-18 18:30
zero_dte_volume_shareMETA2026-09-09metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dMETA2026-09-09-0.0476140000metric_daily2026-09-18 18:302026-09-18 18:30
rr_25dMETA2026-09-09-0.0269018747metric_daily2026-09-18 18:302026-09-18 18:30
rr_10dMETA2026-09-09-0.0525768758metric_daily2026-09-18 18:302026-09-18 18:30
ret_1dMETA2026-09-090.0655441090metric_daily2026-09-18 18:302026-09-18 18:30
realized_vol_21dMETA2026-09-090.3892489364metric_daily2026-09-18 18:302026-09-18 18:30
px_vs_200dmaMETA2026-09-090.0509184192metric_daily2026-09-18 18:302026-09-18 18:30