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 = CRWD×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_1dCRWD2019-06-12—metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-12—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-12—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-12—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-12—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-1214.5000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-130.1648275862metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-13—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-13—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-13—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-13—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-1316.8900000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-14-0.0503256365metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-14—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-14—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-14—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-14—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-1416.0400000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-170.0911783042metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-17—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-17—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-17—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-17—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-1717.5025000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-180.0927010427metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-18—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-18—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-18—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-18—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-1819.1250000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-190.0094117647metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-19—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-19—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-19—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-19—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-1919.3050000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-20-0.0306915307metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-20—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-20—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-20—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-20—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-2018.7125000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-21-0.0350033400metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-21—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRWD2019-06-21—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRWD2019-06-21—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRWD2019-06-21—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRWD2019-06-2118.0575000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRWD2019-06-24-0.0589782639metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRWD2019-06-24—metric_daily——2026-09-09 11:172026-09-09 11:17