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 = CRSR×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_1dCRSR2020-09-23—metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-09-23—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-09-23—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-09-23—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-09-23—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-09-2314.2500000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-09-240.0933333333metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-09-24—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-09-24—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-09-24—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-09-24—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-09-2415.5800000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-09-250.1071887035metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-09-25—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-09-25—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-09-25—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-09-25—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-09-2517.2500000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-09-280.0707246377metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-09-28—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-09-28—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-09-28—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-09-28—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-09-2818.4700000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-09-290.0167839740metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-09-29—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-09-29—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-09-29—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-09-29—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-09-2918.7800000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-09-300.0702875399metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-09-30—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-09-30—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-09-30—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-09-30—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-09-3020.1000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-10-010.0422885572metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-10-01—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-10-01—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-10-01—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-10-01—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-10-0120.9500000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-10-02-0.0023866348metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-10-02—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCRSR2020-10-02—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCRSR2020-10-02—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCRSR2020-10-02—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCRSR2020-10-0220.9000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCRSR2020-10-05-0.0416267943metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCRSR2020-10-05—metric_daily——2026-09-09 11:172026-09-09 11:17