Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08155-0768-79f1-8aa4-1a2c0fadacea | VLO | 2026-09-08 10:03 | other | 2 | 1 | 60 | 151800.00 | unknown | — | 381.4950 | 2.7000 | ["380","410"] | ["0.4738","0.4732"] | [] | ["ARCO"] | 380.0000 | 410.0000 | 38 | 38 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:04:12Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08165-43a8-7aa3-9684-82ac00ce6a13 | VLO | 2026-09-08 10:21 | other | 4 | 2 | 4 | 102456.00 | unknown | — | 380.2600 | 7.7000 | ["210","300","330","350"] | ["1.8296","0.4847","0.4819","0.4565"] | [] | ["XISX","XPHO"] | 210.0000 | 350.0000 | 10 | 282 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:21:32Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08275-d118-70d1-ac32-6fd6b3451ac5 | VLO | 2026-09-08 15:19 | other | 2 | 1 | 14 | 140812.00 | unknown | — | 383.1150 | 3.5000 | ["310","330"] | ["0.5796","0.5245"] | [] | ["C2OX"] | 310.0000 | 330.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:19:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0866d-ea32-7d23-bcf7-eeb312d56808 | VLO | 2026-09-09 09:49 | other | 2 | 1 | 8 | 120440.00 | unknown | — | 382.8500 | 6.8000 | ["350"] | ["0.4563"] | [] | ["XPHO"] | 350.0000 | 350.0000 | 191 | 281 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:49:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086bd-8518-70c0-9264-5818f8f8f42f | VLO | 2026-09-09 11:16 | other | 3 | 1 | 20 | 122140.00 | unknown | — | 382.2500 | 2.5000 | ["340","360","380"] | ["0.4871","0.4856","0.4865"] | [] | ["XISX"] | 340.0000 | 380.0000 | 128 | 128 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:16:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08789-4158-7593-bec8-aa9e68cf57f1 | VLO | 2026-09-09 14:58 | other | 2 | 1 | 990 | 140000.00 | unknown | — | 386.4900 | 1.0500 | ["340","345"] | ["0.5248","0.5159"] | [] | ["XPHO"] | 340.0000 | 345.0000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:59:01Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08b89-f979-7d40-b41f-13de03a1b099 | VLO | 2026-09-10 09:37 | other | 2 | 1 | 14 | 135380.00 | unknown | — | 387.6950 | 5.6000 | ["400"] | ["0.4688"] | [] | ["XMIO"] | 400.0000 | 400.0000 | 99 | 280 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:38:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08baa-cfb8-73f0-ae22-d4b4549d9fe7 | VLO | 2026-09-10 10:13 | other | 4 | 2 | 12 | 115592.00 | unknown | — | 385.1100 | 8.6000 | ["330","370","375","380"] | ["0.5585","0.4826","0.6595","0.4928"] | [] | ["XMIO","XPHO"] | 330.0000 | 380.0000 | 1 | 36 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:13:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bae-a819-7100-97fb-6ca786451817 | VLO | 2026-09-10 10:17 | other | 3 | 1 | 20 | 146150.00 | unknown | — | 384.2950 | 9.2000 | ["340","350","360"] | ["0.5762","0.5537","0.5173"] | [] | ["XCBO"] | 340.0000 | 360.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:18:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a090cf-5ec8-7290-8374-cb1bec253f28 | VLO | 2026-09-11 10:11 | other | 4 | 2 | 15 | 233399.00 | unknown | — | 394.7300 | 9.0500 | ["320","385","395"] | ["0.7634","0.7341","0.6629"] | [] | ["XISX","XPHO"] | 320.0000 | 395.0000 | 0 | 35 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:12:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a02d-b630-7720-b9e6-12c8291fe01d | VLO | 2026-09-14 09:49 | other | 2 | 1 | 10 | 216400.00 | unknown | — | 397.3450 | 6.2000 | ["290","340"] | ["1.6102","0.4736"] | [] | ["XISX"] | 290.0000 | 340.0000 | 4 | 368 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:49:15Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a044-2460-7970-88f4-9e0c99b20478 | VLO | 2026-09-14 10:13 | other | 2 | 1 | 10 | 139150.00 | unknown | — | 399.3050 | 5.9000 | ["330","350"] | ["0.7260","0.4932"] | [] | ["ARCO"] | 330.0000 | 350.0000 | 4 | 95 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:13:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05d-4210-79e0-a6b6-6d9b0e9a5d1e | VLO | 2026-09-14 10:40 | other | 2 | 1 | 2 | 103030.00 | unknown | — | 396.2000 | 8.3000 | ["140"] | ["1.0721"] | [] | ["AMXO"] | 140.0000 | 140.0000 | 95 | 123 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:41:29Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a152-0a20-70d3-a32a-d07d187c39e6 | VLO | 2026-09-14 15:08 | other | 2 | 1 | 900 | 5436000.00 | unknown | — | 378.2900 | 6.8000 | ["300","410"] | ["0.4909","0.5075"] | [] | ["SPHR"] | 300.0000 | 410.0000 | 95 | 276 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:08:22Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a154-ec68-75e0-b29a-cba8c59c6920 | VLO | 2026-09-14 15:11 | other | 2 | 1 | 1080 | 6497280.00 | unknown | — | 378.4000 | 5.0000 | ["300","410"] | ["0.4898","0.5060"] | [] | ["SPHR"] | 300.0000 | 410.0000 | 95 | 276 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:11:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a552-f43e-7e52-b4cd-f2e913776ce2 | VLO | 2026-09-15 09:47 | other | 4 | 1 | 9 | 247788.00 | unknown | — | 390.2900 | 12.4000 | ["270","310","460","500"] | ["0.4962","0.4721","0.4885","0.4846"] | [] | ["XMIO"] | 270.0000 | 500.0000 | 122 | 185 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:47:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a555-e23e-78e3-bf41-8c4b155908e9 | VLO | 2026-09-15 09:51 | other | 4 | 1 | 10 | 161190.00 | unknown | — | 390.8200 | 13.4000 | ["355","357.5","360"] | ["0.5178","0.5515","0.5101"] | [] | ["XCBO"] | 355.0000 | 360.0000 | 3 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:51:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa8d-c75b-7613-a7d4-c612e3c99eb5 | VLO | 2026-09-16 10:10 | other | 4 | 1 | 20 | 426320.00 | unknown | — | 394.0100 | 11.7000 | ["350","355","360"] | ["0.5157","0.8743","0.6825"] | [] | ["XCBO"] | 350.0000 | 360.0000 | 2 | 121 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:10:36Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa91-4db3-7a40-ad9f-31de92d2ec26 | VLO | 2026-09-16 10:14 | other | 4 | 2 | 10 | 180450.00 | unknown | — | 394.5600 | 12.1000 | ["362.5","365","370","380"] | ["0.8477","0.8164","0.5095","0.5161"] | [] | ["XMIO"] | 362.5000 | 380.0000 | 2 | 121 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:14:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3a-1c8b-7480-8a33-e618c781d235 | VLO | 2026-09-16 13:18 | other | 4 | 1 | 32 | 123936.00 | unknown | — | 405.9968 | 5.8000 | ["395","397.5","407.5","410"] | ["0.6224","0.5947","0.5462","0.5452"] | [] | ["ARCO"] | 395.0000 | 410.0000 | 2 | 9 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:19:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0af91-0713-7c51-ae80-bf905fd3522a | VLO | 2026-09-17 09:31 | other | 4 | 1 | 20 | 560242.00 | unknown | — | 400.0200 | 14.8000 | ["250","260","270","380"] | ["5.3254","4.9452","4.6867","0.9346"] | [] | ["XISX"] | 250.0000 | 380.0000 | 1 | 1 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:32:01Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0afed-7723-78c2-aa38-1758a48e2d04 | VLO | 2026-09-17 11:12 | other | 4 | 1 | 10 | 116860.00 | unknown | — | 407.4000 | 10.0000 | ["370","385","405","435"] | ["0.5416","0.5174","0.5266","0.5200"] | [] | ["XISX"] | 370.0000 | 435.0000 | 15 | 36 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:13:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afef-8293-79a1-a5e4-5bd275797af6 | VLO | 2026-09-17 11:15 | other | 4 | 1 | 10 | 116620.00 | unknown | — | 407.3700 | 9.4000 | ["370","385","405","435"] | ["0.5294","0.5217","0.5222","0.5206"] | [] | ["XMIO"] | 370.0000 | 435.0000 | 15 | 36 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:15:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00c-269b-7c12-b339-5109016918e4 | VLO | 2026-09-17 11:46 | other | 4 | 1 | 10 | 291880.00 | unknown | — | 408.6950 | 12.4500 | ["160","240","340","540"] | ["0.5460","0.4245","0.4957","0.4574"] | [] | ["XMIO"] | 160.0000 | 540.0000 | 456 | 491 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:46:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b082-dd3b-7ba3-b84e-0616612d23b4 | VLO | 2026-09-17 13:55 | other | 4 | 1 | 4 | 141208.00 | unknown | — | 410.0400 | 11.8000 | ["300","310","350","360"] | ["0.5775","0.5636","0.5265","0.5241"] | [] | ["XCBO"] | 300.0000 | 360.0000 | 29 | 64 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:56:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c3-4d53-7302-9350-d2d2937c6492 | VLO | 2026-09-17 15:06 | other | 6 | 3 | 10 | 122840.00 | unknown | — | 411.9400 | 5.5900 | ["355","360","380","395","420","430"] | ["1.1497","0.5342","0.5348","0.6061","0.5140","0.5124"] | [] | ["XISX","XMIO"] | 355.0000 | 430.0000 | 1 | 92 | false | true | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:06:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b5ac-7517-7422-a8b6-cdebc614c6dd | VLO | 2026-09-18 13:59 | other | 4 | 1 | 30 | 137430.00 | unknown | bid | 411.0900 | 7.0000 | ["412.5","415","417.5","420"] | ["0.5159","0.4834","0.4993","0.4632"] | [] | ["XMIO"] | 412.5000 | 420.0000 | 7 | 14 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:59:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c95a-c2df-7f70-9cac-18d99ecfb5ea | VLO | 2026-09-22 09:42 | other | 3 | 2 | 76 | 160778.00 | unknown | bid | 383.8350 | 6.0000 | ["360","375"] | ["0.5948","0.6272"] | [] | ["XCBO","XISX"] | 360.0000 | 375.0000 | 3 | 10 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:42:52Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c95b-1cb6-7ba3-aac7-045322ab39c7 | VLO | 2026-09-22 09:43 | other | 3 | 3 | 120 | 251580.00 | unknown | bid | 384.1650 | 4.3000 | ["360","375"] | ["0.5998","0.6244"] | [] | ["ARCO","XMIO","XPHO"] | 360.0000 | 375.0000 | 3 | 10 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:43:12Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c95b-1cb6-7ba3-aac7-044caf28155d | VLO | 2026-09-22 09:43 | other | 3 | 3 | 120 | 251640.00 | unknown | bid | 384.1650 | 4.3000 | ["360","375"] | ["0.5993","0.6249"] | [] | ["ARCO","XMIO","XPHO"] | 360.0000 | 375.0000 | 3 | 10 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:43:12Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c95b-1cb6-7ba3-aac7-04397f295b8c | VLO | 2026-09-22 09:43 | other | 3 | 4 | 120 | 252060.00 | unknown | bid | 384.1650 | 4.3000 | ["360","375"] | ["0.5972","0.6271"] | [] | ["ARCO","XMIO","XPHO"] | 360.0000 | 375.0000 | 3 | 10 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:43:12Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c95b-4b97-7002-92f0-c5f67099e13f | VLO | 2026-09-22 09:43 | other | 3 | 7 | 186 | 387120.00 | unknown | bid | 383.5600 | 4.0000 | ["360","375"] | ["0.5897","0.6113"] | [] | ["AMXO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 360.0000 | 375.0000 | 3 | 10 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:43:32Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |