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 = 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_30dSOXX2026-09-180.0501020000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-170.0542860000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-160.0536730000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-150.0366600000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-140.0195110000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-110.0925770000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-100.0976970000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-090.1270300000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-080.1528530000metric_daily——2026-09-18 18:302026-09-18 18:30
vrp_30dSOXX2026-09-040.1771910000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-09-030.2322190000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-09-020.2540320000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-09-010.2126880000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-310.2042840000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-280.1865740000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-270.1329420000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-260.1573540000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-250.0980680000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-240.1057620000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-210.0858800000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-200.0856370000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-190.0766430000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-180.0460610000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-170.1120450000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-140.1068850000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-130.0589850000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-120.0368040000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-110.0413660000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-100.0446450000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-070.0116210000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-060.0235530000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-050.0314190000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-040.0096660000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-08-030.0384190000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-310.0073470000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-30-0.0442580000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-29-0.0025730000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-280.0131230000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-270.0407880000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-24-0.0035220000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-230.0294960000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-22-0.0166150000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-21-0.0734430000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-20-0.0698520000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-17-0.0826400000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-16-0.1300120000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-15-0.1517810000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-14-0.1161830000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-13-0.1511400000metric_daily——2026-09-15 12:172026-09-15 12:17
vrp_30dSOXX2026-07-10-0.1438380000metric_daily——2026-09-15 12:172026-09-15 12:17