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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 01a0b4ba-a2d8-74e2-9728-5b514e0dc45f | VLO | 2026-09-18 09:35 | call_vertical_spread | 2 | 1 | 41 | 299218.00 | short | bid | 412.0100 | 6.6000 | ["380","382.5"] | ["0.5264","0.5223"] | ["382.0"] | ["BATO"] | 380.0000 | 382.5000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:35:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 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 |
| 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 |
| 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 |
| 01a0afec-65b3-7382-8da8-50fb513587c1 | VLO | 2026-09-17 11:11 | call_vertical_spread | 2 | 2 | 38 | 265430.00 | unknown | — | 407.3300 | 3.5000 | ["450","520"] | ["0.4951","0.5005"] | [] | ["MCRY"] | 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 |
| 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 |
| 01a0afec-65b3-7382-8da8-50d0acf45470 | VLO | 2026-09-17 11:11 | call_vertical_spread | 2 | 1 | 38 | 264898.00 | short | bid | 407.3300 | 3.8000 | ["450","520"] | ["0.4945","0.4999"] | ["468.15"] | ["SPHR"] | 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 |
| 01a0afd6-d62b-7960-993c-65bbb531cef9 | VLO | 2026-09-17 10:48 | call_vertical_spread | 2 | 1 | 10 | 244000.00 | unknown | — | 406.1500 | 7.8000 | ["280","290"] | ["0.8264","0.4397"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 29 | 29 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:48:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a0aab0-7643-7402-8a82-405c17aa9043 | VLO | 2026-09-16 10:48 | call_vertical_spread | 2 | 1 | 20 | 387600.00 | unknown | — | 400.0000 | 7.6000 | ["460","470"] | ["0.4280","0.4294"] | [] | ["XBOX"] | 460.0000 | 470.0000 | 856 | 856 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:48:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5d1-e06d-74b0-ac15-b6750b497a26 | VLO | 2026-09-15 12:06 | call_vertical_spread | 2 | 1 | 15 | 149550.00 | unknown | — | 390.8700 | 3.9000 | ["380","390"] | ["0.4956","0.4975"] | [] | ["MCRY"] | 380.0000 | 390.0000 | 122 | 122 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:06:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0c1-0cf0-7aa0-9ab3-74bfb34e310f | VLO | 2026-09-14 12:29 | call_vertical_spread | 2 | 1 | 5 | 118000.00 | unknown | — | 387.2600 | 6.8000 | ["310","330"] | ["0.4572","0.4566"] | [] | ["XMIO"] | 310.0000 | 330.0000 | 459 | 459 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:30:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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 |
| 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 |
| 01a0916c-f2a0-78d1-b9c5-2a5d1b1da81d | VLO | 2026-09-11 13:03 | call_vertical_spread | 2 | 1 | 15 | 108210.00 | short | bid | 394.7600 | 2.1000 | ["400","450"] | ["0.4844","0.4894"] | ["417.50"] | ["MCRY"] | 400.0000 | 450.0000 | 126 | 126 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:04:11Z"} | 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 |
| 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 |
| 01a08c3d-0569-7581-9c8f-d249ac13202a | VLO | 2026-09-10 12:53 | call_vertical_spread | 2 | 1 | 10 | 230500.00 | unknown | — | 390.3950 | 8.0000 | ["360","390"] | ["0.4036","0.4050"] | [] | ["XISX"] | 360.0000 | 390.0000 | 827 | 827 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:53:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 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 |
| 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 |
| 01a0827d-6680-70a1-a617-17156621dd8c | VLO | 2026-09-08 15:27 | call_vertical_spread | 2 | 1 | 20 | 607000.00 | unknown | — | 383.4700 | 9.8000 | ["280","290"] | ["0.4049","0.4058"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 829 | 829 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:27:43Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0815e-db08-7ae3-9c35-60b84c8c6ee8 | VLO | 2026-09-08 10:14 | call_vertical_spread | 2 | 1 | 20 | 336040.00 | unknown | — | 381.5700 | 7.5000 | ["430","440"] | ["0.4035","0.4024"] | [] | ["XPHO"] | 430.0000 | 440.0000 | 829 | 829 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:14:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |