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.

697,178 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 150 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
dollar_volume_21dDELL2019-01-16—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-1619.6231630373metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-170.0255748475metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-17—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-17—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-17—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-17—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-1720.1250224393metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-18-0.0082361016metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-18—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-18—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-18—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-18—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-1819.9592707102metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-220.0163783160metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-22—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-22—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-22—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-22—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-2220.2861699536metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-230.0127099410metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-23—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-23—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-23—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-2376744409.2202565000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-2320.5440059767metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-240.0076199014metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-240.4774955662metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-24—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-24—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-2480160101.0955608000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-2420.7005492763metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-250.0211298932metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-250.4811534346metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-25—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-25—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-2582795499.1286399000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-2521.1379496725metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-280.0215639294metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-280.4336792773metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-28—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-28—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-2888514942.1463918000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-2821.5937669275metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-29-0.0010660981metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-290.4325683845metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-29—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-29—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-2991846791.4373825000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-2921.5707458540metric_daily——2026-09-09 11:172026-09-09 11:17