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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 01a0ab85-98c3-71b0-9e2f-7a229cf8cd48 | AAPL | 2026-09-16 14:40 | call_calendar | 2 | 1 | 80 | 948080.00 | short | ask | 334.0300 | 4.9500 | ["275"] | ["1.0349"] | [] | ["SPHR"] | 275.0000 | 275.0000 | 2 | 30 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:40:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 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 |
| 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 |
| 01a08160-bf68-7063-ace0-0cace3167645 | AAPL | 2026-09-08 10:16 | ratio_risk_reversal | 2 | 1 | 360 | 177120.00 | short | ask | 315.5700 | 0.8400 | ["240","420"] | ["0.3259","0.2671"] | ["420.60"] | ["AMXO"] | 240.0000 | 420.0000 | 192 | 192 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:16:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |