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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4fd-2a18-70d2-97f0-be7e44ad149e | AAPL | 2026-09-18 10:48 | other | 4 | 1 | 1000 | 575000.00 | unknown | ask | 333.2128 | 0.2300 | ["335","340"] | ["0.2863","0.3221"] | [] | ["XBOX"] | 335.0000 | 340.0000 | 0 | 7 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:48:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b4-f573-71d3-acbc-9a96962e1372 | AAPL | 2026-09-17 14:50 | other | 4 | 1 | 99 | 349806.00 | unknown | — | 336.2200 | 7.4000 | ["347.5","350","360","400"] | ["0.5096","0.7896","1.0116","0.2632"] | [] | ["XBOX"] | 347.5000 | 400.0000 | 1 | 36 | 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 |
| 01a0b019-c6e3-7e91-8c4a-874e7ef3e7d8 | AAPL | 2026-09-17 12:01 | other | 3 | 1 | 240 | 378360.00 | unknown | — | 335.2050 | 0.8600 | ["340","380","450"] | ["0.2534","0.2567","0.2508"] | [] | ["XPHO"] | 340.0000 | 450.0000 | 92 | 183 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:01:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aab4-3b1b-79c0-a9e9-a741c8caa71c | AAPL | 2026-09-16 10:52 | other | 2 | 1 | 360 | 402000.00 | unknown | — | 333.8550 | 0.4000 | ["290","380"] | ["0.2980","0.2569"] | [] | ["AMXO"] | 290.0000 | 380.0000 | 93 | 184 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:52:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69d-6216-77d0-834d-10bbd8a8bdee | AAPL | 2026-09-15 15:48 | other | 3 | 3 | 150 | 739000.00 | unknown | — | 330.1300 | 1.8500 | ["250","270","300"] | ["0.3081","0.2973","0.2890"] | [] | ["AMXO"] | 250.0000 | 300.0000 | 493 | 822 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:49:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b7-8e26-7553-bf7a-4d1e67d40b12 | AAPL | 2026-09-15 11:37 | other | 3 | 2 | 280 | 1239000.00 | unknown | — | 329.6300 | 0.8500 | ["290","320","340"] | ["0.2965","0.2735","0.2707"] | [] | ["AMXO"] | 290.0000 | 340.0000 | 94 | 185 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:38:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0fc-be30-75e0-8c65-28371d524059 | AAPL | 2026-09-14 13:35 | other | 2 | 1 | 240 | 195040.00 | unknown | — | 334.3700 | 0.3600 | ["360","450"] | ["0.2632","0.2620"] | [] | ["XPHO"] | 360.0000 | 450.0000 | 67 | 186 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:35:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091f0-1cc0-7982-b933-849b75ef912f | AAPL | 2026-09-11 15:27 | other | 4 | 1 | 2434 | 5786036.00 | unknown | — | 332.5500 | 0.5000 | ["295","310","330","345"] | ["0.4458","0.2603","0.2442","0.2400"] | [] | ["XBOX"] | 295.0000 | 345.0000 | 7 | 35 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:27:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0915c-e928-7953-b1ca-760a154ff93c | AAPL | 2026-09-11 12:46 | other | 3 | 1 | 100 | 41600.00 | unknown | — | 334.2200 | 0.2300 | ["300","310","330"] | ["0.3943","0.3312","0.2452"] | [] | ["XBOX"] | 300.0000 | 330.0000 | 7 | 35 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:47:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09150-d368-7870-ba64-7c1225e89ced | AAPL | 2026-09-11 12:33 | other | 2 | 2 | 360 | 1133460.00 | unknown | — | 334.2700 | 1.1300 | ["360","450"] | ["0.2663","0.2682"] | [] | ["AMXO"] | 360.0000 | 450.0000 | 70 | 189 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:33:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce6-bab9-7443-9f67-cbd7d16cec52 | AAPL | 2026-09-10 15:58 | other | 2 | 1 | 60 | 189000.00 | unknown | — | 326.2800 | 0.6000 | ["330","335"] | ["0.2803","0.2727"] | [] | ["XBOX"] | 330.0000 | 335.0000 | 71 | 99 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:58:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08793-8e10-7703-b49b-14eb116a5f9c | AAPL | 2026-09-09 15:09 | other | 4 | 1 | 60 | 120180.00 | unknown | — | 315.5045 | 1.4200 | ["315","322.5","330"] | ["0.5788","1.1233","0.2565"] | [] | ["SPHR"] | 315.0000 | 330.0000 | 0 | 44 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:10:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06dea-5f86-7cf1-8997-ef90471477a4 | AAPL | 2026-09-04 15:34 | other | 2 | 1 | 68 | 48076.00 | unknown | — | 321.6800 | 0.3200 | ["335","345"] | ["0.2479","0.2431"] | [] | ["XBOX"] | 335.0000 | 345.0000 | 21 | 49 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:34:46Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |