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 = SOXX×metric_id = call_wall_distance_pct×

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
call_wall_distance_pctSOXX2026-09-170.0209978809metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-16-0.0041030952metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-150.0223514082metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-140.0253317250metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-110.0624774698metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-100.0242931411metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-090.0526315789metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-080.0030280091metric_daily——2026-09-18 18:302026-09-18 18:30
call_wall_distance_pctSOXX2026-09-040.0195052514metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-09-030.0155316607metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-09-020.0170708360metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-09-010.0593432072metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-310.0273168441metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-280.0322047894metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-27-0.0008183773metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-260.0186263097metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-250.0212815625metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-240.0371804496metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-210.0095183155metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-20-0.0044988992metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-190.0006350184metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-180.0350213591metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-17-0.0163113464metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-14-0.0007630537metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-13-0.0013436467metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-120.0062018624metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-110.0295769375metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-100.0389316005metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-070.0123879471metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-060.0328250582metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-050.0363670624metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-040.0143671271metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-08-030.0833595966metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-310.0893461942metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-30-0.0089786534metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-290.4408602151metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-280.3632849062metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-270.2978711040metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-240.2713231248metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-230.2154415500metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-220.2060771889metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-210.0494128716metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-200.2782844278metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-170.2839922577metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-160.2629594722metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-150.2066202028metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-140.1797436259metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-130.2102382544metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-100.1525097189metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-090.1517964587metric_daily——2026-09-15 12:172026-09-15 12:17