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 = SPCX×metric_id = vrp_30d×

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
vrp_30dSPCX2026-09-180.1828400000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-170.1732780000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-160.1894000000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-150.2065650000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-140.2049760000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-110.2299100000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-100.1729510000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-090.1295800000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-080.2315950000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSPCX2026-09-040.1263560000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-09-030.1140060000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-09-020.0156240000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-09-010.1582140000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-310.1900130000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-280.1147180000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-270.1187210000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-260.1356480000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-250.1460100000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-240.1589830000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-210.1134590000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-200.0537010000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-190.0160020000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-18-0.0524650000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-17-0.1025520000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-14-0.1457190000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-13-0.1328220000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-12-0.1681720000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-11-0.1012920000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-10-0.1119330000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-07-0.1477710000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-060.0417360000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-050.0867220000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-040.1826830000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-08-030.3129390000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-310.2757870000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-300.2252120000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-290.1403620000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-280.0835740000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-270.0541610000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-240.0889950000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-230.1306820000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-220.2245170000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-210.0835070000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-200.0417020000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-170.1236490000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSPCX2026-07-160.2510460000metric_daily——2026-09-15 12:172026-09-15 12:17