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.

696,350 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 = DE×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_1dDE2016-09-01-0.0118273211metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-010.4949958625metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-010.0547174973metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-01-0.0515381996metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-01305578906.5212260000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-0171.4134347619metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-020.0059844405metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-020.4934806685metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-020.0602325530metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-02-0.0458621864metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-02305591099.8058670000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-0271.8408042099metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-060.0049970256metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-060.4933227553metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-060.0647499905metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-06-0.0410943353metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-06307740195.2959480000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-0672.1997945462metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-07-0.0053273351metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-070.4941930669metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-070.0583597948metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-07-0.0462027472metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-07306550439.2949990000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-0771.8151620430metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-08-0.0052368484metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-080.4949486764metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-080.0521682324metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-08-0.0511976388metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-08304301446.2945380000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-0871.4390769287metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-09-0.0161521895metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-090.4976629680metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-090.0345680999metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-09-0.0665228743metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-09309053832.6655130000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-0970.2851794191metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-120.0104584701metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-120.4979945632metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-120.0448317694metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-12-0.0567601317metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-12312545579.0675650000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-1271.0202548697metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-13-0.0240702852metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-130.5041641421metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDE2016-09-130.0194973533metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dDE2016-09-13-0.0794641844metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dDE2016-09-13311048208.8182370000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-1369.3107770777metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dDE2016-09-14-0.0064126279metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dDE2016-09-140.5025842798metric_daily——2026-09-09 11:172026-09-09 11:17