Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_sidetext | underlying_pricenumeric | bid_ask_spreadnumeric | strikesjsonb | ivsjsonb | breakevensjsonb | uniq_exchangesjsonb | min_strikenumeric | max_strikenumeric | min_dteinteger | max_dteinteger | all_opening_legsboolean | all_otmboolean | diff_expirationsboolean | diff_strikesboolean | diff_typesboolean | codetext | kept_bytext | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b038-ff13-70e2-bb0d-d4371790f182 | SPX | 2026-09-17 12:35 | strangle | 2 | 1 | 74 | 38110.00 | unknown | — | 7632.9500 | 0.3500 | ["6675","8400"] | ["0.2847","0.1435"] | [] | ["XCBO"] | 6675.0000 | 8400.0000 | 22 | 22 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:35:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab5a-4ad3-7cf2-be09-c7eb3386182c | SPX | 2026-09-16 13:53 | strangle | 2 | 1 | 50 | 85000.00 | long | ask | 7608.0200 | 0.2000 | ["7560","7650"] | ["0.5532","0.4990"] | ["7543","7667.00"] | ["XCBO"] | 7560.0000 | 7650.0000 | 0 | 0 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:54:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa95-aecb-7d72-b009-fc80411a26d6 | SPX | 2026-09-16 10:18 | strangle | 2 | 1 | 5 | 59625.00 | unknown | — | 7605.9500 | 2.2000 | ["7540","7590"] | ["0.2093","0.1750"] | [] | ["XCBO"] | 7540.0000 | 7590.0000 | 2 | 2 | false | false | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:19:06Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5c3-6566-75b2-ae8e-d5921ec230c1 | SPX | 2026-09-15 11:50 | strangle | 2 | 1 | 50 | 75500.00 | long | ask | 7585.5000 | 0.5500 | ["7450","7750"] | ["0.2125","0.1395"] | ["7434.90","7765.10"] | ["XCBO"] | 7450.0000 | 7750.0000 | 3 | 3 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:50:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a566-4976-7883-9ade-f0734ef0d560 | VIX | 2026-09-15 10:08 | strangle | 2 | 1 | 200 | 51600.00 | short | bid | 17.1600 | 0.0900 | ["17","19"] | ["0.4544","1.1142"] | ["14.42","21.58"] | ["XCBO"] | 17.0000 | 19.0000 | 36 | 36 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:09:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a55e-a085-7ae0-ab0e-6f7c73d60e25 | SPX | 2026-09-15 10:00 | strangle | 2 | 1 | 50 | 67000.00 | unknown | — | 7605.3800 | 0.6000 | ["3000","10000"] | ["0.4973","0.1258"] | [] | ["XCBO"] | 3000.0000 | 10000.0000 | 275 | 275 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:01:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a183-2471-7df1-b1ac-b2e7514ca2aa | SPX | 2026-09-14 16:01 | strangle | 2 | 1 | 88 | 61688.00 | long | ask | 7619.9500 | 0.4500 | ["7375","7945"] | ["0.2285","0.1535"] | ["7367.99","7952.01"] | ["XCBO"] | 7375.0000 | 7945.0000 | 4 | 4 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T20:03:17Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a086a9-2258-7f50-af92-8b30a9d7b559 | SPX | 2026-09-09 10:53 | strangle | 2 | 1 | 52 | 70200.00 | long | ask | 7651.3300 | 0.3000 | ["6925","8350"] | ["0.2317","0.1241"] | ["6911.50","8363.50"] | ["XCBO"] | 6925.0000 | 8350.0000 | 30 | 30 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:53:52Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |