Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b600-c707-78f1-8d57-99d7b1d67682 | BSX | 2026-09-18 15:31 | put_diagonal_spread | 2 | 1 | 150 | 498600.00 | short | bid | 43.4350 | 1.7000 | ["50","70"] | ["0.6296","0.6491"] | [] | ["XPHO"] | 50.0000 | 70.0000 | 7 | 119 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:31:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b5-3fab-75b1-b617-30ed84a0ee64 | BSX | 2026-09-17 14:51 | other | 7 | 1 | 3393 | 4341150.00 | unknown | — | 43.1550 | 8.4500 | ["46","46.5","48.5","50","55","77.5","82.5"] | ["0.9625","1.3634","1.6475","1.9557","2.8579","0.8500","1.0352"] | [] | ["XBOX"] | 46.0000 | 82.5000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:51:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a5-900b-7f01-967e-a9075e1ebe27 | BSX | 2026-09-17 14:33 | other | 4 | 1 | 67 | 122320.00 | unknown | — | 43.2950 | 5.0000 | ["49","49.5","50","55"] | ["3.2953","2.8567","1.7300","0.6010"] | [] | ["XBOX"] | 49.0000 | 55.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a1-abf3-7ca1-9669-7ef6fd9c1a58 | BSX | 2026-09-17 14:29 | put_vertical_spread | 2 | 1 | 2300 | 4278000.00 | unknown | — | 43.3450 | 1.2000 | ["50","55"] | ["1.8811","2.7785"] | [] | ["XBOX"] | 50.0000 | 55.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:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba5-329b-7112-99d7-a4985b326f94 | BSX | 2026-09-16 15:15 | put_vertical_spread | 2 | 1 | 1820 | 3567200.00 | unknown | — | 44.1000 | 5.5000 | ["50","55"] | ["2.6119","3.5200"] | [] | ["XBOX"] | 50.0000 | 55.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:15:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a091e9-2780-7093-bd99-1a54f307709e | BSX | 2026-09-11 15:19 | other | 3 | 1 | 362 | 2683720.00 | unknown | — | 42.9850 | 5.4000 | ["75","85","87.5"] | ["0.6248","0.9232","1.0705"] | [] | ["XBOX"] | 75.0000 | 87.5000 | 126 | 126 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:20:06Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ca8-b3d0-78d3-b27f-148bfcfd2da3 | BSX | 2026-09-10 14:50 | other | 2 | 1 | 356 | 1014600.00 | unknown | — | 43.1800 | 2.0000 | ["47","67.5"] | ["1.3623","0.6658"] | [] | ["XBOX"] | 47.0000 | 67.5000 | 1 | 99 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:51:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca8-5228-7ad3-8d3d-cf5293f0ba8a | BSX | 2026-09-10 14:50 | other | 3 | 1 | 2451 | 5304000.00 | unknown | — | 43.1550 | 3.2000 | ["47","48","75"] | ["1.3134","1.5390","0.7110"] | [] | ["XBOX"] | 47.0000 | 75.0000 | 1 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:51:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca8-3ab9-7320-b107-f9dfdc77ebf6 | BSX | 2026-09-10 14:50 | other | 2 | 1 | 4834 | 7734400.00 | unknown | — | 43.1550 | 1.6000 | ["47","55"] | ["1.3134","1.0567"] | [] | ["XBOX"] | 47.0000 | 55.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:51:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c9c-3498-73d2-abb5-58f64a7f698a | BSX | 2026-09-10 14:37 | other | 5 | 1 | 554 | 941930.00 | unknown | — | 43.1950 | 6.9000 | ["49","49.5","51","55","59"] | ["1.5614","2.7288","3.8693","1.1929","4.9024"] | [] | ["XBOX"] | 49.0000 | 59.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:37:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08274-42a8-7d02-852d-1c81b7781063 | BSX | 2026-09-08 15:17 | other | 5 | 1 | 226 | 2867980.00 | unknown | — | 45.2000 | 13.2000 | ["77.5","85","87.5","90","95"] | ["0.8154","0.8727","0.9721","1.0296","1.2029"] | [] | ["XBOX"] | 77.5000 | 95.0000 | 101 | 129 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:18:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd8-5a3d-7762-938e-60e171dadab2 | BSX | 2026-09-04 15:14 | other | 5 | 1 | 226 | 2715220.00 | unknown | — | 48.0050 | 12.7000 | ["77.5","85","87.5","90","95"] | ["0.8158","0.5503","0.5253","0.7569","0.5606"] | [] | ["XBOX"] | 77.5000 | 95.0000 | 105 | 133 | false | false | true | 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 |
| 01a06dd4-eb55-7ba1-bc0c-94f25f4a39a0 | BSX | 2026-09-04 15:11 | other | 5 | 1 | 150 | 1845808.00 | unknown | — | 47.9950 | 12.7000 | ["77.5","85","87.5","90","95"] | ["0.5504","0.7331","0.7919","0.9402","0.9241"] | [] | ["XPHO"] | 77.5000 | 95.0000 | 105 | 133 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:11:41Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |