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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08249-94e0-7383-aad8-c97673b8d42b | VLO | 2026-09-08 14:30 | call_calendar | 2 | 1 | 6 | 208800.00 | short | bid | 383.5600 | 7.4000 | ["210"] | ["1.5314"] | [] | ["XMIO"] | 210.0000 | 210.0000 | 10 | 45 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:31:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08294-c6e0-7203-9c14-a6d68b8ee5bb | VLO | 2026-09-08 15:53 | call_vertical_spread | 2 | 1 | 5 | 107245.00 | short | bid | 383.8500 | 7.0000 | ["360","400"] | ["0.4101","0.4108"] | ["375.95"] | ["XCBO"] | 360.0000 | 400.0000 | 829 | 829 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:53:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0877d-1bf9-7353-bed0-a5b776ed699a | VLO | 2026-09-09 14:45 | call_diagonal_spread | 2 | 1 | 7 | 271880.00 | unknown | — | 384.6400 | 6.6000 | ["195","200"] | ["0.7375","0.4052"] | [] | ["XPHO"] | 195.0000 | 200.0000 | 100 | 464 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:45:36Z"} | 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 |
| 01a090d2-e908-76d0-a574-8965a5c30013 | VLO | 2026-09-11 10:15 | call_vertical_spread | 2 | 1 | 20 | 365400.00 | long | ask | 394.2000 | 8.2000 | ["450","460"] | ["0.4179","0.4177"] | ["453.24"] | ["XMIO"] | 450.0000 | 460.0000 | 826 | 826 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:15:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e0-e328-74c2-ac15-724464b659d5 | VLO | 2026-09-11 10:30 | call_vertical_spread | 2 | 1 | 20 | 102760.00 | short | bid | 393.9400 | 5.0000 | ["370","372.5"] | ["0.4970","0.4887"] | ["372.12"] | ["XCBO"] | 370.0000 | 372.5000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:30:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0911a-8128-79e3-87ad-824f80794f3e | VLO | 2026-09-11 11:33 | put_vertical_spread | 2 | 1 | 20 | 187400.00 | short | bid | 397.4200 | 7.5000 | ["260","400"] | ["0.4842","0.4813"] | ["343.38"] | ["XCBO"] | 260.0000 | 400.0000 | 497 | 497 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:34:09Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0917d-1770-75c1-b751-0d34a35b2430 | VLO | 2026-09-11 13:21 | put_vertical_spread | 2 | 1 | 25 | 108875.00 | long | ask | 394.6044 | 2.3000 | ["320","370"] | ["0.4982","0.4928"] | ["352.73"] | ["XMIO"] | 320.0000 | 370.0000 | 126 | 126 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:22:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0917e-b968-7a52-848d-2f50e1e301f1 | VLO | 2026-09-11 13:23 | put_vertical_spread | 2 | 1 | 50 | 137300.00 | short | bid | 394.7900 | 2.4000 | ["370","380"] | ["0.4789","0.4787"] | ["376.20"] | ["XCBO"] | 370.0000 | 380.0000 | 35 | 35 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:23:35Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 01a0a565-c0be-7cb0-8eaa-1bcbab097595 | VLO | 2026-09-15 10:08 | call_diagonal_spread | 2 | 1 | 20 | 624200.00 | unknown | — | 389.4900 | 6.4000 | ["290","300"] | ["0.4083","0.4087"] | [] | ["XMIO"] | 290.0000 | 300.0000 | 822 | 857 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:08:44Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a69d-0c26-7842-9211-be9a4cb832da | VLO | 2026-09-15 15:48 | call_diagonal_spread | 2 | 1 | 15 | 499650.00 | long | ask | 395.9500 | 6.6000 | ["240","250"] | ["0.4557","0.4361"] | [] | ["XMIO"] | 240.0000 | 250.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:48:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa89-cbd3-75e0-979c-548aec5c8c66 | VLO | 2026-09-16 10:05 | call_diagonal_spread | 2 | 1 | 12 | 109824.00 | unknown | — | 394.4000 | 5.2000 | ["380","460"] | ["0.5129","0.5017"] | [] | ["XCBO"] | 380.0000 | 460.0000 | 121 | 184 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:06:07Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 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 |
| 01a0ab01-ce7b-76d1-b375-a17bc503862c | VLO | 2026-09-16 12:16 | iron_condor | 4 | 1 | 10 | 114530.00 | unknown | — | 404.1600 | 4.9000 | ["350","370","420","430"] | ["0.5404","0.5395","0.5221","0.5209"] | [] | ["XMIO"] | 350.0000 | 430.0000 | 93 | 93 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:17:49Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abaa-7e13-71a0-95d7-d5a622ca58b6 | VLO | 2026-09-16 15:21 | call_vertical_spread | 2 | 1 | 5 | 123120.00 | long | ask | 402.1678 | 6.5000 | ["330","340"] | ["0.4558","0.4559"] | ["335.52"] | ["XMIO"] | 330.0000 | 340.0000 | 457 | 457 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:21:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afe2-018b-7d33-99f0-2d61a56c2504 | VLO | 2026-09-17 11:00 | call_diagonal_spread | 2 | 1 | 6 | 220098.00 | short | ask | 406.8600 | 5.4000 | ["200","250"] | ["6.9856","0.4719"] | [] | ["XCBO"] | 200.0000 | 250.0000 | 1 | 92 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:00:24Z"} | 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 |
| 01a0b03b-f4e3-7c02-a613-80277f592e56 | VLO | 2026-09-17 12:38 | call_vertical_spread | 2 | 1 | 5 | 130240.00 | short | bid | 409.1700 | 6.0000 | ["270","300"] | ["0.5055","0.5109"] | ["296.80"] | ["EDGO"] | 270.0000 | 300.0000 | 92 | 92 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:39:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b05c-0fa3-7dd1-a937-f32d8df2e2dd | VLO | 2026-09-17 13:13 | call_diagonal_spread | 2 | 1 | 200 | 924200.00 | short | ask | 411.1700 | 5.2000 | ["385","450"] | ["0.5139","0.5136"] | [] | ["AMXO"] | 385.0000 | 450.0000 | 15 | 36 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:14:03Z"} | 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 |
| 01a0b0cd-76e3-7073-9b95-8d08924d6b07 | VLO | 2026-09-17 15:17 | call_vertical_spread | 2 | 1 | 20 | 413502.00 | long | ask | 412.6958 | 7.3000 | ["460","470"] | ["0.4226","0.4224"] | ["463.36"] | ["XMIO"] | 460.0000 | 470.0000 | 855 | 855 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:18:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b531-26af-71c1-92ba-01219741f251 | VLO | 2026-09-18 11:44 | call_diagonal_spread | 2 | 1 | 4 | 110700.00 | unknown | — | 415.5000 | 6.5000 | ["320","380"] | ["0.4144","0.4591"] | [] | ["XCBO"] | 320.0000 | 380.0000 | 490 | 819 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:45:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57d-d77f-72a2-93b2-171c147fd33e | VLO | 2026-09-18 13:08 | call_calendar | 2 | 1 | 3 | 126045.00 | short | ask | 409.9350 | 5.7000 | ["200"] | ["10.9880"] | [] | ["XMIO"] | 200.0000 | 200.0000 | 0 | 28 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:08:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a8-71bf-7fa0-8d53-8411ea3146d9 | VLO | 2026-09-18 13:55 | call_diagonal_spread | 2 | 1 | 102 | 1322430.00 | short | ask | 411.3000 | 2.0000 | ["310","430"] | ["9.0665","0.5153"] | [] | ["EDGO"] | 310.0000 | 430.0000 | 0 | 63 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:55:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 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 |
| 01a0b5b1-050f-77d1-85af-1fb61d376cfb | VLO | 2026-09-18 14:04 | call_condor | 4 | 1 | 30 | 104430.00 | long | ask | 410.9400 | 5.8000 | ["412.5","415","417.5","420"] | ["0.4919","0.4829","0.4756","0.4695"] | ["412.75","419.75"] | ["XCBO"] | 412.5000 | 420.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:04:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5cf-145f-79c3-80ed-02f93ee16709 | VLO | 2026-09-18 14:37 | call_diagonal_spread | 2 | 1 | 11 | 209616.00 | long | ask | 410.9900 | 5.9000 | ["320","360"] | ["9.5452","0.4872"] | [] | ["XCBO"] | 320.0000 | 360.0000 | 0 | 272 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:37:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5cf-79f0-7bc0-bc49-7f9abd8f6019 | VLO | 2026-09-18 14:37 | call_diagonal_spread | 2 | 1 | 12 | 228672.00 | long | ask | 411.2400 | 5.9000 | ["320","360"] | ["7.4752","0.4857"] | [] | ["XCBO"] | 320.0000 | 360.0000 | 0 | 272 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:38:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c49a-6827-7bc1-864a-f346c7d411dc | VLO | 2026-09-21 11:34 | call_vertical_spread | 2 | 1 | 20 | 369840.00 | long | ask | 404.6150 | 6.2000 | ["480","490"] | ["0.4249","0.4241"] | ["483.18"] | ["XCBO"] | 480.0000 | 490.0000 | 851 | 851 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:34:16Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |