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 = LMT×metric_id = max_pain_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
max_pain_distance_pctLMT2026-09-170.0035495921metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-160.0051186598metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-150.0122595883metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-140.0200612037metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-110.0492378718metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-100.0469327699metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-090.0582313236metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-080.0398209456metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctLMT2026-09-040.0660980810metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-09-030.0601369734metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-09-020.0723356222metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-09-010.0468319559metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-31-0.0021916148metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-28-0.0068280571metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-27-0.0104083833metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-26-0.0099359994metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-250.0062531445metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-24-0.0073386039metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-21-0.0152066292metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-20-0.0288374046metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-19-0.0579648646metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-18-0.0859232176metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-17-0.0736686092metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-14-0.0799763422metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-13-0.0635608100metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-12-0.0852452532metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-11-0.0799136792metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-10-0.0881358180metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-07-0.0815545540metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-06-0.0735180578metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-05-0.0650969529metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-04-0.0921894355metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-08-03-0.0874823040metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-31-0.0819233277metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-30-0.0681228336metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-29-0.0600843289metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-28-0.0796648948metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-27-0.0818965517metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-24-0.0902849296metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-23-0.0854570077metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-220.0109650828metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-210.0254589915metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-200.0205283197metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-170.0220728423metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-160.0223555071metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-150.0204875015metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-140.0291461970metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-130.0178996697metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-10-0.0109323038metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctLMT2026-07-09-0.0062902790metric_daily——2026-09-15 12:172026-09-15 12:17