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×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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_200dmaMSFT2026-07-09-0.1291032645metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-07-08-0.1326948291metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-07-07-0.1214626975metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-07-06-0.1273703472metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-07-02-0.1200912202metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-07-01-0.1352694637metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-30-0.1617619013metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-29-0.1729218915metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-26-0.1642545861metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-25-0.2104658672metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-24-0.1835028633metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-23-0.1657353676metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-22-0.1816543826metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-18-0.1560550594metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-17-0.1582922006metric_daily——2026-09-15 12:152026-09-15 12:15
px_vs_200dmaMSFT2026-06-16-0.1263579975metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-15-0.1143095228metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-12-0.1352880555metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-11-0.1372056625metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-10-0.1227625878metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-09-0.1104536996metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-08-0.0930619844metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-05-0.0831112483metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-04-0.0589914719metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-03-0.0614287271metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-02-0.0316895525metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-06-010.0096073076metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-29-0.0135345803metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-28-0.0652408205metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-27-0.0974853901metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-26-0.0911828316metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-22-0.0866386332metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-21-0.0865226188metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-20-0.0852537335metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-19-0.0942584405metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-18-0.0820113511metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-15-0.0865805425metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-14-0.1144672211metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-13-0.1245428569metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-12-0.1200037498metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-11-0.1104391914metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-08-0.1060541785metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-07-0.0947431881metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-06-0.1101753187metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-05-0.1166055876metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-04-0.1127073757metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-05-01-0.1118544975metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-04-30-0.1269525312metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-04-29-0.0921654279metric_daily——2026-09-13 12:182026-09-13 12:18
px_vs_200dmaMSFT2026-04-28-0.0826627545metric_daily——2026-09-13 12:182026-09-13 12:18