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 = iv_term_slope_30_90×

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
iv_term_slope_30_90SOXX2026-09-18-0.0270000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-17-0.0320000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-16-0.0100000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-15-0.0200000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-14-0.0280000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-11-0.0330000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-10-0.0260000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-09-0.0020000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-08-0.0080000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_slope_30_90SOXX2026-09-04-0.0190000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-09-03-0.0290000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-09-02-0.0280000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-09-01-0.0230000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-31-0.0330000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-28-0.0340000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-27-0.0340000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-26-0.0180000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-25-0.0270000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-24-0.0180000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-21-0.0390000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-20-0.0260000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-19-0.0250000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-18-0.0170000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-17-0.0230000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-14-0.0410000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-13-0.0290000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-12-0.0300000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-11-0.0280000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-10-0.0060000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-07-0.0050000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-060.0020000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-050.0200000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-040.0280000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-08-030.0340000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-310.0200000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-300.0310000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-290.0670000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-280.0400000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-270.0430000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-240.0350000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-230.0350000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-220.0310000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-210.0290000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-200.0550000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-170.0500000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-160.0350000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-150.0320000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-140.0340000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-130.0450000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_slope_30_90SOXX2026-07-100.0210000000metric_daily——2026-09-15 12:172026-09-15 12:17