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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d60-5f66-7e42-a46b-6dc9d9d068cd | VLO | 2026-09-04 13:03 | call_vertical_spread | 2 | 1 | 10 | 114750.00 | long | ask | 371.3500 | 6.1000 | ["310","320"] | ["0.5057","0.4713"] | ["319.73"] | ["XMIO"] | 310.0000 | 320.0000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:04:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a081d9-fa90-7df3-a394-1c58d28302de | VLO | 2026-09-08 12:28 | call_diagonal_spread | 2 | 1 | 3 | 117135.00 | long | bid | 381.7400 | 6.7000 | ["185","190"] | ["2.1516","1.5994"] | [] | ["XISX"] | 185.0000 | 190.0000 | 10 | 17 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:29:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0822f-2740-7d40-9f65-b6bae87812bb | VLO | 2026-09-08 14:02 | call_diagonal_spread | 2 | 2 | 4 | 190198.00 | long | ask | 382.1400 | 8.0000 | ["150","155"] | ["0.3367","0.3385"] | [] | ["ARCO","XMIO"] | 150.0000 | 155.0000 | 465 | 829 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:02:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0827a-0351-74f0-864d-b28df9adbc52 | VLO | 2026-09-08 15:23 | call_diagonal_spread | 2 | 1 | 3 | 117057.00 | long | ask | 383.6700 | 8.5000 | ["195","200"] | ["0.3884","0.3947"] | [] | ["XISX"] | 195.0000 | 200.0000 | 282 | 465 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:24:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08662-f968-76d1-8d34-6096483ba2bf | VLO | 2026-09-09 09:37 | call_diagonal_spread | 2 | 1 | 19 | 305786.00 | long | bid | 383.6150 | 5.9000 | ["260","390"] | ["1.5450","0.4808"] | [] | ["XMIO"] | 260.0000 | 390.0000 | 9 | 100 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:37:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ff-0e70-7c32-906e-2664b032cc90 | VLO | 2026-09-09 12:27 | call_vertical_spread | 2 | 1 | 20 | 346000.00 | long | ask | 385.8000 | 6.4000 | ["440","450"] | ["0.4180","0.4168"] | ["443.40"] | ["XMIO"] | 440.0000 | 450.0000 | 828 | 828 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:28:25Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08bcc-de78-7323-984a-a2d226fba3a5 | VLO | 2026-09-10 10:50 | put_frontspread | 2 | 2 | 500 | 720000.00 | long | ask | 387.4650 | 1.5000 | ["340","370"] | ["0.4751","0.4912"] | ["304","364"] | ["XCBO"] | 340.0000 | 370.0000 | 36 | 36 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:51:09Z"} | 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 |
| 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 |
| 01a0919d-5940-7502-b269-de8d3d0110e6 | VLO | 2026-09-11 13:56 | call_vertical_spread | 2 | 2 | 10 | 235005.00 | long | ask | 392.1000 | 6.0000 | ["360","400"] | ["0.4163","0.4182"] | ["376.22"] | ["AMXO","ARCO"] | 360.0000 | 400.0000 | 826 | 826 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:57:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a033-dc68-7bd0-b0d2-43e03e24e568 | VLO | 2026-09-14 09:55 | call_vertical_spread | 2 | 1 | 10 | 112160.00 | long | ask | 398.3600 | 7.0000 | ["340","345"] | ["0.5636","0.6283"] | ["344.90"] | ["XISX"] | 340.0000 | 345.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:55:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a042-b530-79f0-8886-4e227779abd8 | VLO | 2026-09-14 10:11 | call_calendar | 2 | 3 | 3 | 125552.00 | long | ask | 398.5100 | 6.9000 | ["190"] | ["2.3392"] | [] | ["EMLD","MCRY","XMIO"] | 190.0000 | 190.0000 | 4 | 95 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:12:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a111-24d8-7501-b8cb-a6e01ce6b6e5 | VLO | 2026-09-14 13:57 | put_vertical_spread | 2 | 1 | 1000 | 589000.00 | long | ask | 381.3900 | 0.6000 | ["300","330"] | ["0.5254","0.5087"] | ["326.75"] | ["SPHR"] | 300.0000 | 330.0000 | 32 | 32 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:58:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a17b-6fc9-7070-afed-5a21d1ab9f62 | VLO | 2026-09-14 15:53 | call_calendar | 2 | 1 | 10 | 102650.00 | long | ask | 380.3950 | 5.3000 | ["420"] | ["0.4748"] | [] | ["XMIO"] | 420.0000 | 420.0000 | 123 | 494 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:53:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a55a-185e-7c72-8ec3-9376dd68fc4a | VLO | 2026-09-15 09:55 | call_frontspread | 2 | 2 | 9 | 128808.00 | long | bid | 390.1900 | 6.2000 | ["270","460"] | ["0.5067","0.4915"] | ["383.20"] | ["XMIO"] | 270.0000 | 460.0000 | 122 | 122 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:55:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a7-8c7e-7192-b308-a43b0aa7da3c | VLO | 2026-09-15 11:20 | call_ladder | 3 | 1 | 10 | 156930.00 | long | ask | 389.4650 | 6.0000 | ["310","400","420"] | ["0.5021","0.5030","0.5025"] | ["335.05","484.95"] | ["XISX"] | 310.0000 | 420.0000 | 94 | 94 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:20:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a649-fe6d-7782-8c2f-2a84ba9c5c3b | VLO | 2026-09-15 14:17 | put_vertical_spread | 2 | 1 | 700 | 417900.00 | long | ask | 398.3400 | 1.1500 | ["300","340"] | ["0.5736","0.5559"] | ["336.05"] | ["SPHR"] | 300.0000 | 340.0000 | 31 | 31 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:18:08Z"} | 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 |
| 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 |
| 01a0abbc-d17b-7b71-83e8-e4cfee2930a0 | VLO | 2026-09-16 15:41 | put_vertical_spread | 2 | 3 | 23 | 125797.00 | long | ask | 405.1200 | 5.2000 | ["400","405"] | ["0.5312","0.5301"] | ["402.51"] | ["ARCO","EMLD","SPHR"] | 400.0000 | 405.0000 | 44 | 44 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:41:14Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afec-65b3-7382-8da8-50ed4133dc3b | VLO | 2026-09-17 11:11 | call_vertical_spread | 2 | 1 | 38 | 265354.00 | long | ask | 407.3300 | 3.6000 | ["450","520"] | ["0.4950","0.5004"] | ["468.15"] | ["C2OX"] | 450.0000 | 520.0000 | 183 | 183 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:11:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b053-3603-7082-8061-d536748aee47 | VLO | 2026-09-17 13:03 | synthetic | 2 | 4 | 12 | 138696.00 | long | ask | 410.4850 | 4.1000 | ["380"] | ["0.5068"] | ["416.88"] | ["EMLD","MCRY","XISX","XPHO"] | 380.0000 | 380.0000 | 183 | 183 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:04:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a1-65a3-7e52-928c-3ec2a1784605 | VLO | 2026-09-17 14:29 | call_vertical_spread | 2 | 1 | 5 | 100270.00 | long | ask | 411.2700 | 7.3000 | ["460","470"] | ["0.4252","0.4247"] | ["463.40"] | ["XMIO"] | 460.0000 | 470.0000 | 820 | 820 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:29:34Z"} | 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 |
| 01a0b0e3-2993-7b33-9907-9447a94c68ad | VLO | 2026-09-17 15:41 | call_diagonal_spread | 2 | 1 | 40 | 621200.00 | long | bid | 413.1050 | 4.6000 | ["340","380"] | ["0.5055","0.5097"] | [] | ["XMIO"] | 340.0000 | 380.0000 | 92 | 120 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:41:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4c8-5e77-7d82-8c80-d98c0893808e | VLO | 2026-09-18 09:50 | put_diagonal_spread | 2 | 3 | 40 | 131812.00 | long | ask | 415.7300 | 3.4000 | ["370","415"] | ["0.5359","0.5275"] | [] | ["ARCO","C2OX","XMIO"] | 370.0000 | 415.0000 | 7 | 91 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:50:29Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-7ab8-7860-ac36-a592fda193ac | VLO | 2026-09-18 10:59 | call_vertical_spread | 2 | 1 | 20 | 407800.00 | long | ask | 415.4400 | 7.2000 | ["470","480"] | ["0.4248","0.4241"] | ["473.38"] | ["XPHO"] | 470.0000 | 480.0000 | 854 | 854 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a0-47e7-7ff0-bedc-6dabe2e034ce | VLO | 2026-09-18 13:46 | call_calendar | 2 | 4 | 10 | 209570.00 | long | ask | 410.4500 | 5.3000 | ["310"] | ["5.4952"] | [] | ["BATO","C2OX","EDGO","XCBO"] | 310.0000 | 310.0000 | 0 | 91 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:46:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a0-47e7-7ff0-bedc-6d9db6a0da72 | VLO | 2026-09-18 13:46 | call_calendar | 2 | 7 | 10 | 208522.00 | long | ask | 410.4500 | 5.3000 | ["310"] | ["5.4876"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 310.0000 | 310.0000 | 0 | 91 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:46:22Z"} | 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 |
| 01a0c431-0f67-7b32-b18f-aa9de90da5a4 | VLO | 2026-09-21 09:39 | call_vertical_spread | 2 | 1 | 5 | 114825.00 | long | ask | 410.5150 | 6.9000 | ["280","340"] | ["0.5390","0.5199"] | ["328.05"] | ["XMIO"] | 280.0000 | 340.0000 | 116 | 116 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:39:16Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 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 |
| 01a0c56e-dade-7f52-8747-e62c43ca9e83 | VLO | 2026-09-21 15:26 | call_diagonal_spread | 2 | 1 | 10 | 213700.00 | long | ask | 392.7000 | 7.8000 | ["360","410"] | ["0.4579","0.4236"] | [] | ["XISX"] | 360.0000 | 410.0000 | 487 | 816 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:26:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c571-01a7-7281-a69c-4c8151fe47a7 | VLO | 2026-09-21 15:28 | put_vertical_spread | 2 | 9 | 264 | 371546.00 | long | ask | 393.3850 | 1.7163 | ["375","395"] | ["0.6389","0.5956"] | ["387.99"] | ["AMXO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 375.0000 | 395.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:28:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |