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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c490-5dd7-77e3-a080-f18ed9a32328 | VLO | 2026-09-21 11:23 | call_condor | 4 | 2 | 30 | 157200.00 | short | bid | 405.4900 | 6.7000 | ["405","410","412.5","417.5"] | ["0.5531","0.5415","0.5474","0.5511"] | ["405.80","416.7"] | ["XISX"] | 405.0000 | 417.5000 | 11 | 11 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:23:17Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 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 |
| 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 |
| 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 |
| 01a0b086-c923-7c50-8bd4-66334b99e478 | VLO | 2026-09-17 14:00 | call_diagonal_spread | 2 | 1 | 80 | 3876480.00 | short | bid | 409.8050 | 6.5000 | ["170","175"] | ["0.8890","0.3809"] | [] | ["XPHO"] | 170.0000 | 175.0000 | 92 | 456 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:00:20Z"} | 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-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 |
| 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 |
| 01a0a154-b9a0-7e22-90bc-d549ed2b60bc | VLO | 2026-09-14 15:11 | strangle | 2 | 1 | 30 | 175530.00 | short | bid | 379.2200 | 0.6000 | ["340","560"] | ["0.4837","0.4854"] | ["281.49","618.51"] | ["XISX"] | 340.0000 | 560.0000 | 276 | 276 | false | true | false | true | true | mlet | 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 |
| 01a0a119-df38-7783-a1a6-3ceb24946bdf | VLO | 2026-09-14 14:07 | call_diagonal_spread | 2 | 1 | 6 | 101586.00 | short | bid | 381.5500 | 6.6000 | ["390","450"] | ["0.4576","0.4307"] | [] | ["XISX"] | 390.0000 | 450.0000 | 494 | 823 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:07:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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 |
| 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 |
| 01a09149-af48-74a1-959b-905b3becfdd9 | VLO | 2026-09-11 12:25 | call_diagonal_spread | 2 | 1 | 9 | 246600.00 | short | bid | 397.3400 | 8.0000 | ["310","330"] | ["0.4407","0.4059"] | [] | ["XCBO"] | 310.0000 | 330.0000 | 462 | 826 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:25:31Z"} | 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 |
| 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 |
| 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 |
| 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 |
| 01a08253-c258-7533-988a-79f55389bd02 | VLO | 2026-09-08 14:42 | risk_reversal | 2 | 1 | 40 | 148240.00 | short | bid | 382.4900 | 3.0000 | ["320","450"] | ["0.4787","0.4807"] | ["457.58"] | ["XCBO"] | 320.0000 | 450.0000 | 129 | 129 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:42:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 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 |