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 200 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_1dDELL2019-01-300.0245464248metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-300.4357968239metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-30—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-30—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-3091553583.2970758000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-3022.1002305441metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-01-310.0122916667metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-01-310.3491814800metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-01-31—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-01-31—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-01-3189304511.3122072000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-01-3122.3718792112metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-010.0218151883metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-010.3314114114metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-01—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-01—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-0184970648.6787539000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-0122.8599259691metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-040.0237663646metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-040.2955796570metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-04—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-04—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-0481696219.2396586000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-0423.4032233033metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-050.0047216211metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-050.2912434814metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-05—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-05—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-0575793896.9851677000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-0523.5137244560metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-06-0.0025455257metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-060.2923900560metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-06—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-06—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-0673959046.0461055000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-0623.4538696650metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-07-0.0098154692metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-070.2953239971metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-07—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-07—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-0768442740.4401054000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-0723.2236589301metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-080.0208168121metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-080.3010619158metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDELL2019-02-08—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDELL2019-02-08—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDELL2019-02-0867072145.6270989000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDELL2019-02-0823.7071014733metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDELL2019-02-110.0102932608metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDELL2019-02-110.2600039291metric_daily——2026-09-09 11:172026-09-09 11:17