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 = put_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
put_wall_distance_pctSOXX2026-06-17-0.0495723075metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-18-0.1086089608metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-22-0.1297842781metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-23-0.0553373440metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-24-0.1687448047metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-25-0.0722968650metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-26-0.1524561820metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-29-0.0477740702metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-06-30-0.0870216618metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-01-0.0245122561metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-020.0329848849metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-060.0060016165metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-07-0.0030633145metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-080.0408697045metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-090.0056730273metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-10-0.0969140262metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-13-0.0426473510metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-14-0.0315537400metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-15-0.0094908783metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-16-0.0103675778metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-170.0061133363metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-200.0016407830metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-21-0.0953337314metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-22-0.0459389401metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-23-0.0385313112metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-240.0056735166metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-27-0.0314394747metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-280.0173767957metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-290.0537634409metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-30-0.0089786534metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-07-31-0.0294915724metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-03-0.0348250867metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-04-0.0409619889metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-05-0.0201620501metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-06-0.0235108541metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-07-0.0796473209metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-10-0.0555167268metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-11-0.0640209659metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-12-0.0852710342metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-13-0.0921305879metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-14-0.0916027761metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-17-0.1057375876metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-18-0.0590714917metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-19-0.0378509439metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-20-0.0427874031metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-21-0.0385539852metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-24-0.0122090956metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-25-0.0273508929metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-26-0.0298797051metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-27-0.0483984546metric_daily——2026-09-15 12:172026-09-15 12:17