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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dc9-8945-7060-9f79-ed13d79829d1 | AVGO | 2026-09-04 14:58 | straddle | 2 | 3 | 3 | 56068.00 | short | bid | 356.7500 | 2.9500 | ["350"] | ["0.4551"] | ["163.11","536.89"] | ["ARCO","SPHR","XBOX"] | 350.0000 | 350.0000 | 833 | 833 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:59:01Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de5-17f5-7653-8b6f-f8caea465bed | AVGO | 2026-09-04 15:28 | straddle | 2 | 1 | 4 | 35220.00 | long | ask | 356.2300 | 1.5000 | ["350"] | ["0.4268"] | ["261.95","438.05"] | ["XISX"] | 350.0000 | 350.0000 | 196 | 196 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:29:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a086a3-d2f8-7e11-ae3d-35a479f7a6b4 | AVGO | 2026-09-09 10:47 | straddle | 2 | 1 | 9 | 103185.00 | short | bid | 363.1300 | 2.8000 | ["380"] | ["0.4535"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:48:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a6-e038-77b1-ba9b-89bf59ebb7fd | AVGO | 2026-09-09 10:51 | straddle | 2 | 1 | 9 | 103104.00 | short | bid | 362.2500 | 2.8500 | ["380"] | ["0.4535"] | ["265.44","494.56"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:51:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ad-3938-7fd2-9d1f-67c54a86ae89 | AVGO | 2026-09-09 10:58 | straddle | 2 | 2 | 21 | 240751.00 | short | bid | 362.0500 | 3.8500 | ["380"] | ["0.4540"] | ["265.36","494.64"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:58:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b1-bd78-7373-b276-1c7c00437d17 | AVGO | 2026-09-09 11:03 | straddle | 2 | 1 | 8 | 91720.00 | short | bid | 362.1350 | 3.8500 | ["380"] | ["0.4540"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:03:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b6-2a49-7111-9c02-05a977a1900a | AVGO | 2026-09-09 11:07 | straddle | 2 | 1 | 8 | 91720.00 | short | bid | 361.7300 | 3.7000 | ["380"] | ["0.4541"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:08:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b7-4770-7561-ac45-b7052f55acee | AVGO | 2026-09-09 11:09 | straddle | 2 | 1 | 13 | 149045.00 | short | bid | 361.4600 | 4.0000 | ["380"] | ["0.4543"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:09:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b8-7ff0-7c02-b966-ebff1f8f7cb0 | AVGO | 2026-09-09 11:10 | straddle | 2 | 1 | 12 | 137580.00 | long | ask | 361.2600 | 2.7500 | ["380"] | ["0.4544"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:10:40Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087a0-8278-7d43-80e8-91b37b275631 | AVGO | 2026-09-09 15:23 | straddle | 2 | 1 | 80 | 139280.00 | long | ask | 363.6000 | 0.4500 | ["365"] | ["0.3812"] | ["347.59","382.41"] | ["EDGO"] | 365.0000 | 365.0000 | 9 | 9 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:24:21Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c97-c7c9-7f00-9458-dfe65edd8d35 | AVGO | 2026-09-10 14:32 | straddle | 2 | 2 | 2 | 38120.00 | unknown | — | 362.5000 | 2.4000 | ["350"] | ["0.4758"] | [] | ["ARCO","XBOX"] | 350.0000 | 350.0000 | 827 | 827 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:33:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0a042-0569-7ee2-b1f4-913b83169944 | AVGO | 2026-09-14 10:11 | straddle | 2 | 1 | 2 | 29252.00 | long | ask | 348.2300 | 4.5500 | ["370"] | ["0.4583"] | ["223.74","516.26"] | ["XBOX"] | 370.0000 | 370.0000 | 494 | 494 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:11:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a160-46a9-79c1-b256-22f2d9ac0498 | AVGO | 2026-09-14 15:23 | straddle | 2 | 3 | 16 | 47600.00 | short | bid | 345.2000 | 0.6500 | ["350"] | ["0.3620"] | ["320.25","379.75"] | ["EMLD","XBOX","XMIO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:23:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a160-5260-73c1-b16b-5c16f22b869d | AVGO | 2026-09-14 15:23 | straddle | 2 | 6 | 46 | 137080.00 | long | ask | 345.2695 | 0.5380 | ["350"] | ["0.3626"] | ["320.2","379.80"] | ["EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:24:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a160-5a30-7611-a93c-00c75af14b03 | AVGO | 2026-09-14 15:23 | straddle | 2 | 2 | 21 | 62580.00 | unknown | — | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | [] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:24:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a160-a081-7a01-8b80-036d6ca2d099 | AVGO | 2026-09-14 15:24 | straddle | 2 | 1 | 10 | 29850.00 | short | bid | 345.1875 | 0.4500 | ["350"] | ["0.3632"] | ["320.15","379.85"] | ["XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:24:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a160-bbd9-7a01-96a4-0e68239a2fb3 | AVGO | 2026-09-14 15:24 | straddle | 2 | 2 | 10 | 29900.00 | long | ask | 345.2300 | 0.4500 | ["350"] | ["0.3638"] | ["320.10","379.90"] | ["AMXO","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:24:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0abc1-a7c3-7a33-9e2f-9ab80d1916e0 | AVGO | 2026-09-16 15:46 | straddle | 2 | 1 | 2 | 35040.00 | unknown | — | 339.1100 | 2.6000 | ["340"] | ["0.4579"] | [] | ["XISX"] | 340.0000 | 340.0000 | 821 | 821 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:46:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0b510-96bf-7763-8e79-26fd4ce92b27 | AVGO | 2026-09-18 11:09 | straddle | 2 | 1 | 50 | 138250.00 | short | bid | 357.7950 | 0.5000 | ["360"] | ["0.3491"] | ["332.35","387.65"] | ["XBOX"] | 360.0000 | 360.0000 | 28 | 28 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:09:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b522-9c07-7f22-8365-6d85846d01e6 | AVGO | 2026-09-18 11:28 | straddle | 2 | 7 | 8 | 53472.00 | long | ask | 357.4800 | 0.6000 | ["370"] | ["0.4055"] | ["303.16","436.84"] | ["BATO","C2OX","EDGO","XCBO","XISX","XMIO","XPHO"] | 370.0000 | 370.0000 | 119 | 119 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:29:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c539-ff9f-7860-865a-c1de66a49e8d | AVGO | 2026-09-21 14:28 | straddle | 2 | 1 | 10 | 182800.00 | unknown | — | 361.5600 | 3.7000 | ["330"] | ["0.4564"] | [] | ["XMIO"] | 330.0000 | 330.0000 | 816 | 816 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:28:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c574-8be7-71a2-9588-91409ffb22c5 | AVGO | 2026-09-21 15:32 | straddle | 2 | 1 | 2 | 33584.00 | long | ask | 363.4916 | 3.6000 | ["360"] | ["0.4615"] | ["192.08","527.92"] | ["XBOX"] | 360.0000 | 360.0000 | 634 | 634 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:32:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |