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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a5aa-bce6-7f71-8c36-e942b56ddb2b | INSW | 2026-09-15 11:23 | call_calendar | 2 | 1 | 700 | 355000.00 | unknown | — | 109.1500 | 1.1500 | ["110"] | ["0.4222"] | [] | ["ARCO"] | 110.0000 | 110.0000 | 3 | 31 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:24:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a087b8-30f8-7b71-8163-c140052ffd3c | INSW | 2026-09-09 15:49 | other | 3 | 1 | 60 | 206160.00 | unknown | — | 104.6800 | 5.7000 | ["75","85","95"] | ["1.8019","0.7896","0.5736"] | [] | ["XPHO"] | 75.0000 | 95.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:50:04Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087b7-fe30-7ff3-b301-983770c7755b | INSW | 2026-09-09 15:49 | other | 3 | 1 | 60 | 206160.00 | unknown | — | 104.6800 | 5.7000 | ["75","85","95"] | ["1.8019","0.7896","0.5736"] | [] | ["XPHO"] | 75.0000 | 95.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:49:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087b7-cf50-7dc1-b6f6-846534b481a4 | INSW | 2026-09-09 15:49 | other | 3 | 1 | 60 | 206160.00 | unknown | — | 104.6800 | 5.7000 | ["75","85","95"] | ["1.8019","0.7896","0.5736"] | [] | ["XPHO"] | 75.0000 | 95.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:49:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087b7-9c88-7930-8210-2986c01a98c2 | INSW | 2026-09-09 15:49 | other | 3 | 1 | 80 | 274880.00 | unknown | — | 104.6800 | 5.7000 | ["75","85","95"] | ["1.8019","0.7896","0.5736"] | [] | ["XPHO"] | 75.0000 | 95.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:49:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-4be8-7de3-956f-767d34b002cd | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8200 | 9.5000 | ["80","85","95"] | ["0.2625","0.3795","0.5197"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:38:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-3479-72e1-8ec2-f9b20f3b41de | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8800 | 9.5000 | ["80","85","95"] | ["0.2551","0.3744","0.5010"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-3090-7312-8084-ee07cc61011f | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8800 | 9.5000 | ["80","85","95"] | ["0.2551","0.3744","0.5010"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-2ca8-76f1-b50f-2c16449c80a1 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-24d8-7193-912a-3dfbb0deca68 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-20f0-7303-afb2-8243c23f21f2 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-1d08-7150-94c8-e2563d7f8e03 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-1920-7c71-9222-eb5e927cd0d6 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-1150-7e72-b745-ac2068f48bb4 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-0d68-7ec2-a74b-2ca66b3176a8 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-0980-7473-aca1-48faffac98e9 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-0598-70c0-9ee3-b5d69704a22c | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ac-fdc8-7b11-8f1a-0361f2d19111 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ac-f9e0-7072-9c4a-7a1bee364f7e | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ac-f5f8-7081-b1aa-6e3dfddedf14 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ac-f211-7f80-b61f-706b31b82a8a | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ac-ea40-71a3-bbf0-5fa4b3c96db7 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ac-e658-7a41-991e-eae6ccbf9082 | INSW | 2026-09-09 15:37 | other | 3 | 1 | 120 | 398400.00 | unknown | — | 104.8300 | 9.5000 | ["80","85","95"] | ["0.2613","0.3787","0.5167"] | [] | ["XPHO"] | 80.0000 | 95.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:37:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0876b-0ee0-7f22-867e-0a4a10121cfe | INSW | 2026-09-09 14:25 | other | 3 | 1 | 20 | 168440.00 | unknown | — | 105.2250 | 11.0000 | ["40","70"] | ["1.3665","1.2628"] | [] | ["XPHO"] | 40.0000 | 70.0000 | 9 | 191 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:26:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06d48-d025-7c90-8fa6-cae4979cb095 | INSW | 2026-09-04 12:38 | call_vertical_spread | 2 | 1 | 100 | 234000.00 | unknown | — | 103.3150 | 5.5000 | ["100","105"] | ["0.3310","0.3461"] | [] | ["XBOX"] | 100.0000 | 105.0000 | 196 | 196 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:38:21Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |