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: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_200dmaXOM2016-09-010.0397730469metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-010.0383258691metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLV2016-09-010.0359678676metric_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
px_vs_200dmaXLP2016-09-010.0462652851metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLK2016-09-010.0935439211metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-010.0779818699metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLF2016-09-010.0727051573metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-010.0811178179metric_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
px_vs_200dmaSTX2016-09-010.1617462123metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-010.0645684061metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-010.2025169863metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-010.2117910292metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaQQQ2016-09-010.0748917100metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-01-0.0395143627metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-010.0605165744metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaNVDA2016-09-010.5822551004metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMU2016-09-010.3303884630metric_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
px_vs_200dmaMRVL2016-09-010.3171211709metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-010.1237291026metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-010.0690420420metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-010.1065898739metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-010.1272020710metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaGOOG2016-09-010.0522451675metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaDIA2016-09-010.0605070707metric_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
px_vs_200dmaCAT2016-09-010.1329486956metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-010.1997879713metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-010.1690854851metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-010.9758064516metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAAPL2016-09-010.0509538526metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-020.0461224153metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-020.0401844424metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLV2016-09-020.0369070108metric_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
px_vs_200dmaXLP2016-09-020.0536257252metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLK2016-09-020.0977842501metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLI2016-09-020.0827432932metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLF2016-09-020.0773360481metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-020.0930306467metric_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
px_vs_200dmaSTX2016-09-020.1686312555metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-020.0689431012metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-020.1998905121metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-020.2091653035metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaQQQ2016-09-020.0780633964metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-02-0.0080406240metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-020.0623487778metric_daily——2026-09-09 11:172026-09-09 11:17