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×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
call_wall_distance_pctSOXX2026-06-170.0004502026metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-180.0164985534metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-220.0686859743metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-230.1601120337metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-240.1305070657metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-25-0.0083173385metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-260.1526595925metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-290.0905835436metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-06-300.0612397778metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-010.1172252793metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-020.0859584687metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-060.2037626180metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-070.2688285088metric_daily——2026-09-15 12:172026-09-15 12:17
call_wall_distance_pctSOXX2026-07-080.1921071829metric_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
call_wall_distance_pctSOXX2026-07-100.1525097189metric_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-140.1797436259metric_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-160.2629594722metric_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-200.2782844278metric_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-220.2060771889metric_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-240.2713231248metric_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-280.3632849062metric_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-30-0.0089786534metric_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-08-030.0833595966metric_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-050.0363670624metric_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-070.0123879471metric_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-110.0295769375metric_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-13-0.0013436467metric_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-17-0.0163113464metric_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-190.0006350184metric_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-210.0095183155metric_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-250.0212815625metric_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-27-0.0008183773metric_daily——2026-09-15 12:172026-09-15 12:17