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 250 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-02-11—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-11—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-1166643631.2771396000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-1123.9511248522metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-120.0303729335metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-120.2583478762metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-12—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-12—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-1267982213.5008129000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-1224.6785907743metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-130.0065298507metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-130.1956599622metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-13—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-13—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-1366643123.8573811000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-1324.8397382887metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-140.0079703429metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-140.1947122078metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-14—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-14—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-1467074165.8120231000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-1425.0377195206metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-150.0114012505metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-150.1800912378metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-15—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-15—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-1567545960.8605870000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-1525.3231808318metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-190.0007272727metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-190.1775268393metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-19—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-19—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-1965668666.9584688000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-1925.3415976906metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-200.0090843023metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-200.1633348576metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-20—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-20—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-2064256572.2650180000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-2025.5718084254metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-210.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-210.1675022870metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-21—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-21—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-2163559803.1492251000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-2125.5718084254metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-220.0115232265metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-220.1674125369metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-22—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-22—metric_daily——2026-09-09 11:172026-09-09 11:17