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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5c7-86c7-7771-a586-e111416057bb | IBM | 2026-09-18 14:29 | other | 2 | 2 | 20 | 179800.00 | unknown | ask | 230.8700 | 1.2000 | ["225","300"] | ["0.3955","0.4893"] | [] | ["XMIO"] | 225.0000 | 300.0000 | 63 | 91 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:29:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c0-37b0-72e2-8db1-ec16b413241f | IBM | 2026-09-18 14:21 | other | 2 | 3 | 18 | 161910.00 | unknown | bid | 230.7100 | 2.3556 | ["225","300"] | ["0.3857","0.5015"] | [] | ["AMXO","EMLD","XBOX"] | 225.0000 | 300.0000 | 63 | 91 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:21:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fd-2dff-7133-95e4-fd9cfb6e0971 | IBM | 2026-09-18 10:48 | call_ratio_spread | 2 | 1 | 180 | 171675.00 | unknown | — | 229.6300 | 0.6000 | ["235","240"] | ["0.3348","0.3353"] | [] | ["XISX"] | 235.0000 | 240.0000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:48:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0e8-7123-76a2-be08-3d1c969f3aee | IBM | 2026-09-17 15:46 | call_calendar | 2 | 1 | 10 | 195100.00 | unknown | — | 237.7300 | 6.8000 | ["160"] | ["0.2586"] | [] | ["XPHO"] | 160.0000 | 160.0000 | 820 | 855 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:47:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e7-1964-75a3-ba10-68cc25406518 | IBM | 2026-09-17 15:45 | call_calendar | 2 | 1 | 6 | 113268.00 | unknown | — | 237.7400 | 7.4500 | ["165"] | ["0.2706"] | [] | ["XMIO"] | 165.0000 | 165.0000 | 820 | 855 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:45:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd9-8993-7ce1-834f-42ea05ace3f5 | IBM | 2026-09-17 10:51 | other | 4 | 4 | 58 | 256119.00 | unknown | — | 238.3900 | 4.4000 | ["240","245"] | ["0.4427","0.4422"] | [] | ["ARCO","EMLD"] | 240.0000 | 245.0000 | 43 | 43 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:51:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a616-c525-7342-affa-fbc31d92ab20 | IBM | 2026-09-15 13:21 | call_vertical_spread | 2 | 1 | 60 | 135000.00 | unknown | — | 251.2250 | 2.1500 | ["400","410"] | ["0.3643","0.3657"] | [] | ["XISX"] | 400.0000 | 410.0000 | 493 | 493 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:21:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60e-5116-7941-8cc7-d99297238386 | IBM | 2026-09-15 13:12 | call_diagonal_spread | 2 | 1 | 300 | 408000.00 | unknown | — | 251.4250 | 0.6000 | ["260","285"] | ["0.3433","0.4072"] | [] | ["XISX"] | 260.0000 | 285.0000 | 31 | 66 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:13:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a12a-0020-70f1-8e4a-e53fabf6c583 | IBM | 2026-09-14 14:24 | other | 2 | 1 | 30 | 121650.00 | unknown | — | 249.4950 | 1.0000 | ["250","255"] | ["0.3801","0.3693"] | [] | ["XPHO"] | 250.0000 | 255.0000 | 95 | 123 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:25:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0bf-47d0-7c00-86b5-6129688dae97 | IBM | 2026-09-14 12:28 | other | 2 | 1 | 300 | 410400.00 | unknown | — | 251.0650 | 0.6500 | ["260","285"] | ["0.3449","0.4092"] | [] | ["MCRY"] | 260.0000 | 285.0000 | 32 | 67 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:28:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0bd-ec28-7072-ab0d-706bbba12ba8 | IBM | 2026-09-14 12:26 | put_vertical_spread | 2 | 1 | 292 | 1854200.00 | unknown | — | 250.9300 | 4.1000 | ["265","280"] | ["0.4505","0.4574"] | [] | ["XPHO"] | 265.0000 | 280.0000 | 67 | 67 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:26:41Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ba-17b0-7213-bb3f-8eb10f02be5e | IBM | 2026-09-14 12:22 | other | 4 | 1 | 20 | 213300.00 | unknown | — | 251.0400 | 4.0500 | ["230","235","245","250"] | ["0.3679","0.4105","0.3691","0.4061"] | [] | ["BATO"] | 230.0000 | 250.0000 | 67 | 123 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:22:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ba-17b0-7213-bb3f-8ea143ac65f4 | IBM | 2026-09-14 12:22 | other | 4 | 1 | 16 | 170320.00 | unknown | — | 251.0400 | 2.2500 | ["230","235","245","250"] | ["0.3644","0.4089","0.3684","0.4078"] | [] | ["BATO"] | 230.0000 | 250.0000 | 67 | 123 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:22:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ba-17b0-7213-bb3f-8e8e2da2b4dd | IBM | 2026-09-14 12:22 | other | 4 | 5 | 18 | 191540.00 | unknown | — | 251.0400 | 4.6500 | ["230","235","245","250"] | ["0.3643","0.4090","0.3681","0.4075"] | [] | ["ARCO","BATO","EDGO","XCBO","XISX"] | 230.0000 | 250.0000 | 67 | 123 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:22:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ba-17b0-7213-bb3f-8e7501ed060f | IBM | 2026-09-14 12:22 | other | 4 | 1 | 10 | 106430.00 | unknown | — | 251.0400 | 4.6500 | ["230","235","245","250"] | ["0.3644","0.4087","0.3684","0.4075"] | [] | ["BATO"] | 230.0000 | 250.0000 | 67 | 123 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:22:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ba-17b0-7213-bb3f-8e6eca3ebeb1 | IBM | 2026-09-14 12:22 | other | 4 | 1 | 27 | 288036.00 | unknown | — | 251.0400 | 5.3000 | ["230","235","245","250"] | ["0.3580","0.3928","0.3815","0.4177"] | [] | ["XBOX"] | 230.0000 | 250.0000 | 67 | 123 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:22:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09e-b7e0-7ed3-9664-a12f137bdb4c | IBM | 2026-09-14 11:52 | call_vertical_spread | 2 | 1 | 375 | 295125.00 | unknown | — | 248.7400 | 0.4500 | ["265","270"] | ["0.3450","0.3463"] | [] | ["XISX"] | 265.0000 | 270.0000 | 32 | 32 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:52:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09e-7d48-7280-8687-9adf4ebeb8c4 | IBM | 2026-09-14 11:52 | call_vertical_spread | 2 | 1 | 375 | 296625.00 | unknown | — | 248.8200 | 0.4500 | ["265","270"] | ["0.3448","0.3463"] | [] | ["XISX"] | 265.0000 | 270.0000 | 32 | 32 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:52:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09e-36f8-7dc2-b70f-30846cd7739d | IBM | 2026-09-14 11:51 | call_vertical_spread | 2 | 1 | 250 | 149750.00 | unknown | — | 248.5450 | 0.7500 | ["260","265"] | ["0.3503","0.3511"] | [] | ["BATO"] | 260.0000 | 265.0000 | 18 | 18 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:52:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a027-68e9-7431-bdd8-907f2401f2ec | IBM | 2026-09-14 09:42 | other | 2 | 3 | 418 | 257145.00 | unknown | — | 244.6300 | 0.7100 | ["250","275"] | ["0.3469","0.3677"] | [] | ["ARCO","XBOX","XPHO"] | 250.0000 | 275.0000 | 32 | 32 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:42:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c69-4588-7210-82e0-0b390d63a63e | IBM | 2026-09-10 13:41 | put_vertical_spread | 2 | 2 | 82 | 105428.00 | unknown | — | 235.6700 | 0.4000 | ["220","235"] | ["0.3415","0.3404"] | [] | ["ARCO","XBOX"] | 220.0000 | 235.0000 | 36 | 36 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:42:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c69-3db8-7e51-b506-9da32f62e50b | IBM | 2026-09-10 13:41 | put_vertical_spread | 2 | 4 | 116 | 149226.00 | unknown | — | 235.6800 | 0.3500 | ["220","235"] | ["0.3422","0.3404"] | [] | ["MCRY","XBOX","XCBO"] | 220.0000 | 235.0000 | 36 | 36 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:42:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b9f-def0-7a13-8989-847ae81d7902 | IBM | 2026-09-10 10:01 | call_vertical_spread | 2 | 1 | 18 | 163440.00 | unknown | — | 237.0000 | 6.0500 | ["235","320"] | ["0.3363","0.3528"] | [] | ["XISX"] | 235.0000 | 320.0000 | 827 | 827 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:01:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b99-5328-7ce0-8b52-c2280f472441 | IBM | 2026-09-10 09:54 | other | 2 | 1 | 300 | 243300.00 | unknown | — | 240.5000 | 0.5500 | ["245","260"] | ["0.3921","0.3615"] | [] | ["XISX"] | 245.0000 | 260.0000 | 8 | 36 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:54:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b98-f569-7d82-96e9-cd1000cd7e13 | IBM | 2026-09-10 09:54 | call_diagonal_spread | 2 | 1 | 300 | 247500.00 | unknown | — | 240.5100 | 0.5500 | ["245","260"] | ["0.3969","0.3642"] | [] | ["XISX"] | 245.0000 | 260.0000 | 8 | 36 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:54:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087bd-0358-74d2-8761-f23bc2c39144 | IBM | 2026-09-09 15:55 | other | 3 | 1 | 10 | 202760.00 | unknown | — | 240.3800 | 11.3000 | ["160","190","320"] | ["0.2633","0.3145","0.3463"] | [] | ["XMIO"] | 160.0000 | 320.0000 | 499 | 828 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:55:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08763-8148-77a1-a322-e0768304e0d4 | IBM | 2026-09-09 14:17 | other | 4 | 1 | 50 | 215200.00 | unknown | — | 238.6300 | 3.0000 | ["250","270"] | ["0.3817","0.3872"] | [] | ["XISX"] | 250.0000 | 270.0000 | 72 | 100 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:17:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0828c-8598-7021-850a-60681e24d010 | IBM | 2026-09-08 15:43 | other | 3 | 1 | 240 | 105210.00 | unknown | — | 232.6900 | 0.7300 | ["242.5","245","250"] | ["0.3417","0.3259","0.3295"] | [] | ["XMIO"] | 242.5000 | 250.0000 | 10 | 17 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:44:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |