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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4c9-c13e-7613-a1dd-6cba9cee7750 | AAPL | 2026-09-21 12:25 | call_vertical_spread | 2 | 1 | 1000 | 1617000.00 | short | bid | 338.7850 | 0.4000 | ["335","345"] | ["0.2279","0.2234"] | ["339.97"] | ["SPHR"] | 335.0000 | 345.0000 | 25 | 25 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:26:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c47c-35af-7930-8838-55d6ca897b89 | AAPL | 2026-09-21 11:01 | call_diagonal_spread | 2 | 1 | 1221 | 4278384.00 | long | bid | 337.1450 | 1.3000 | ["320","325"] | ["0.3128","0.2407"] | [] | ["SPHR"] | 320.0000 | 325.0000 | 4 | 32 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:01:19Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c45d-cc87-7220-be12-c5e63f99e560 | AAPL | 2026-09-21 10:27 | other | 2 | 1 | 240 | 58800.00 | unknown | bid | 337.1900 | 0.3500 | ["240","430"] | ["0.3421","0.2497"] | [] | ["XBOX"] | 240.0000 | 430.0000 | 88 | 179 | false | true | true | true | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:27:59Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5f2-9637-7e50-a55c-f3e3dfdfc709 | AAPL | 2026-09-18 15:16 | call_diagonal_spread | 2 | 1 | 50 | 359550.00 | long | bid | 336.2900 | 1.4500 | ["300","310"] | ["6.2808","0.2664"] | [] | ["SPHR"] | 300.0000 | 310.0000 | 0 | 91 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:16:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a2-ad2f-7a33-9c52-5050006c425c | AAPL | 2026-09-18 13:48 | call_diagonal_spread | 2 | 1 | 150 | 292200.00 | short | bid | 335.4500 | 0.4500 | ["330","370"] | ["0.6610","0.2564"] | [] | ["SPHR"] | 330.0000 | 370.0000 | 0 | 182 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:49:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b598-8b6f-77e2-99dc-4fa87efc622a | AAPL | 2026-09-18 13:37 | call_diagonal_spread | 2 | 1 | 4469 | 67844379.00 | short | bid | 335.5300 | 1.9000 | ["270","290"] | ["0.3404","0.2959"] | [] | ["XBOX"] | 270.0000 | 290.0000 | 119 | 490 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:38:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58e-b7d0-7333-a1cc-26e64649e2d3 | AAPL | 2026-09-18 13:27 | call_diagonal_spread | 2 | 1 | 300 | 1602900.00 | short | bid | 335.3150 | 0.8500 | ["310","320"] | ["2.1637","0.2637"] | [] | ["SPHR"] | 310.0000 | 320.0000 | 0 | 91 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:27:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b589-e958-7391-903b-7ba810ddc00a | AAPL | 2026-09-18 13:21 | call_calendar | 2 | 1 | 149 | 1889171.00 | short | bid | 335.0200 | 1.1500 | ["275"] | ["2.6342"] | [] | ["SPHR"] | 275.0000 | 275.0000 | 0 | 119 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:21:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b586-91df-79d2-b7b4-10271dfd7781 | AAPL | 2026-09-18 13:18 | call_diagonal_spread | 2 | 1 | 150 | 1353300.00 | short | bid | 334.8900 | 0.7500 | ["290","300"] | ["3.5334","0.2827"] | [] | ["SPHR"] | 290.0000 | 300.0000 | 0 | 119 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:18:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b529-00c0-7e60-90e5-654cfd0ff137 | AAPL | 2026-09-18 11:35 | put_vertical_spread | 2 | 1 | 600 | 1707600.00 | unknown | bid | 334.8931 | 1.2500 | ["300","350"] | ["0.2832","0.2548"] | ["321.54"] | ["XPHO"] | 300.0000 | 350.0000 | 91 | 91 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:36:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d0-3260-7990-9dd6-d1078c1197b0 | AAPL | 2026-09-18 09:58 | call_diagonal_spread | 2 | 1 | 96 | 49152.00 | short | bid | 335.1130 | 0.4900 | ["335","340"] | ["0.1930","0.2055"] | [] | ["SPHR"] | 335.0000 | 340.0000 | 3 | 10 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afe0-3c6b-7332-9e07-21a56739ed40 | AAPL | 2026-09-17 10:58 | call_diagonal_spread | 2 | 1 | 56 | 655648.00 | short | bid | 332.8200 | 2.4500 | ["275","290"] | ["1.7545","0.2883"] | [] | ["SPHR"] | 275.0000 | 290.0000 | 1 | 211 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:58:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd6-8fdb-77a2-a306-4b35d9b4b12a | AAPL | 2026-09-17 10:47 | call_vertical_spread | 2 | 2 | 150 | 692250.00 | short | bid | 332.2800 | 0.9000 | ["300","370"] | ["0.2813","0.2466"] | ["335.45"] | ["ARCO"] | 300.0000 | 370.0000 | 92 | 92 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:48:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aab7-86db-7160-955b-5a9fc27c8bbb | AAPL | 2026-09-16 10:55 | strangle | 2 | 1 | 500 | 1285000.00 | short | bid | 333.9999 | 0.7000 | ["290","350"] | ["0.2989","0.2631"] | ["264.30","375.70"] | ["XPHO"] | 290.0000 | 350.0000 | 156 | 156 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:56:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a68f-b616-7ea2-9301-c27adaf90664 | AAPL | 2026-09-15 15:33 | put_vertical_spread | 2 | 1 | 200 | 151000.00 | short | bid | 330.1350 | 0.2500 | ["250","260"] | ["0.3300","0.3192"] | ["259.05"] | ["XBOX"] | 250.0000 | 260.0000 | 185 | 185 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:33:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d3-ad5e-7eb1-ab34-98d1a265197a | AAPL | 2026-09-15 12:08 | call_diagonal_spread | 2 | 1 | 75 | 603000.00 | long | bid | 329.8400 | 2.2000 | ["290","295"] | ["0.3078","0.3072"] | [] | ["SPHR"] | 290.0000 | 295.0000 | 31 | 45 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:08:44Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a14c-0af8-7452-a570-6644bc8f693f | AAPL | 2026-09-14 15:01 | straddle | 2 | 1 | 30 | 282600.00 | short | bid | 333.9250 | 2.5000 | ["330"] | ["0.2940"] | ["235.80","424.20"] | ["SPHR"] | 330.0000 | 330.0000 | 550 | 550 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:01:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090ea-7848-7f61-affb-127f2807b51d | AAPL | 2026-09-11 10:41 | call_diagonal_spread | 2 | 1 | 50 | 76700.00 | short | bid | 334.8600 | 0.4000 | ["327.5","330"] | ["0.5224","0.2689"] | [] | ["SPHR"] | 327.5000 | 330.0000 | 0 | 7 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:41:37Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b9-13c0-7713-aa34-1bc7ad1e97b1 | AAPL | 2026-09-11 09:47 | call_diagonal_spread | 2 | 1 | 400 | 656000.00 | short | bid | 331.9900 | 0.4000 | ["325","335"] | ["0.5310","0.2477"] | [] | ["SPHR"] | 325.0000 | 335.0000 | 0 | 35 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:47:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b7-1fc0-7e51-aa78-e7f0457fe5e5 | AAPL | 2026-09-11 09:45 | call_vertical_spread | 2 | 1 | 122 | 144692.00 | short | bid | 333.7150 | 0.2000 | ["330","335"] | ["0.2749","0.2764"] | ["332.66"] | ["SPHR"] | 330.0000 | 335.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:45:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c1e-36b1-73d1-942a-c481105f521b | AAPL | 2026-09-10 12:19 | strangle | 2 | 1 | 160 | 189680.00 | short | bid | 320.3800 | 0.3000 | ["290","360"] | ["0.2868","0.2627"] | ["278.14","371.86"] | ["XBOX"] | 290.0000 | 360.0000 | 99 | 99 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:20:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bee-9361-7bb1-9773-7e64b5a71a3f | AAPL | 2026-09-10 11:27 | call_calendar | 2 | 1 | 60 | 88800.00 | short | bid | 323.2995 | 0.2500 | ["320"] | ["0.3246"] | [] | ["SPHR"] | 320.0000 | 320.0000 | 1 | 22 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:28:15Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087a6-79d1-7d71-8700-bf93c619a18d | AAPL | 2026-09-09 15:30 | straddle | 2 | 2 | 110 | 1238600.00 | short | bid | 315.4800 | 4.3500 | ["350"] | ["0.2989"] | ["237.40","462.60"] | ["SPHR"] | 350.0000 | 350.0000 | 828 | 828 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:30:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08684-ae50-72e2-867f-4a460b53bacc | AAPL | 2026-09-09 10:13 | ratio_risk_reversal | 2 | 1 | 360 | 164700.00 | long | bid | 316.0650 | 0.4100 | ["240","420"] | ["0.3254","0.2723"] | ["421.42"] | ["XPHO"] | 240.0000 | 420.0000 | 191 | 191 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:14:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0814e-6c00-70d2-8db1-de28d11a6be0 | AAPL | 2026-09-08 09:56 | put_vertical_spread | 2 | 1 | 100 | 276400.00 | short | bid | 317.2400 | 0.9500 | ["290","295"] | ["0.2896","0.2866"] | ["293.50"] | ["SPHR"] | 290.0000 | 295.0000 | 220 | 220 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:56:37Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d95-59e5-7a83-b4a5-1313ec297d53 | AAPL | 2026-09-04 14:01 | call_calendar | 2 | 1 | 79 | 809750.00 | short | bid | 320.9700 | 2.0000 | ["270"] | ["3.2136"] | [] | ["SPHR"] | 270.0000 | 270.0000 | 0 | 7 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:01:50Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |