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

as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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
px_vs_200dmaDELL2019-01-04—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-04—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-04—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-0421.1885960342metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-070.0065189048metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-07—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-07—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-07—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-07—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-0721.3267224751metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-080.0118739206metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-08—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-08—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-08—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-08—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-0821.5799542834metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-090.0014934926metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-09—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-09—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-09—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-09—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-0921.6121837863metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-10-0.0372816361metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-10—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-10—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-10—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-10—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-1020.8064462144metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-11-0.0159327285metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-11—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-11—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-11—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-11—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-1120.4749427562metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-14-0.0375534068metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-14—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-14—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-14—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-14—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-1419.7060389019metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-150.0049065421metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-15—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-15—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-15—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-15—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-1519.8027274105metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-16-0.0090676587metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-16—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-16—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-16—metric_daily——2026-09-09 11:172026-09-09 11:17