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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d64-dfbd-71e0-b287-5ea91d200ddf | IBM | 2026-09-04 13:08 | straddle | 2 | 2 | 250 | 2150000.00 | short | bid | 235.3500 | 6.9000 | ["290"] | ["0.3827"] | ["204","376.00"] | ["AMXO"] | 290.0000 | 290.0000 | 378 | 378 | true | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:08:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd3-3da5-7581-8fe9-f9d1848e800b | IBM | 2026-09-04 15:09 | other | 4 | 1 | 210 | 2058700.00 | unknown | — | 234.5600 | 11.7000 | ["275","280","290","300"] | ["0.6855","0.6330","0.7814","0.8153"] | [] | ["XPHO"] | 275.0000 | 300.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:09:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd7-f895-75d3-948c-c4e51e1c16b2 | IBM | 2026-09-04 15:14 | other | 3 | 1 | 198 | 2106540.00 | unknown | — | 234.2500 | 7.1000 | ["280","290","300"] | ["0.5908","0.7436","0.7661"] | [] | ["XBOX"] | 280.0000 | 300.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:14:49Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0826f-7fe8-7bc3-97ad-8b6580c6ea8f | IBM | 2026-09-08 15:12 | put_vertical_spread | 2 | 1 | 57 | 653220.00 | unknown | — | 232.0100 | 3.8000 | ["280","300"] | ["0.8382","1.0662"] | [] | ["XBOX"] | 280.0000 | 300.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:12:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08275-0dc8-7363-be7e-8fcee7c8cdad | IBM | 2026-09-08 15:18 | put_vertical_spread | 2 | 1 | 70 | 799400.00 | unknown | — | 232.5500 | 2.2500 | ["280","300"] | ["0.8573","0.8458"] | [] | ["XBOX"] | 280.0000 | 300.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:18:37Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08c9c-e078-7520-9329-5a3718cf3b29 | IBM | 2026-09-10 14:38 | put_diagonal_spread | 2 | 1 | 24 | 381600.00 | unknown | — | 232.0318 | 4.2500 | ["300","325"] | ["1.0328","0.5073"] | [] | ["XBOX"] | 300.0000 | 325.0000 | 8 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:38:36Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb6-2151-7871-9a28-ed4db62f5ff5 | IBM | 2026-09-10 15:05 | other | 4 | 1 | 72 | 1029456.00 | unknown | — | 233.1300 | 11.8000 | ["280","290","300","325"] | ["0.9901","1.1519","1.2371","0.4276"] | [] | ["XBOX"] | 280.0000 | 325.0000 | 8 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:06:06Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cdc-4308-7680-b7cd-916a57c7e4a6 | IBM | 2026-09-10 15:47 | other | 3 | 1 | 200 | 2390000.00 | unknown | — | 233.1700 | 9.1000 | ["280","290","300"] | ["0.6951","0.8035","0.9062"] | [] | ["XPHO"] | 280.0000 | 300.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:47:30Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091e5-37b1-7b41-a5fd-461bbab15f5d | IBM | 2026-09-11 15:15 | put_vertical_spread | 2 | 1 | 68 | 711960.00 | unknown | — | 241.8400 | 5.6500 | ["290","300"] | ["1.0836","1.2218"] | [] | ["XBOX"] | 290.0000 | 300.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:15:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e8-6048-7d23-a36b-f17c411b06c2 | IBM | 2026-09-11 15:18 | put_vertical_spread | 2 | 1 | 76 | 795720.00 | unknown | — | 241.9900 | 5.2500 | ["290","300"] | ["1.0737","1.2115"] | [] | ["XBOX"] | 290.0000 | 300.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:18:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a69b-fab6-7e00-951b-ea6a8af8ea97 | IBM | 2026-09-15 15:47 | strangle | 2 | 2 | 200 | 227000.00 | long | ask | 247.7600 | 0.6000 | ["240","260"] | ["0.3359","0.3469"] | ["228.65","271.35"] | ["AMXO"] | 240.0000 | 260.0000 | 31 | 31 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:47:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0b0b0-ea4b-78c2-be87-4b280fddccc2 | IBM | 2026-09-17 14:46 | put_vertical_spread | 2 | 1 | 93 | 1029510.00 | unknown | — | 238.3700 | 6.7000 | ["290","300"] | ["3.0032","3.3593"] | [] | ["XBOX"] | 290.0000 | 300.0000 | 1 | 1 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:46:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b2-e61b-72e3-afde-cfe8744896a5 | IBM | 2026-09-17 14:48 | put_ladder | 7 | 1 | 796 | 4580120.00 | unknown | — | 238.5600 | 19.6500 | ["252.5","260","265","270","275","280","300"] | ["1.1990","1.6273","2.0190","2.0162","2.1788","2.6806","3.4086"] | [] | ["XBOX"] | 252.5000 | 300.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ea-1702-76b3-bd76-659e7b7b0bd7 | IBM | 2026-09-17 15:48 | put_ladder | 5 | 1 | 120 | 2034296.00 | unknown | — | 237.8200 | 15.3000 | ["270","275","280","290","300"] | ["1.6277","2.0893","2.4312","2.7953","3.0343"] | [] | ["XPHO"] | 270.0000 | 300.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:48:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ec-ca6b-78b3-90e7-c1e7c3b3d968 | IBM | 2026-09-17 15:51 | put_vertical_spread | 2 | 1 | 50 | 188100.00 | short | bid | 237.9700 | 2.6500 | ["220","230"] | ["0.4171","0.4135"] | ["225.80"] | ["SPHR"] | 220.0000 | 230.0000 | 183 | 183 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:51:53Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |