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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b006-7d63-7d81-ade6-bf05e07f18bb | AVGO | 2026-09-17 11:40 | strangle | 2 | 1 | 8 | 155120.00 | unknown | — | 349.8000 | 2.8500 | ["300","330"] | ["0.4380","0.4720"] | [] | ["MCRY"] | 300.0000 | 330.0000 | 855 | 855 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:40:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affe-538b-75c2-9c8b-c0e31706957d | AVGO | 2026-09-17 11:31 | strangle | 2 | 1 | 10 | 75800.00 | unknown | — | 350.6100 | 2.1000 | ["300","460"] | ["0.4494","0.4393"] | [] | ["XMIO"] | 300.0000 | 460.0000 | 456 | 456 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:31:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab56-7273-7423-9361-a1f57850ad57 | AVGO | 2026-09-16 13:49 | strangle | 2 | 1 | 3 | 57315.00 | long | ask | 340.4250 | 4.0000 | ["300","330"] | ["0.4421","0.4767"] | ["138.95","491.05"] | ["XBOX"] | 300.0000 | 330.0000 | 856 | 856 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:50:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab54-055b-7d80-9b83-da808459162c | AVGO | 2026-09-16 13:46 | strangle | 2 | 1 | 3 | 56751.00 | unknown | — | 340.2100 | 4.3000 | ["300","330"] | ["0.4366","0.4718"] | [] | ["XCBO"] | 300.0000 | 330.0000 | 856 | 856 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:47:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a56c-ecae-7f92-8c79-6a1f21ab38ff | AVGO | 2026-09-15 10:16 | strangle | 2 | 1 | 5 | 31781.00 | unknown | — | 342.7800 | 0.7000 | ["350","360"] | ["0.4111","0.4175"] | [] | ["XCBO"] | 350.0000 | 360.0000 | 94 | 94 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:16:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0867a-4e10-75e0-bf07-58a3aab90279 | AVGO | 2026-09-09 10:02 | strangle | 2 | 1 | 10 | 101120.00 | short | bid | 362.0800 | 2.8000 | ["340","390"] | ["0.4268","0.4441"] | ["288.88","441.12"] | ["XCBO"] | 340.0000 | 390.0000 | 128 | 128 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:02:51Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0821a-18a0-7513-ac1d-bde37d95ca46 | AVGO | 2026-09-08 13:39 | strangle | 2 | 1 | 4 | 57360.00 | unknown | — | 367.4600 | 3.9000 | ["360","380"] | ["0.4693","0.4509"] | [] | ["XCBO"] | 360.0000 | 380.0000 | 500 | 500 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:39:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c7-ce39-76e2-a4c3-c596d3586aa8 | AVGO | 2026-09-08 12:09 | strangle | 2 | 1 | 10 | 96450.00 | long | ask | 369.9647 | 1.2500 | ["380","440"] | ["0.4570","0.4537"] | ["283.55","536.45"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:09:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c7-b2e0-77f0-a1c6-243d7a375b61 | AVGO | 2026-09-08 12:09 | strangle | 2 | 1 | 10 | 96420.00 | long | ask | 370.0900 | 2.0000 | ["380","440"] | ["0.4558","0.4546"] | ["283.58","536.42"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:09:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c6-1ca0-7b72-83a7-5af43ceb1d73 | AVGO | 2026-09-08 12:07 | strangle | 2 | 1 | 10 | 96550.00 | long | ask | 369.8500 | 1.5500 | ["380","440"] | ["0.4574","0.4541"] | ["283.45","536.55"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:07:49Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-fd60-7e82-a11e-325ace0fbfd1 | AVGO | 2026-09-08 12:07 | strangle | 2 | 1 | 10 | 96440.00 | long | ask | 369.8300 | 1.5000 | ["380","440"] | ["0.4567","0.4538"] | ["283.56","536.44"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:07:49Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-e5f0-76e1-ba32-c3f4745603b2 | AVGO | 2026-09-08 12:07 | strangle | 2 | 1 | 10 | 96470.00 | long | ask | 369.8600 | 1.4500 | ["380","440"] | ["0.4569","0.4539"] | ["283.53","536.47"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:07:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-da38-7421-ba1d-a31acb7da293 | AVGO | 2026-09-08 12:06 | strangle | 2 | 1 | 10 | 96450.00 | long | ask | 369.9400 | 1.4500 | ["380","440"] | ["0.4571","0.4535"] | ["283.55","536.45"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:07:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-ca98-7a73-a323-69e2b28c078d | AVGO | 2026-09-08 12:06 | strangle | 2 | 1 | 10 | 96460.00 | long | ask | 369.9300 | 1.4500 | ["380","440"] | ["0.4571","0.4536"] | ["283.54","536.46"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:07:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-baf8-78c1-ab44-c7ed3b6b3457 | AVGO | 2026-09-08 12:06 | strangle | 2 | 2 | 10 | 96455.00 | short | bid | 369.9000 | 1.0500 | ["380","440"] | ["0.4561","0.4546"] | ["283.54","536.46"] | ["MCRY","XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:07:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-af40-79c3-bbfb-7aa623899f2f | AVGO | 2026-09-08 12:06 | strangle | 2 | 1 | 10 | 96440.00 | short | bid | 370.0050 | 1.0500 | ["380","440"] | ["0.4564","0.4542"] | ["283.56","536.44"] | ["XMIO"] | 380.0000 | 440.0000 | 282 | 282 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:07:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d38-3a0d-7960-af9b-f49ab96b8bba | AVGO | 2026-09-04 12:19 | strangle | 2 | 1 | 250 | 453494.00 | long | ask | 355.6000 | 0.4000 | ["340","380"] | ["0.3542","0.3579"] | ["321.86","398.14"] | ["XMIO"] | 340.0000 | 380.0000 | 42 | 42 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:20:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |