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 = MSFT×metric_id = px_vs_200dma×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
px_vs_200dmaMSFT2016-09-010.0902066411metric_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
px_vs_200dmaMSFT2016-09-060.0894910624metric_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
px_vs_200dmaMSFT2016-09-080.0851494664metric_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
px_vs_200dmaMSFT2016-09-120.0772565608metric_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
px_vs_200dmaMSFT2016-09-140.0616039010metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-150.0787522184metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-160.0795640963metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-190.0732433299metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-200.0706075877metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-210.0882056123metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-220.0890145591metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-230.0813876843metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-260.0711027246metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-270.0904789666metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-280.0914649132metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-290.0792734168metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-09-300.0826765503metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-030.0790477683metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-040.0753962553metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-050.0824435412metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-060.0839129656metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-070.0846764230metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-100.0888386497metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-110.0726268337metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-120.0708967804metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-130.0671830675metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-140.0763310966metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-170.0722949978metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-180.0801394245metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-190.0773420580metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-200.0716683185metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-210.1158893755metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-240.1399163482metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-250.1386928828metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-260.1310306132metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-270.1201511343metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-280.1150508142metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-10-310.1149482836metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-010.1116544950metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-020.1037850465metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-030.0987046009metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-040.0886717699metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-070.1193767886metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-080.1193336123metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-090.1127524996metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMSFT2016-11-100.0847954196metric_daily——2026-09-09 11:172026-09-09 11:17