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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c588-3327-74f1-ad20-666ebe888a74 | AVGO | 2026-09-21 15:53 | call_vertical_spread | 2 | 1 | 20 | 125500.00 | short | bid | 363.6800 | 0.3250 | ["370","380"] | ["0.4174","0.4179"] | ["374.15"] | ["XISX"] | 370.0000 | 380.0000 | 116 | 116 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:54:04Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b4fc-1c8f-7981-97c3-81dc0863bb9e | AVGO | 2026-09-18 10:46 | call_vertical_spread | 2 | 1 | 150 | 79500.00 | short | bid | 358.5800 | 0.2600 | ["355","360"] | ["0.5239","0.5050"] | ["358"] | ["XISX"] | 355.0000 | 360.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:47:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d5-7dd8-78d0-8f22-eaa8160cd14b | AVGO | 2026-09-18 10:04 | call_vertical_spread | 2 | 1 | 2 | 25680.00 | unknown | bid | 358.8800 | 3.5500 | ["350","450"] | ["0.4337","0.4383"] | ["464.20"] | ["XISX"] | 350.0000 | 450.0000 | 455 | 455 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d7-0c02-79f3-bb8b-cc1ac08ba797 | AVGO | 2026-09-17 15:27 | call_vertical_spread | 2 | 1 | 20 | 93100.00 | short | bid | 348.1400 | 1.4500 | ["315","350"] | ["0.3524","0.3370"] | ["339.55"] | ["XISX"] | 315.0000 | 350.0000 | 22 | 22 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:28:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afaf-02da-7741-8c3f-d49a8d92bbaa | AVGO | 2026-09-17 10:04 | call_vertical_spread | 2 | 1 | 20 | 34600.00 | long | ask | 348.2500 | 0.4500 | ["340","342.5"] | ["0.2857","0.2838"] | ["341.9"] | ["XISX"] | 340.0000 | 342.5000 | 4 | 4 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:04:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab41-11cb-7b52-b950-1e3ae8487f6d | AVGO | 2026-09-16 13:26 | call_vertical_spread | 2 | 1 | 20 | 83400.00 | unknown | — | 339.8000 | 0.9000 | ["400","410"] | ["0.4172","0.4180"] | [] | ["XISX"] | 400.0000 | 410.0000 | 184 | 184 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:26:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a661-c845-7a92-ad51-f109923d40af | AVGO | 2026-09-15 14:43 | call_vertical_spread | 2 | 1 | 3 | 33615.00 | unknown | — | 339.7450 | 1.7500 | ["350","370"] | ["0.4261","0.4260"] | [] | ["C2OX"] | 350.0000 | 370.0000 | 367 | 367 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:44:19Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a619-8ffe-7ab2-8187-3d7e883827b7 | AVGO | 2026-09-15 13:24 | call_vertical_spread | 2 | 1 | 100 | 55700.00 | long | ask | 338.2400 | 0.1100 | ["500","510"] | ["0.4343","0.4373"] | ["500.39"] | ["XISX"] | 500.0000 | 510.0000 | 122 | 122 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:25:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d9-79be-7b62-ada9-029a2ae0a9ab | AVGO | 2026-09-15 12:14 | call_vertical_spread | 2 | 1 | 3 | 45045.00 | unknown | — | 339.5200 | 2.6500 | ["330","340"] | ["0.4316","0.4317"] | [] | ["XISX"] | 330.0000 | 340.0000 | 458 | 458 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:14:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a583-81ee-7782-890f-c46a18c97269 | AVGO | 2026-09-15 10:40 | call_vertical_spread | 2 | 1 | 125 | 79875.00 | unknown | — | 341.8790 | 0.3500 | ["580","600"] | ["0.4514","0.4582"] | [] | ["C2OX"] | 580.0000 | 600.0000 | 185 | 185 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:41:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a09b-c5f8-7de3-877d-bc1c2de2cece | AVGO | 2026-09-14 11:49 | call_vertical_spread | 2 | 1 | 5 | 39925.00 | unknown | — | 347.7600 | 3.2500 | ["400","460"] | ["0.4349","0.4408"] | [] | ["C2OX"] | 400.0000 | 460.0000 | 368 | 368 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:49:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ce-a658-7833-8d28-2e4bbdaef729 | AVGO | 2026-09-11 14:50 | call_vertical_spread | 2 | 1 | 68 | 44336.00 | short | bid | 363.8950 | 0.1800 | ["362.5","365"] | ["0.2351","0.2345"] | ["363.78"] | ["C2OX"] | 362.5000 | 365.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:50:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0917d-4268-7f31-9099-5bff8b77c07d | AVGO | 2026-09-11 13:21 | call_vertical_spread | 2 | 2 | 10 | 49650.00 | unknown | — | 365.0786 | 0.8500 | ["360","420"] | ["0.4173","0.4172"] | [] | ["XCBO"] | 360.0000 | 420.0000 | 98 | 98 | false | false | false | true | false | mesl | tracked | 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 |
| 01a0914e-fac0-72d2-9368-58948bee3a34 | AVGO | 2026-09-11 12:31 | call_vertical_spread | 2 | 1 | 5 | 78600.00 | long | ask | 364.4900 | 1.2000 | ["300","500"] | ["0.4541","0.4564"] | ["371.20"] | ["XISX"] | 300.0000 | 500.0000 | 497 | 497 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:31:17Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ec-f8e9-7213-b2dc-1f6a439f1f37 | AVGO | 2026-09-11 10:44 | call_vertical_spread | 2 | 1 | 10 | 123100.00 | unknown | — | 363.1605 | 2.9000 | ["400","450"] | ["0.4533","0.4547"] | [] | ["XISX"] | 400.0000 | 450.0000 | 497 | 497 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:44:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08beb-8238-7ae2-9637-e98ba7db1d53 | AVGO | 2026-09-10 11:24 | call_vertical_spread | 2 | 1 | 30 | 84600.00 | short | bid | 364.3350 | 0.2750 | ["460","470"] | ["0.4286","0.4313"] | ["461.50"] | ["C2OX"] | 460.0000 | 470.0000 | 162 | 162 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:24:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087b6-e4f0-72d2-88e0-13e32a23ad93 | AVGO | 2026-09-09 15:48 | call_vertical_spread | 2 | 1 | 25 | 200125.00 | long | ask | 364.3750 | 1.9500 | ["400","450"] | ["0.4497","0.4514"] | ["414.55"] | ["C2OX"] | 400.0000 | 450.0000 | 281 | 281 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:48:40Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f7-32b8-7870-986c-c377d06ecf37 | AVGO | 2026-09-09 12:19 | call_vertical_spread | 2 | 1 | 55 | 439450.00 | unknown | — | 359.5800 | 2.0000 | ["660","740"] | ["0.4790","0.4808"] | [] | ["C2OX"] | 660.0000 | 740.0000 | 828 | 828 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:19:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866a-d138-79a0-ab6d-291030c606b5 | AVGO | 2026-09-09 09:45 | call_vertical_spread | 2 | 2 | 10 | 34700.00 | long | ask | 362.8800 | 0.6000 | ["360","370"] | ["0.3803","0.3820"] | ["364.60"] | ["C2OX"] | 360.0000 | 370.0000 | 37 | 37 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:45:51Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0813d-2a08-7661-ad80-0d318f4ac9e3 | AVGO | 2026-09-08 09:37 | call_vertical_spread | 2 | 1 | 10 | 83900.00 | unknown | — | 369.1300 | 4.1000 | ["400","450"] | ["0.4416","0.4442"] | [] | ["C2OX"] | 400.0000 | 450.0000 | 282 | 282 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:37:49Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08138-d4a9-7cc0-961a-7719dc5623ae | AVGO | 2026-09-08 09:32 | call_vertical_spread | 2 | 1 | 11 | 26730.00 | short | bid | 365.6000 | 0.8500 | ["360","375"] | ["0.3904","0.3970"] | ["366.80"] | ["XISX"] | 360.0000 | 375.0000 | 17 | 17 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:33:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d8e-4d35-7a51-9496-455f41f622c7 | AVGO | 2026-09-04 13:53 | call_vertical_spread | 2 | 1 | 100 | 101500.00 | short | bid | 354.4750 | 0.5000 | ["500","510"] | ["0.4337","0.4362"] | ["500.65"] | ["XISX"] | 500.0000 | 510.0000 | 133 | 133 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:54:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |