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×

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-09-1729.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-1630.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-1531.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-1432.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-117.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-108.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-099.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-0810.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_expiry_dteSOXX2026-09-0414.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-09-0315.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-09-0216.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-09-0117.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-3118.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_expiry_dteSOXX2026-08-2821.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
max_pain_expiry_dteSOXX2026-08-2623.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-2425.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-2029.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-1831.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-147.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-129.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-1011.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-0615.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-0417.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-07-3121.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-2923.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-2725.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-2329.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-2131.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-1735.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-1537.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-1339.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-098.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17