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×

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-09-17-0.0175303410metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-16-0.0041030952metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-150.0023053022metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-140.0052271813metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-11-0.0513594020metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-10-0.0336857159metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-09-0.0601503759metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-08-0.0537471612metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctSOXX2026-09-04-0.0382025930metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-09-03-0.0043807248metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-09-02-0.0028717294metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-09-01-0.0006196158metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-31-0.0216030056metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctSOXX2026-08-28-0.0169478196metric_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
put_wall_distance_pctSOXX2026-08-26-0.0298797051metric_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-24-0.0122090956metric_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-20-0.0427874031metric_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-18-0.0590714917metric_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-14-0.0916027761metric_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-12-0.0852710342metric_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-10-0.0555167268metric_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-06-0.0235108541metric_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-04-0.0409619889metric_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-07-31-0.0294915724metric_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-290.0537634409metric_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-27-0.0314394747metric_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-23-0.0385313112metric_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-21-0.0953337314metric_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-170.0061133363metric_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-15-0.0094908783metric_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-13-0.0426473510metric_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-090.0056730273metric_daily——2026-09-15 12:172026-09-15 12:17