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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60f-f1d8-7960-97d8-8b9da5e12d07 | MRVL | 2026-09-18 15:48 | straddle | 2 | 1 | 229 | 43510.00 | long | ask | 238.9001 | 0.5300 | ["240"] | ["1.8469"] | ["238.10","241.90"] | ["AMXO"] | 240.0000 | 240.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b540-2a6f-73a0-94ce-f17808d55e14 | MRVL | 2026-09-18 12:01 | straddle | 2 | 1 | 100 | 162001.00 | short | bid | 238.1750 | 0.7500 | ["245"] | ["0.5734"] | ["228.80","261.20"] | ["XMIO"] | 245.0000 | 245.0000 | 7 | 7 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:01:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aa83-9213-7332-bfb9-cebe01ea7f73 | MRVL | 2026-09-16 09:59 | straddle | 2 | 2 | 26 | 91299.00 | short | bid | 232.8500 | 0.7500 | ["230"] | ["0.6632"] | ["194.88","265.12"] | ["EDGO","XCBO"] | 230.0000 | 230.0000 | 30 | 30 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:59:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a102-b970-7b91-8c6b-becfd89292c6 | MRVL | 2026-09-14 13:41 | straddle | 2 | 1 | 2 | 33820.00 | short | bid | 222.9500 | 2.4500 | ["220"] | ["0.6872"] | ["50.90","389.10"] | ["XBOX"] | 220.0000 | 220.0000 | 858 | 858 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:41:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ce-9d98-7a51-8efb-119836e195b3 | MRVL | 2026-09-14 12:44 | straddle | 2 | 2 | 75 | 854250.00 | short | bid | 222.0500 | 5.0000 | ["220"] | ["0.6714"] | ["106.10","333.90"] | ["ARCO"] | 220.0000 | 220.0000 | 368 | 368 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:44:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08bd5-b430-72d1-bc7a-61cde4121815 | MRVL | 2026-09-10 11:00 | straddle | 2 | 1 | 500 | 3982500.00 | long | ask | 232.7150 | 1.1500 | ["260"] | ["0.6771"] | ["180.35","339.65"] | ["SPHR"] | 260.0000 | 260.0000 | 127 | 127 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:00:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0824c-30d8-7f10-b632-87333c8e9c38 | MRVL | 2026-09-08 14:33 | straddle | 2 | 6 | 15 | 53475.00 | long | ask | 228.6800 | 0.3333 | ["230"] | ["0.6713"] | ["194.35","265.65"] | ["MCRY","XISX","XPHO"] | 230.0000 | 230.0000 | 31 | 31 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:34:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0824c-30d8-7f10-b632-872ad58d910f | MRVL | 2026-09-08 14:33 | straddle | 2 | 2 | 16 | 48000.00 | unknown | — | 228.6800 | 0.3500 | ["230"] | ["0.6407"] | [] | ["EMLD","XISX"] | 230.0000 | 230.0000 | 24 | 24 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:34:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08171-78a8-7b93-860a-ff1d90f4c373 | MRVL | 2026-09-08 10:34 | straddle | 2 | 2 | 12 | 69516.00 | short | bid | 228.2300 | 1.0500 | ["270"] | ["0.6831"] | ["212.07","327.93"] | ["EMLD","XISX"] | 270.0000 | 270.0000 | 45 | 45 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:35:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e00-73dd-7162-86c0-805f9f78d407 | MRVL | 2026-09-04 15:58 | straddle | 2 | 3 | 3 | 35139.00 | short | bid | 223.6600 | 0.5000 | ["270"] | ["0.6715"] | ["152.87","387.13"] | ["BATO","C2OX","EDGO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:58:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dff-2bbd-7dc1-9163-2eccc7e634ca | MRVL | 2026-09-04 15:57 | straddle | 2 | 1 | 3 | 35127.00 | short | bid | 223.5400 | 0.7000 | ["270"] | ["0.6713"] | ["152.91","387.09"] | ["XPHO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:57:24Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfe-aad5-7892-95cc-efbcf2715c64 | MRVL | 2026-09-04 15:56 | straddle | 2 | 1 | 7 | 81942.00 | long | ask | 223.5200 | 0.9000 | ["270"] | ["0.6711"] | ["152.94","387.06"] | ["XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfe-54e5-7d00-a799-1e67dce0865a | MRVL | 2026-09-04 15:56 | straddle | 2 | 1 | 8 | 93576.00 | short | bid | 223.4600 | 0.9500 | ["270"] | ["0.6705"] | ["153.03","386.97"] | ["XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:18Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-ce45-7f71-9459-dec8b476edad | MRVL | 2026-09-04 15:54 | straddle | 2 | 6 | 13 | 151840.00 | long | ask | 223.1449 | 1.0615 | ["270"] | ["0.6695"] | ["153.20","386.80"] | ["AMXO","XCBO","XISX","XPHO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-5915-7850-a7eb-23c17efeec63 | MRVL | 2026-09-04 15:54 | straddle | 2 | 2 | 14 | 163324.00 | long | ask | 223.1650 | 1.4714 | ["270"] | ["0.6686"] | ["153.34","386.66"] | ["XISX","XPHO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-0325-76c3-9101-23493a5e028f | MRVL | 2026-09-04 15:53 | straddle | 2 | 2 | 4 | 46620.00 | long | ask | 223.2700 | 0.8000 | ["270"] | ["0.6679"] | ["153.45","386.55"] | ["AMXO","XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-0325-76c3-9101-233b95977913 | MRVL | 2026-09-04 15:53 | straddle | 2 | 1 | 8 | 93256.00 | long | ask | 223.2700 | 1.3000 | ["270"] | ["0.6680"] | ["153.43","386.57"] | ["XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d37-095d-7bd1-b08e-6ed0c93d57b0 | MRVL | 2026-09-04 12:18 | straddle | 2 | 2 | 250 | 62500.00 | short | bid | 221.1500 | 0.2100 | ["220"] | ["0.6422"] | ["217.50","222.50"] | ["AMXO"] | 220.0000 | 220.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:19:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |