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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56f-5bc7-7bd1-a40d-84dafe8c0f41 | AVGO | 2026-09-21 15:26 | call_diagonal_spread | 2 | 1 | 2 | 25680.00 | long | ask | 363.5403 | 2.8000 | ["300","310"] | ["0.9723","0.4500"] | [] | ["AMXO"] | 300.0000 | 310.0000 | 4 | 88 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:27:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b4d9-17b8-71c2-89a0-5ace6a4b2eb2 | AVGO | 2026-09-18 10:08 | call_diagonal_spread | 2 | 2 | 18 | 36540.00 | unknown | ask | 359.9400 | 0.9000 | ["350","370"] | ["0.7281","0.3521"] | [] | ["MCRY","XISX"] | 350.0000 | 370.0000 | 0 | 28 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c0-b970-77e2-a2e6-4d3d852e7185 | AVGO | 2026-09-18 09:42 | call_diagonal_spread | 2 | 1 | 7 | 27195.00 | short | bid | 360.3200 | 2.0000 | ["345","350"] | ["0.6880","0.3516"] | [] | ["XCBO"] | 345.0000 | 350.0000 | 0 | 42 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:42:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-11bf-7381-9599-a72b0400c1e8 | AVGO | 2026-09-18 09:39 | call_diagonal_spread | 2 | 1 | 20 | 82440.00 | unknown | bid | 360.7100 | 1.5900 | ["340","382.5"] | ["0.3951","0.8197"] | [] | ["XBOX"] | 340.0000 | 382.5000 | 0 | 91 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b6-494b-7173-ae21-bce15a63f724 | AVGO | 2026-09-17 14:52 | call_diagonal_spread | 2 | 2 | 24 | 110520.00 | long | ask | 348.0800 | 0.8000 | ["350","370"] | ["0.3964","0.3596"] | [] | ["C2OX"] | 350.0000 | 370.0000 | 64 | 120 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:52:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b079-1d23-7f22-9373-5324797f6534 | AVGO | 2026-09-17 13:45 | call_diagonal_spread | 2 | 1 | 8 | 150080.00 | unknown | — | 349.2400 | 1.6000 | ["290","300"] | ["0.4242","0.4186"] | [] | ["XISX"] | 290.0000 | 300.0000 | 273 | 491 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:45:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a62e-8b16-7883-84e6-3bb439c6c304 | AVGO | 2026-09-15 13:47 | call_diagonal_spread | 2 | 1 | 269 | 217890.00 | short | bid | 338.2300 | 0.1700 | ["365","385"] | ["0.3587","0.3743"] | [] | ["XISX"] | 365.0000 | 385.0000 | 24 | 38 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:47:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a594-3f16-7c91-b826-694ed00faab3 | AVGO | 2026-09-15 10:59 | call_diagonal_spread | 2 | 1 | 2 | 61660.00 | short | bid | 341.1350 | 4.6000 | ["190","200"] | ["0.3582","0.4243"] | [] | ["C2OX"] | 190.0000 | 200.0000 | 122 | 367 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:59:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a590-4f46-70a0-9c3e-6a8194b620ad | AVGO | 2026-09-15 10:54 | call_diagonal_spread | 2 | 1 | 9 | 51255.00 | short | bid | 341.1700 | 2.9000 | ["310","335"] | ["0.4176","0.4317"] | [] | ["C2OX"] | 310.0000 | 335.0000 | 3 | 94 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:55:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a030-0020-7e91-ae3a-d568ff4214ef | AVGO | 2026-09-14 09:51 | call_diagonal_spread | 2 | 2 | 2 | 33494.00 | unknown | — | 347.9400 | 1.5250 | ["200","370"] | ["0.4312","0.4452"] | [] | ["XISX"] | 200.0000 | 370.0000 | 4 | 494 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:51:36Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |