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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d75-336d-7572-ab68-515af11b7111 | AVGO | 2026-09-04 13:26 | synthetic | 2 | 2 | 2 | 36792.00 | short | bid | 354.8400 | 1.5500 | ["340"] | ["0.4527"] | ["382.10"] | ["BATO","C2OX"] | 340.0000 | 340.0000 | 833 | 833 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:26:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d75-336d-7572-ab68-514ca7cce990 | AVGO | 2026-09-04 13:26 | synthetic | 2 | 3 | 4 | 73738.00 | short | bid | 354.8400 | 1.8000 | ["340"] | ["0.4538"] | ["382.10"] | ["EMLD","SPHR","XBOX"] | 340.0000 | 340.0000 | 833 | 833 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:26:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dc6-fced-7252-bc1f-6725fc45b294 | AVGO | 2026-09-04 14:55 | synthetic | 2 | 3 | 4 | 74798.00 | short | bid | 356.9500 | 2.1500 | ["350"] | ["0.4552"] | ["385.40"] | ["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:56:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dc7-27e5-7ba1-809c-dd91611ca177 | AVGO | 2026-09-04 14:56 | synthetic | 2 | 2 | 2 | 37408.00 | long | ask | 356.9350 | 1.6500 | ["350"] | ["0.4553"] | ["385.50"] | ["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:56:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dc9-8945-7060-9f79-ed20d567597d | AVGO | 2026-09-04 14:58 | synthetic | 2 | 2 | 2 | 37559.00 | short | bid | 356.7500 | 2.9000 | ["350"] | ["0.4575"] | ["385.18"] | ["BATO","C2OX"] | 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 |
| 01a0815c-eed8-7bb2-be45-04ac85d0ec65 | AVGO | 2026-09-08 10:12 | synthetic | 2 | 1 | 2 | 38580.00 | short | bid | 367.3900 | 4.3500 | ["350"] | ["0.4689"] | ["395.80"] | ["XCBO"] | 350.0000 | 350.0000 | 829 | 829 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:12:29Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b4-de90-7ff3-9688-f31ed573e8e2 | AVGO | 2026-09-08 11:48 | synthetic | 2 | 2 | 2 | 30400.00 | unknown | — | 369.8000 | 4.3500 | ["370"] | ["0.4558"] | [] | ["C2OX","XBOX"] | 370.0000 | 370.0000 | 500 | 500 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:48:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0865c-d718-7f12-9b6d-2652930c6069 | AVGO | 2026-09-09 09:30 | synthetic | 2 | 4 | 4 | 52018.00 | long | ask | 367.2800 | 5.1875 | ["360"] | ["0.4574"] | ["381.69"] | ["AMXO","XBOX","XISX","XPHO"] | 360.0000 | 360.0000 | 373 | 373 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:30:30Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a2-34e8-7eb3-9a18-ad1eaf7ce55f | AVGO | 2026-09-09 10:46 | synthetic | 2 | 1 | 2 | 28602.00 | short | bid | 363.2300 | 3.1000 | ["330"] | ["0.4625"] | ["379.25"] | ["MCRY"] | 330.0000 | 330.0000 | 464 | 464 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:46:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c31-e9a8-7470-916c-285a832a75ac | AVGO | 2026-09-10 12:41 | synthetic | 2 | 1 | 4 | 80948.00 | long | bid | 362.9738 | 4.0500 | ["400"] | ["0.4809"] | ["395.75"] | ["EMLD"] | 400.0000 | 400.0000 | 827 | 827 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:41:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c96-3d40-7293-8bb6-2b98225583b3 | AVGO | 2026-09-10 14:30 | synthetic | 2 | 3 | 5 | 95130.00 | short | bid | 362.4101 | 2.0000 | ["350"] | ["0.4750"] | ["391.30"] | ["EMLD","SPHR","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:31:18Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091cd-5e39-7d90-ab97-c1b476fe8cf6 | AVGO | 2026-09-11 14:49 | synthetic | 2 | 2 | 5 | 43892.00 | short | bid | 363.8550 | 2.0000 | ["350"] | ["0.4294"] | ["371.00"] | ["EDGO","EMLD"] | 350.0000 | 350.0000 | 189 | 189 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:49:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a051-c0c0-7d21-912d-14ba93eed709 | AVGO | 2026-09-14 10:28 | synthetic | 2 | 1 | 3 | 54960.00 | unknown | — | 346.0950 | 3.9500 | ["350"] | ["0.4680"] | [] | ["XISX"] | 350.0000 | 350.0000 | 823 | 823 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:28:36Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a9-0880-7b92-a710-1c4711aa29a3 | AVGO | 2026-09-14 12:03 | synthetic | 2 | 2 | 2 | 27054.00 | unknown | — | 346.5300 | 3.4500 | ["440"] | ["0.4479"] | [] | ["SPHR","XBOX"] | 440.0000 | 440.0000 | 276 | 276 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:04:17Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a160-5a30-7611-a93c-0090be88bfb3 | AVGO | 2026-09-14 15:23 | synthetic | 2 | 2 | 21 | 62580.00 | long | bid | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | ["346.10"] | ["XISX","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 |
| 01a0a160-5648-7572-9365-d2b68adfa845 | AVGO | 2026-09-14 15:23 | synthetic | 2 | 2 | 15 | 44700.00 | long | bid | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | ["346.10"] | ["XISX","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 |
| 01a0a160-b7f0-7250-85f1-9bcd659e09e8 | AVGO | 2026-09-14 15:24 | synthetic | 2 | 2 | 11 | 32890.00 | long | bid | 345.2000 | 0.1000 | ["350"] | ["0.3638"] | ["346"] | ["XISX","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 |
| 01a0a160-b7f0-7250-85f1-9bbc0382c1a6 | AVGO | 2026-09-14 15:24 | synthetic | 2 | 2 | 15 | 44850.00 | long | bid | 345.2000 | 0.3500 | ["350"] | ["0.3638"] | ["346"] | ["XISX","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 |
| 01a0a59c-d64e-7a01-bbfa-032980531786 | AVGO | 2026-09-15 11:08 | synthetic | 2 | 1 | 10 | 175990.00 | short | bid | 342.4150 | 4.3000 | ["330"] | ["0.4482"] | ["370.25"] | ["XISX"] | 330.0000 | 330.0000 | 822 | 822 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:08:36Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a66c-a96e-7ed0-bca3-0c10e71ec1ca | AVGO | 2026-09-15 14:55 | synthetic | 2 | 1 | 75 | 609000.00 | short | ask | 340.3250 | 1.5500 | ["350"] | ["0.4159"] | ["346.30"] | ["XBOX"] | 350.0000 | 350.0000 | 185 | 185 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:55:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0ab80-7073-7de0-8170-e3727cdcbfb5 | AVGO | 2026-09-16 14:35 | synthetic | 2 | 2 | 2 | 32644.00 | short | ask | 338.6100 | 6.0000 | ["380"] | ["0.4551"] | ["363.12"] | ["C2OX","SPHR"] | 380.0000 | 380.0000 | 639 | 639 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:35:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab94-795a-7991-9c34-a291893a92ac | AVGO | 2026-09-16 14:57 | synthetic | 2 | 1 | 5 | 58010.00 | short | bid | 337.4250 | 4.8000 | ["350"] | ["0.4359"] | ["352.00"] | ["BATO"] | 350.0000 | 350.0000 | 366 | 366 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:57:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab95-8acb-7533-8c51-c77e2229efdc | AVGO | 2026-09-16 14:58 | synthetic | 2 | 3 | 6 | 25216.00 | long | bid | 337.1000 | 1.0000 | ["340"] | ["0.3704"] | ["339.11"] | ["AMXO","XCBO","XISX"] | 340.0000 | 340.0000 | 65 | 65 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:58:36Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba1-526a-71b2-9adf-2f5c3e517e31 | AVGO | 2026-09-16 15:11 | synthetic | 2 | 3 | 3 | 34678.00 | short | bid | 336.2800 | 4.8000 | ["350"] | ["0.4351"] | ["350"] | ["C2OX","EMLD","SPHR"] | 350.0000 | 350.0000 | 366 | 366 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:11:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0b033-4253-77b0-bc59-782fc84a8a87 | AVGO | 2026-09-17 12:29 | synthetic | 2 | 1 | 3 | 53688.00 | short | bid | 348.1600 | 3.2000 | ["350"] | ["0.4556"] | ["377.40"] | ["XMIO"] | 350.0000 | 350.0000 | 820 | 820 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:29:14Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b044-e9db-7da0-9b70-0ea99a8d4be2 | AVGO | 2026-09-17 12:48 | synthetic | 2 | 1 | 3 | 35337.00 | long | ask | 349.0800 | 1.4500 | ["350"] | ["0.4331"] | ["362.75"] | ["XISX"] | 350.0000 | 350.0000 | 365 | 365 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:49:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4c6-dbc0-7612-ae8b-c4b324d461bc | AVGO | 2026-09-18 09:48 | synthetic | 2 | 3 | 3 | 25600.00 | long | ask | 361.2900 | 4.0500 | ["350"] | ["0.4254"] | ["368.00"] | ["C2OX","EMLD","SPHR"] | 350.0000 | 350.0000 | 182 | 182 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:48:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-1388-7321-a814-f671ce34768d | AVGO | 2026-09-18 10:10 | synthetic | 2 | 1 | 2 | 36850.00 | long | ask | 360.9800 | 3.9500 | ["350"] | ["0.4563"] | ["390.55"] | ["XISX"] | 350.0000 | 350.0000 | 819 | 819 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |