Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b518-a53f-7ee0-ab05-466580ac37b9 | AVGO | 2026-09-18 11:18 | put_vertical_spread | 2 | 1 | 5 | 38300.00 | short | bid | 357.3200 | 0.8000 | ["250","300"] | ["0.4616","0.4629"] | ["280.60"] | ["EDGO"] | 250.0000 | 300.0000 | 819 | 819 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:18:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bc-d558-7a73-ad32-3ad6e789f2a0 | AVGO | 2026-09-18 09:37 | put_vertical_spread | 2 | 1 | 4 | 62220.00 | long | ask | 360.5300 | 5.7500 | ["400","420"] | ["0.4427","0.4490"] | ["406.25"] | ["C2OX"] | 400.0000 | 420.0000 | 272 | 272 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b020-6a1b-78f1-b9da-9736bfc9b7e6 | AVGO | 2026-09-17 12:08 | put_vertical_spread | 2 | 1 | 24 | 135120.00 | unknown | — | 348.4700 | 0.7500 | ["340","350"] | ["0.4077","0.4078"] | [] | ["C2OX"] | 340.0000 | 350.0000 | 120 | 120 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:08:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af8f-9fb3-7d72-a0b9-14c65d32e3c9 | AVGO | 2026-09-17 09:30 | put_vertical_spread | 2 | 1 | 80 | 706400.00 | long | ask | 346.0100 | 5.6500 | ["370","380"] | ["0.4102","0.4152"] | ["373"] | ["C2OX"] | 370.0000 | 380.0000 | 92 | 92 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:17Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0abc7-06c3-7e02-8db0-76b49092e7c6 | AVGO | 2026-09-16 15:52 | put_vertical_spread | 2 | 1 | 5 | 34175.00 | unknown | — | 338.7400 | 1.5000 | ["230","330"] | ["0.4487","0.4514"] | [] | ["XISX"] | 230.0000 | 330.0000 | 492 | 492 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:52:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a645-2c0e-7282-b1a5-abb916be09cd | AVGO | 2026-09-15 14:12 | put_vertical_spread | 2 | 1 | 53 | 46375.00 | unknown | — | 339.1550 | 0.6000 | ["315","320"] | ["0.3746","0.3705"] | [] | ["C2OX"] | 315.0000 | 320.0000 | 24 | 24 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:13:09Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e8-98d5-7c61-ba16-c7f6d48241ce | AVGO | 2026-09-15 12:31 | put_vertical_spread | 2 | 1 | 25 | 58500.00 | short | bid | 339.6899 | 0.2000 | ["330","340"] | ["0.3659","0.3646"] | ["335.50"] | ["C2OX"] | 330.0000 | 340.0000 | 31 | 31 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:31:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a096-66f8-7be2-aeb7-e079657c9303 | AVGO | 2026-09-14 11:43 | put_vertical_spread | 2 | 1 | 9 | 56835.00 | unknown | — | 347.8000 | 1.4500 | ["350","360"] | ["0.4195","0.4196"] | [] | ["C2OX"] | 350.0000 | 360.0000 | 95 | 95 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:43:25Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a056-8f38-7df0-abb2-812d4ec5b981 | AVGO | 2026-09-14 10:33 | put_vertical_spread | 2 | 1 | 10 | 109900.00 | unknown | — | 345.8000 | 1.7500 | ["350","420"] | ["0.4230","0.4471"] | [] | ["XISX"] | 350.0000 | 420.0000 | 95 | 95 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:33:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03e-e888-7392-8f6f-05326ea3b675 | AVGO | 2026-09-14 10:07 | put_vertical_spread | 2 | 1 | 100 | 503000.00 | unknown | — | 347.8410 | 0.8500 | ["330","340"] | ["0.4231","0.4219"] | [] | ["C2OX"] | 330.0000 | 340.0000 | 123 | 123 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:07:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091b9-c699-7a62-b685-ea9f245a2236 | AVGO | 2026-09-11 14:27 | put_vertical_spread | 2 | 1 | 20 | 35700.00 | unknown | — | 364.9300 | 0.8500 | ["340","350"] | ["0.3665","0.3645"] | [] | ["XISX"] | 340.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:28:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cad-fb61-7913-b679-17c6e9539f41 | AVGO | 2026-09-10 14:56 | put_vertical_spread | 2 | 2 | 20 | 29700.00 | short | bid | 362.4200 | 0.6000 | ["340","350"] | ["0.3729","0.3695"] | ["346.85"] | ["C2OX"] | 340.0000 | 350.0000 | 29 | 29 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:57:21Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a081d3-1cc0-78b0-8d68-de124073cb35 | AVGO | 2026-09-08 12:21 | put_vertical_spread | 2 | 1 | 60 | 87000.00 | short | bid | 368.1050 | 0.3500 | ["360","365"] | ["0.4107","0.4112"] | ["362.90"] | ["XISX"] | 360.0000 | 365.0000 | 10 | 10 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:21:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |