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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b619-5047-7b20-a9bd-f35a490bf840 | BE | 2026-09-18 15:58 | strangle | 2 | 1 | 30 | 210240.00 | short | bid | 266.0000 | 5.2500 | ["210","280"] | ["67.3170","28.0654"] | ["209.92","280.08"] | ["XISX"] | 210.0000 | 280.0000 | 0 | 0 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:58:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afe3-1acb-72b2-a057-a402e889a3ca | BE | 2026-09-17 11:01 | strangle | 2 | 1 | 4225 | 722475.00 | unknown | — | 278.6050 | 0.3900 | ["265","307.5"] | ["1.0542","1.0473"] | [] | ["XPHO"] | 265.0000 | 307.5000 | 1 | 1 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:01:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9b-ffab-7791-9751-152414715e8c | BE | 2026-09-17 09:43 | strangle | 2 | 1 | 10 | 276650.00 | unknown | — | 281.8300 | 6.2000 | ["220","340"] | ["0.8822","0.9041"] | [] | ["XMIO"] | 220.0000 | 340.0000 | 491 | 491 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:43:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab16-ae3b-7053-a5ff-e09342317a6c | BE | 2026-09-16 12:39 | strangle | 2 | 1 | 19 | 229919.00 | unknown | — | 269.8300 | 3.9000 | ["210","510"] | ["0.8852","0.8819"] | [] | ["XISX"] | 210.0000 | 510.0000 | 492 | 492 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:40:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab12-222b-7682-a038-854e64445b9e | BE | 2026-09-16 12:34 | strangle | 2 | 1 | 15 | 181875.00 | unknown | — | 269.2900 | 4.4000 | ["210","510"] | ["0.8861","0.8844"] | [] | ["MCRY"] | 210.0000 | 510.0000 | 492 | 492 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:34:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69c-160e-7762-b6d4-c0ce304ac58e | BE | 2026-09-15 15:47 | strangle | 2 | 1 | 5500 | 2887500.00 | short | bid | 258.2700 | 0.2600 | ["247.5","290"] | ["0.9419","0.9548"] | ["242.25","295.25"] | ["XPHO"] | 247.5000 | 290.0000 | 3 | 3 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:47:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a086b5-f781-7ed2-bd75-38b58be03d33 | BE | 2026-09-09 11:07 | strangle | 2 | 1 | 30 | 105300.00 | unknown | — | 275.0750 | 1.4500 | ["250","310"] | ["0.8452","0.8746"] | [] | ["XISX"] | 250.0000 | 310.0000 | 37 | 37 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:07:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08294-a3b8-7a93-9ade-3462a6df2b5f | BE | 2026-09-08 15:52 | strangle | 2 | 1 | 63 | 444528.00 | short | bid | 279.3800 | 1.0300 | ["175","210"] | ["1.2803","1.0176"] | ["104.44","280.56"] | ["XCBO"] | 175.0000 | 210.0000 | 10 | 10 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:53:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08161-2110-77b1-bd69-f7323859f169 | BE | 2026-09-08 10:16 | strangle | 2 | 1 | 17 | 148750.00 | long | ask | 275.0923 | 2.6000 | ["250","290"] | ["0.9341","0.9466"] | ["162.50","377.50"] | ["XISX"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:17:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08160-fa01-7071-a1f6-1f0a7a5775a2 | BE | 2026-09-08 10:16 | strangle | 2 | 4 | 36 | 314658.00 | long | ask | 274.9300 | 2.0000 | ["250","290"] | ["0.9328","0.9468"] | ["162.60","377.40"] | ["SPHR","XCBO","XPHO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:17:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08160-f618-7560-ab11-de722c7638cb | BE | 2026-09-08 10:16 | strangle | 2 | 1 | 13 | 113490.00 | long | ask | 275.0550 | 1.0000 | ["250","290"] | ["0.9331","0.9441"] | ["162.70","377.30"] | ["ARCO"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:17:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08160-f230-7ad1-be5e-1250ad5c242c | BE | 2026-09-08 10:16 | strangle | 2 | 1 | 15 | 130965.00 | unknown | — | 274.9187 | 1.6000 | ["250","290"] | ["0.9307","0.9471"] | [] | ["XISX"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:17:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08160-ee48-7160-8e95-4ad00334fb6a | BE | 2026-09-08 10:16 | strangle | 2 | 1 | 16 | 139248.00 | long | ask | 274.9100 | 2.2000 | ["250","290"] | ["0.9280","0.9447"] | ["162.97","377.03"] | ["XISX"] | 250.0000 | 290.0000 | 101 | 101 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:17:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813b-5d19-7153-91a1-56b6905275fa | BE | 2026-09-08 09:35 | strangle | 2 | 2 | 98 | 569990.00 | short | bid | 272.4850 | 1.9327 | ["190","230"] | ["0.8939","0.8749"] | ["131.84","288.16"] | ["ARCO","XBOX"] | 190.0000 | 230.0000 | 38 | 38 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:35:50Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |