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 = WDC×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_1dWDC2016-09-01-0.0074994643metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-010.3036354282metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-01-0.0293714519metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-01-0.4449213127metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-01109521375.6361430000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0130.7302350067metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-020.0140328152metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-020.3028960065metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-02-0.0143425631metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-02-0.4371319961metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-02107829850.5098310000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0231.1614667156metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-060.0123483074metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-060.2940740904metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-06-0.0006211860metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-06-0.4301815289metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-06108507042.0505670000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0631.5462580865metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-070.1209253417metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-070.5044298530metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-070.1210383262metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-07-0.3612760355metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-07133788725.6017740000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0735.3610001265metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-080.0031894934metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-080.5035458440metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-080.1253723041metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-08-0.3592388297metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-08141547732.1971550000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0835.4737838042metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-09-0.0351599027metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-090.4891549649metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-090.0867089122metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-09-0.3817679301metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-09143149762.8458970000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0934.2265290155metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-120.0139561931metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-120.4887038454metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-120.1027678043metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-12-0.3731397640metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-12148693168.1847760000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-1234.7042010622metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-130.0011470082metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-130.4894118501metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaWDC2016-09-130.1048981201metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dWDC2016-09-13-0.3724207501metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dWDC2016-09-13154008619.3986790000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-1334.7440070661metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dWDC2016-09-14-0.0072560626metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dWDC2016-09-140.4826838320metric_daily——2026-09-09 11:172026-09-09 11:17