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 = DE×metric_id = rr_25d×

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
rr_25dDE2026-09-170.0126167038metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-160.0088480763metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-150.0490804345metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-140.0245825143metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-11-0.0296202696metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-100.0281473065metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-090.0060991810metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-08-0.0659424181metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dDE2026-09-04-0.0405516702metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-09-030.0023274860metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-09-020.0066466704metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-09-010.0102889295metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-310.0173220967metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-28-0.0045855100metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-27-0.0124472030metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-260.0023188056metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-25-0.0090435221metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-240.0052546970metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-21-0.0061841707metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-200.0171252470metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-19-0.0027516213metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-18-0.0365358810metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-17-0.0178248461metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-140.0168183106metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-130.0120606833metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-12-0.0036977168metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-11-0.0142881838metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-10-0.0036910791metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-07-0.0192245936metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-06-0.0327458657metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-05-0.0285670037metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-04-0.0010209643metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-08-03-0.0139564686metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-07-31-0.0146304317metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dDE2026-07-30-0.0063357563metric_daily——2026-09-15 12:172026-09-15 12:17