Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c501-8e67-7211-b327-1c65c67f568c | LRCX | 2026-09-21 13:26 | other | 3 | 1 | 5 | 110320.00 | unknown | bid | 300.4800 | 10.6500 | ["210","250","450"] | ["0.6231","0.6025","0.5945"] | [] | ["XCBO"] | 210.0000 | 450.0000 | 487 | 816 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:27:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4d0-e946-7d51-bab0-4770a8162bdd | LRCX | 2026-09-21 12:33 | iron_condor | 4 | 1 | 540 | 1814940.00 | unknown | — | 300.7400 | 2.9600 | ["250","275","282.5","307.5"] | ["0.8015","0.5960","0.6763","0.6143"] | [] | ["XCBO"] | 250.0000 | 307.5000 | 4 | 4 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:33:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c473-b9cf-7b60-a477-2b2bd31e5089 | LRCX | 2026-09-21 10:51 | other | 4 | 1 | 8 | 194008.00 | unknown | ask | 294.7300 | 7.6000 | ["220","230","250","282.5"] | ["0.5998","0.5960","0.6149","0.5946"] | [] | ["XMIO"] | 220.0000 | 282.5000 | 11 | 487 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:52:05Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b4eb-d0af-7160-8737-1ac18a2aaa3b | LRCX | 2026-09-18 10:29 | put_vertical_spread | 2 | 1 | 100 | 194300.00 | unknown | bid | 280.3150 | 1.0000 | ["280","285"] | ["0.5548","0.5571"] | ["272.78"] | ["XCBO"] | 280.0000 | 285.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:29:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d8-5fdb-7072-ac65-d1bcf55d0b51 | LRCX | 2026-09-17 15:29 | other | 4 | 1 | 1080 | 857848.00 | unknown | — | 269.1700 | 0.8400 | ["250","255","275","285"] | ["0.5347","0.6429","0.5062","0.6687"] | [] | ["AMXO"] | 250.0000 | 285.0000 | 1 | 8 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:29:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c9-350b-7cf0-9df7-5cf33f33d5e0 | LRCX | 2026-09-17 15:12 | call_vertical_spread | 2 | 1 | 3 | 103290.00 | unknown | — | 269.8600 | 6.4000 | ["95","100"] | ["11.2301","10.7206"] | [] | ["XCBO"] | 95.0000 | 100.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:13:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b099-8dd3-7bc2-a218-085afbc1326e | LRCX | 2026-09-17 14:20 | put_vertical_spread | 2 | 1 | 40 | 316480.00 | unknown | — | 269.2900 | 1.7000 | ["270","290"] | ["0.5721","0.5719"] | [] | ["XCBO"] | 270.0000 | 290.0000 | 120 | 120 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:21:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b079-76fb-7062-944e-6a92ba05c022 | LRCX | 2026-09-17 13:45 | other | 4 | 1 | 2046 | 1966206.00 | unknown | — | 269.1550 | 1.1500 | ["275","280","282.5"] | ["0.5012","0.6216","0.5722"] | [] | ["XCBO"] | 275.0000 | 282.5000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:45:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b042-ee0b-7b22-9990-c8f77a07f28c | LRCX | 2026-09-17 12:46 | other | 4 | 1 | 5 | 143365.00 | unknown | — | 267.5900 | 9.2800 | ["130","350","355"] | ["3.5376","0.5840","3.0826"] | [] | ["XMIO"] | 130.0000 | 355.0000 | 1 | 92 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:46:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b017-8c93-7382-9142-f410edb06a91 | LRCX | 2026-09-17 11:58 | call_diagonal_spread | 2 | 1 | 3 | 112773.00 | unknown | — | 268.4600 | 7.9500 | ["80","82"] | ["9.3457","1.4324"] | [] | ["AMXO"] | 80.0000 | 82.0000 | 1 | 92 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:59:20Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba3-afe3-7713-a6d3-dc2fb5cff89e | LRCX | 2026-09-16 15:13 | other | 4 | 1 | 20 | 227840.00 | unknown | — | 266.1750 | 12.1500 | ["287.5","290","297.5","300"] | ["0.5562","0.5626","1.1936","1.2971"] | [] | ["XPHO"] | 287.5000 | 300.0000 | 2 | 9 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:13:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab44-7ccb-7a63-be08-417881719c6c | LRCX | 2026-09-16 13:29 | call_diagonal_spread | 2 | 1 | 10 | 296170.00 | unknown | — | 270.7900 | 7.2500 | ["125","140"] | ["0.4453","0.5898"] | [] | ["AMXO"] | 125.0000 | 140.0000 | 121 | 492 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:30:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa5-6253-7da2-891e-93e605e1149a | LRCX | 2026-09-16 10:35 | call_vertical_spread | 2 | 1 | 3 | 132327.00 | unknown | — | 272.8050 | 7.6000 | ["50","55"] | ["9.6107","9.1200"] | [] | ["XCBO"] | 50.0000 | 55.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:36:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa70-2183-7751-afa0-4defcd122f59 | LRCX | 2026-09-16 09:37 | call_diagonal_spread | 2 | 1 | 18 | 160014.00 | unknown | — | 273.1400 | 6.5500 | ["230","260"] | ["0.6008","0.5948"] | [] | ["XMIO"] | 230.0000 | 260.0000 | 121 | 492 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:38:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a685-0f86-7601-8cbc-939b4da41c26 | LRCX | 2026-09-15 15:22 | call_diagonal_spread | 2 | 1 | 5 | 123770.00 | unknown | — | 269.2600 | 6.7000 | ["150","175"] | ["0.6534","0.6174"] | [] | ["XCBO"] | 150.0000 | 175.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:22:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a675-8ec5-7663-b3fa-3c9edbb184dc | LRCX | 2026-09-15 15:05 | call_diagonal_spread | 2 | 1 | 5 | 133280.00 | unknown | — | 269.3600 | 6.5000 | ["140","160"] | ["0.6826","0.6196"] | [] | ["XPHO"] | 140.0000 | 160.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:05:38Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60b-304e-7280-a8c2-16578bbdfcbf | LRCX | 2026-09-15 13:09 | call_diagonal_spread | 2 | 1 | 5 | 155600.00 | unknown | — | 267.3400 | 6.2000 | ["115","125"] | ["0.7321","0.6330"] | [] | ["XMIO"] | 115.0000 | 125.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:09:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a606-561e-7fb1-a06b-2762aad82dfe | LRCX | 2026-09-15 13:03 | call_diagonal_spread | 2 | 1 | 10 | 311340.00 | unknown | — | 267.3550 | 6.5000 | ["115","125"] | ["0.7426","0.6343"] | [] | ["XCBO"] | 115.0000 | 125.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:03:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5aa-3816-7151-9e98-c6055de8607a | LRCX | 2026-09-15 11:23 | other | 4 | 1 | 50 | 143100.00 | unknown | — | 267.4500 | 2.6000 | ["220","230","240"] | ["0.6158","0.5907","0.5660"] | [] | ["XCBO"] | 220.0000 | 240.0000 | 31 | 66 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:23:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a575-9386-74d2-810f-07218e2a068f | LRCX | 2026-09-15 10:25 | call_vertical_spread | 2 | 1 | 50 | 1036594.00 | unknown | — | 269.8600 | 5.8500 | ["170","175"] | ["0.6509","0.6457"] | [] | ["XCBO"] | 170.0000 | 175.0000 | 122 | 122 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a131-2829-7511-a6ac-8d91ee1a1624 | LRCX | 2026-09-14 14:32 | other | 4 | 1 | 96 | 216960.00 | unknown | — | 276.2700 | 1.1500 | ["290","300","340","350"] | ["0.5537","0.5549","0.8592","0.9355"] | [] | ["XCBO"] | 290.0000 | 350.0000 | 4 | 32 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:32:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0dc-7c61-76a2-b750-2a0f2869e675 | LRCX | 2026-09-14 12:59 | call_vertical_spread | 2 | 1 | 27 | 257499.00 | unknown | — | 276.9050 | 3.9000 | ["240","250"] | ["0.6238","0.6203"] | [] | ["XCBO"] | 240.0000 | 250.0000 | 67 | 67 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:00:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a7-d000-7210-9372-b75a67b1802c | LRCX | 2026-09-14 12:02 | call_condor | 4 | 1 | 2016 | 2231712.00 | unknown | — | 276.0000 | 1.9000 | ["280","282.5","335","345"] | ["0.6622","0.6581","0.8787","0.9025"] | [] | ["AMXO"] | 280.0000 | 345.0000 | 4 | 4 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:02:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090d0-dd98-7181-9158-4926b60a18c7 | LRCX | 2026-09-11 10:13 | other | 4 | 1 | 1080 | 942840.00 | unknown | — | 297.8600 | 1.8000 | ["275","282.5","305","310"] | ["0.6005","1.2338","0.5664","0.8359"] | [] | ["XPHO"] | 275.0000 | 310.0000 | 0 | 7 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:13:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0866b-36c8-7dd2-a87c-80649a46e2cc | LRCX | 2026-09-09 09:46 | other | 2 | 1 | 43 | 112230.00 | unknown | — | 316.6083 | 2.2000 | ["307.5","315"] | ["0.7634","0.6362"] | [] | ["XCBO"] | 307.5000 | 315.0000 | 2 | 9 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:46:10Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08226-caa0-7900-a241-74697c5b6ed4 | LRCX | 2026-09-08 13:52 | other | 4 | 1 | 13 | 519428.00 | unknown | — | 319.7750 | 11.9000 | ["200","210","240","250"] | ["1.3910","1.2443","0.6614","0.6552"] | [] | ["XCBO"] | 200.0000 | 250.0000 | 10 | 73 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:53:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0821f-c5c0-7251-813e-c49b4371b5a5 | LRCX | 2026-09-08 13:45 | other | 4 | 1 | 6 | 240306.00 | unknown | — | 319.6950 | 12.7000 | ["200","210","240","250"] | ["1.4093","1.3309","0.6750","0.6722"] | [] | ["XCBO"] | 200.0000 | 250.0000 | 10 | 73 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:45:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0820a-fd70-7b82-a7ac-b7bfeae85bfa | LRCX | 2026-09-08 13:22 | call_vertical_spread | 2 | 1 | 2026 | 2593604.00 | unknown | — | 320.6800 | 2.1500 | ["335","345"] | ["0.6270","0.6344"] | [] | ["XPHO"] | 335.0000 | 345.0000 | 10 | 10 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:23:01Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dbb-f89d-78a1-8c09-240069b6a683 | LRCX | 2026-09-04 14:43 | strangle_swap | 4 | 1 | 1080 | 1031074.00 | unknown | — | 303.6700 | 1.2600 | ["267.5","282.5","302.5","310"] | ["4.6044","0.5359","0.5667","0.5192"] | [] | ["AMXO"] | 267.5000 | 310.0000 | 0 | 7 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:44:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db9-d9a5-7b12-af47-11efee61c9d0 | LRCX | 2026-09-04 14:41 | other | 3 | 1 | 5 | 142495.00 | unknown | — | 303.4100 | 11.5000 | ["190","250","360"] | ["0.6125","0.6127","0.6042"] | [] | ["XMIO"] | 190.0000 | 360.0000 | 504 | 651 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:41:32Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dad-9505-7e40-9f25-5ae0771cfe9b | LRCX | 2026-09-04 14:28 | other | 2 | 1 | 199 | 396010.00 | unknown | — | 304.3200 | 2.8000 | ["295","307.5"] | ["1.4041","0.5278"] | [] | ["XMIO"] | 295.0000 | 307.5000 | 0 | 7 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:28:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8a-c2f5-7351-bf8e-b8180ce7f419 | LRCX | 2026-09-04 13:50 | other | 3 | 1 | 80 | 311680.00 | unknown | — | 303.3600 | 5.0500 | ["305","310","330"] | ["0.5150","0.5685","0.5807"] | [] | ["XCBO"] | 305.0000 | 330.0000 | 7 | 35 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:50:37Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |