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 = MSFT×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_1dMSFT2016-09-010.0022624434metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-010.0687699201metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-010.0902066411metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-01-0.0099707753metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-011000138425.7211800000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-0151.1380427588metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-020.0013891301metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-020.0645835787metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-020.0911255393metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-02-0.0085954960metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-02982107260.4253330000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-0251.2090801511metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-06-0.0010404023metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-060.0549328630metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-060.0894910624metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-06-0.0096269555metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-06950312181.3210440000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-0651.1558021069metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-070.0008679049metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-070.0546758319metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-070.0899413278metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-07-0.0087674059metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-07945451149.6692760000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-0751.2002004771metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-08-0.0039889005metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-080.0555664287metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-080.0851494664metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-08-0.0127213340metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-08952990560.7456900000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-0850.9959679743metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-09-0.0212432527metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-090.0911233234metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-090.0617852919metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-09-0.0336943442metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-09998031686.8199390000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-0949.9126477422metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-120.0149439601metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-120.1052025881metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-120.0772565608metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-12-0.0192539110metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-121024223786.9742400000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-1250.6585403610metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-13-0.0091148116metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-130.1075908885metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-130.0670425669metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMSFT2016-09-13-0.0281932267metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMSFT2016-09-131043519429.7050300000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-1350.1967973113metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMSFT2016-09-14-0.0047762250metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMSFT2016-09-140.1073988480metric_daily——2026-09-09 11:172026-09-09 11:17