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 = XLI×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_1dXLI2016-09-010.0008533880metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-010.0646986269metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-010.0779818699metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-01-0.0074475288metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-01386157063.2413700000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0149.3724923648metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-020.0049454297metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-020.0662623472metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-020.0827432932metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-02-0.0025389303metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-02394521347.6646620000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0249.6166605569metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-06-0.0028847786metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-060.0586985059metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-060.0791423290metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-06-0.0054163846metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-06403249508.4636580000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0649.4735274787metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-070.0011912866metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-070.0586630723metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-070.0799667193metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-07-0.0042315504metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-07404852008.5449250000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0749.5324646286metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-08-0.0008499065metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-080.0587663130metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-080.0786206555metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-08-0.0050778605metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-08413465582.8760350000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0849.4903666644metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-09-0.0282408983metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-090.1152192493metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-090.0478767389metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-09-0.0331753555metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-09445991684.1533040000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0948.0927142543metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-120.0127801120metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-120.1221889780metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-120.0609029322metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-12-0.0208192282metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-12469997097.7956520000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-1248.7073445311metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-13-0.0146931720metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-130.1313969308metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-130.0450361592metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLI2016-09-13-0.0352064997metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLI2016-09-13509496464.1532540000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-1347.9916791404metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLI2016-09-14-0.0008771930metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLI2016-09-140.1282346411metric_daily——2026-09-09 11:172026-09-09 11:17