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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b609-46cf-7872-83b0-9cf23ec5e35a | SPX | 2026-09-18 15:40 | strangle | 2 | 1 | 115 | 12992240.00 | unknown | ask | 7640.9200 | 2.6000 | ["7000","8000"] | ["0.1865","0.1273"] | ["7700.29"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d7-a3c7-7c80-9a94-bf04ac3ac06e | SPX | 2026-09-18 14:46 | strangle | 2 | 1 | 3609 | 407257605.00 | unknown | bid | 7641.2000 | 6.6000 | ["7000","8000"] | ["0.1768","0.1322"] | ["7693.38"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:46:47Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d7-9fdf-70e3-adb7-3c5c8c00d000 | SPX | 2026-09-18 14:46 | strangle | 2 | 1 | 2000 | 225690000.00 | unknown | bid | 7641.2000 | 5.4500 | ["7000","8000"] | ["0.1768","0.1322"] | ["7693.38"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:46:47Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53d-bd58-7710-ab8b-fe20a8d66b78 | SPX | 2026-09-18 11:58 | strangle | 2 | 1 | 75 | 8466750.00 | unknown | bid | 7620.0800 | 2.9000 | ["7000","8000"] | ["0.1843","0.1305"] | ["7680.95"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:59:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0fa-1c93-75b0-9113-f01777e4f44c | SPX | 2026-09-17 16:06 | strangle | 2 | 1 | 200 | 1693000.00 | unknown | — | 7637.7600 | 1.4000 | ["7000","8000"] | ["0.2035","0.1135"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T20:07:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0fa-1c93-75b0-9113-f00d0337c672 | SPX | 2026-09-17 16:06 | strangle | 2 | 1 | 200 | 21533000.00 | unknown | — | 7637.7600 | 3.3000 | ["7000","8000"] | ["0.1921","0.1203"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T20:07:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0dd-e9d3-7fd1-a3e2-a88fb8e0f41a | SPX | 2026-09-17 15:35 | strangle | 2 | 1 | 11 | 865667.00 | unknown | — | 7640.0300 | 1.7000 | ["6000","7000"] | ["0.3003","0.1878"] | [] | ["XCBO"] | 6000.0000 | 7000.0000 | 92 | 92 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:35:51Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d4-8393-7e20-8f72-d052fa0287be | SPX | 2026-09-17 15:25 | strangle | 2 | 1 | 450 | 53419500.00 | unknown | — | 7637.9300 | 2.7000 | ["7000","8000"] | ["0.1917","0.1283"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 120 | 120 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:25:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 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 |
| 01a0b02d-bc43-70c2-9a75-1f3e67fa61d3 | SPX | 2026-09-17 12:22 | strangle | 2 | 1 | 15 | 3097110.00 | unknown | — | 7635.6100 | 4.0000 | ["6000","7000"] | ["0.2269","0.2030"] | [] | ["XCBO"] | 6000.0000 | 7000.0000 | 273 | 273 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:23:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe9-aa7b-71f1-828e-b9cdcc8deba0 | SPX | 2026-09-17 11:08 | strangle | 2 | 1 | 150 | 16167750.00 | unknown | — | 7617.8800 | 3.2000 | ["7000","8000"] | ["0.1956","0.1214"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:09:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afdc-aa5b-7ca0-9666-531dd86f7929 | SPX | 2026-09-17 10:54 | strangle | 2 | 1 | 198 | 712404.00 | unknown | — | 7617.4900 | 0.3000 | ["7605","7630"] | ["0.1800","0.1070"] | [] | ["XCBO"] | 7605.0000 | 7630.0000 | 0 | 0 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:54:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd5-093b-7682-b0f0-05c04d1a68d0 | SPX | 2026-09-17 10:46 | strangle | 2 | 1 | 120 | 756360.00 | unknown | — | 7628.3000 | 1.4000 | ["7410","7580"] | ["0.2881","0.1977"] | [] | ["XCBO"] | 7410.0000 | 7580.0000 | 1 | 1 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:46:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcd-b253-7c42-9320-62d30d698474 | VIAV | 2026-09-17 10:38 | strangle | 2 | 3 | 150 | 108000.00 | unknown | — | 35.2700 | 1.0000 | ["30","42"] | ["0.7839","0.7442"] | [] | ["XCBO"] | 30.0000 | 42.0000 | 120 | 120 | true | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:38:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afaa-28ac-77b0-8c27-5c292e88b884 | SPX | 2026-09-17 09:59 | strangle | 2 | 1 | 100 | 10776000.00 | unknown | — | 7621.2300 | 4.3000 | ["7000","8000"] | ["0.1947","0.1215"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:59:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afaa-28ac-77b0-8c27-5c11d6f56a43 | SPX | 2026-09-17 09:59 | strangle | 2 | 1 | 100 | 10776000.00 | unknown | — | 7621.2300 | 4.3000 | ["7000","8000"] | ["0.1947","0.1215"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:59:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa9-9ff3-7360-8566-2f56a8fc5c65 | SPX | 2026-09-17 09:58 | strangle | 2 | 1 | 300 | 32326500.00 | unknown | — | 7621.6400 | 4.3000 | ["7000","8000"] | ["0.1934","0.1223"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:58:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa9-9ff3-7360-8566-2f43dc2e880a | SPX | 2026-09-17 09:58 | strangle | 2 | 1 | 300 | 32326500.00 | unknown | — | 7621.6400 | 4.3000 | ["7000","8000"] | ["0.1934","0.1223"] | [] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:58:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa9c-4262-7050-83d0-dbc34b18bf8e | SPX | 2026-09-16 10:25 | strangle | 2 | 1 | 26 | 4377230.00 | unknown | — | 7600.4600 | 21.1000 | ["6000","7000"] | ["0.3396","0.2140"] | [] | ["XCBO"] | 6000.0000 | 7000.0000 | 51 | 51 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:26:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa99-8b13-7340-9837-8b756a522a05 | SPX | 2026-09-16 10:23 | strangle | 2 | 1 | 121 | 19775635.00 | unknown | — | 7601.8700 | 20.4500 | ["6000","7000"] | ["0.4380","0.2324"] | [] | ["XCBO"] | 6000.0000 | 7000.0000 | 23 | 23 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:23:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa99-8b13-7340-9837-8b5cf0d8107b | SPX | 2026-09-16 10:23 | strangle | 2 | 1 | 121 | 7711935.00 | unknown | — | 7601.8700 | 17.9000 | ["6000","7000"] | ["0.4138","0.2396"] | [] | ["XCBO"] | 6000.0000 | 7000.0000 | 23 | 23 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:23:11Z"} | 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 |
| 01a0a5f1-7276-7740-afbd-3e38807f6d29 | RUT | 2026-09-15 12:40 | strangle | 2 | 2 | 300 | 498600.00 | unknown | — | 2869.2646 | 0.6000 | ["2750","3020"] | ["0.2445","0.1566"] | [] | ["XCBO"] | 2750.0000 | 3020.0000 | 15 | 15 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:41:54Z"} | 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 |
| 01a09188-0068-7c20-922a-5d8bc14b1859 | SPX | 2026-09-11 13:33 | strangle | 2 | 1 | 70 | 11929750.00 | unknown | — | 7674.3500 | 17.9000 | ["6000","7000"] | ["0.4630","0.2224"] | [] | ["XCBO"] | 6000.0000 | 7000.0000 | 28 | 28 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:34:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0868b-3a18-7c10-9f47-2f3b79aaa51b | VIX | 2026-09-09 10:21 | strangle | 2 | 1 | 4500 | 2133000.00 | unknown | — | 16.2200 | 0.2100 | ["20","30"] | ["0.5626","1.0479"] | [] | ["XCBO"] | 20.0000 | 30.0000 | 189 | 189 | true | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:21:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |