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 = US×metric_id = sector_breadth_200dma×

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
sector_breadth_200dmaUS2026-09-180.5000000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-170.6250000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-160.6250000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-150.6250000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-140.6250000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-110.7500000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-100.6250000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-090.7500000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-080.7500000000metric_daily——2026-09-18 18:302026-09-18 18:30
sector_breadth_200dmaUS2026-09-040.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-09-030.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-09-020.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-09-010.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-310.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-280.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-270.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-260.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-250.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-240.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-210.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-200.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-190.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-180.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-170.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-140.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-130.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-120.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-110.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-100.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-070.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-060.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-050.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-040.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-08-030.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-310.7500000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-300.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-290.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-280.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-270.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-240.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-230.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-220.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-210.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-200.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-170.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-161.0000000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-151.0000000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-140.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-130.8750000000metric_daily——2026-09-16 22:442026-09-16 22:44
sector_breadth_200dmaUS2026-07-101.0000000000metric_daily——2026-09-16 22:442026-09-16 22:44