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 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_1dDELL2018-12-21—metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2018-12-21—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2018-12-21—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2018-12-21—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2018-12-21—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2018-12-2119.4174927668metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2018-12-240.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2018-12-24—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2018-12-24—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2018-12-24—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2018-12-24—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2018-12-2419.4174927668metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2018-12-260.0648917680metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2018-12-26—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2018-12-26—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2018-12-26—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2018-12-26—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2018-12-2620.6775282029metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2018-12-27-0.0069026943metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2018-12-27—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2018-12-27—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2018-12-27—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2018-12-27—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2018-12-2720.5347975473metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2018-12-280.0186098655metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2018-12-28—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2018-12-28—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2018-12-28—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2018-12-28—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2018-12-2820.9169473671metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2018-12-310.0757208893metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2018-12-31—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2018-12-31—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2018-12-31—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2018-12-31—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2018-12-3122.5007972227metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-02-0.0358092900metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-02—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-02—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-02—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-02—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-0221.6950596508metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-03-0.0422325976metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-03—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-03—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-03—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-03—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-0320.7788209262metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-040.0197208066metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-04—metric_daily——2026-09-09 11:172026-09-09 11:17