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 = XLU×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_1dXLU2016-09-01-0.0050782043metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-010.1450914448metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-010.0355204858metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-01-0.0755001888metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-01505550375.0499920000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0117.8467154400metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-020.0132707227metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-020.1548231362metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-020.0483498198metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-02-0.0632314081metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-02511653958.7020420000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0218.0835542525metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-060.0108805158metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-060.1534538712metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-060.0588043691metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-06-0.0530388826metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-06490773032.6292750000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0618.2803126506metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-070.0001993223metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-070.1534720123metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-070.0581137812metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-07-0.0528501321metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-07486978195.8707550000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0718.2839563246metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-080.0033878039metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-080.1540494321metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-080.0607959195metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-08-0.0496413741metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-08491656001.4252010000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0818.3458987833metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-09-0.0375372393metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-090.2008967080metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-090.0202704844metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-09-0.0853152133metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-09520032111.3470880000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0917.6572443900metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-120.0177465951metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-120.2119483565metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-120.0375589411metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-12-0.0690826727metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-12547005974.8886290000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-1217.9706003573metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-13-0.0137875101metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-130.2159624509metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLU2016-09-130.0224941134metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLU2016-09-13-0.0819177048metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLU2016-09-13563159684.8362990000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-1317.7228305227metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLU2016-09-140.0039062500metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLU2016-09-140.2113176444metric_daily——2026-09-09 11:172026-09-09 11:17