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 = LMT×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_200dmaLMT2016-09-010.0690420420metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-020.0671330816metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-060.0651212017metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-070.0574281944metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-080.0580592061metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-090.0414849260metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-120.0448209228metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-130.0383314588metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-140.0379630747metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-150.0447481207metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-160.0370865122metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-190.0514583453metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-200.0490361878metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-210.0629105774metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-220.0743657189metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-230.0702308532metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-260.0681246611metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-270.0685237872metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-280.0675818528metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-290.0520759154metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-300.0400384235metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-030.0431442667metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-040.0274673862metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-050.0246598556metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-060.0159952599metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-070.0103958904metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-100.0089226662metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-110.0023077960metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-120.0029926295metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-130.0064660119metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-140.0042748867metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-170.0047010643metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-180.0042662756metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-190.0018789999metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-20-0.0006812968metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-21-0.0067925635metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-24-0.0002371437metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-250.0725142814metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-260.0752367879metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-270.0676433804metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-280.0645408930metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-10-310.0567951796metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-010.0500200758metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-020.0496973515metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-030.0215391288metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-040.0105623487metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-070.0226358594metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-080.0215592267metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-090.0813516507metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-11-100.0963217042metric_daily——2026-09-09 11:172026-09-09 11:17