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 = max_pain_expiry_dte×sorted by as_of_date ↑×

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_expiry_dteSOXX2026-06-1730.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-1829.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-2225.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-2324.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-2423.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-2522.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-2621.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-2918.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-06-3017.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-0116.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-0215.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-0611.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-0710.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-089.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-098.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-107.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-1339.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-1438.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-1537.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-1636.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-1735.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2032.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2131.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2230.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2329.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2428.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2725.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2824.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-2923.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-3022.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-07-3121.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-0318.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-0417.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-0516.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-0615.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-0714.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-1011.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-1110.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-129.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-138.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-147.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-1732.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-1831.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-1930.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-2029.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-2128.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-2425.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-2524.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-2623.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-2722.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17