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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57b-bbbf-7ed1-a410-7d86a287f0c3 | LRCX | 2026-09-21 15:40 | call_vertical_spread | 2 | 1 | 20 | 107620.00 | long | ask | 305.5800 | 0.8000 | ["300","340"] | ["0.6291","0.6334"] | ["315.33"] | ["XCBO"] | 300.0000 | 340.0000 | 60 | 60 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:40:19Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c551-2d37-7681-a7ab-426d52e485ad | LRCX | 2026-09-21 14:53 | call_vertical_spread | 2 | 1 | 50 | 183250.00 | long | ask | 302.3500 | 1.8000 | ["282.5","290"] | ["0.6056","0.6085"] | ["288.45"] | ["XMIO"] | 282.5000 | 290.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:54:01Z"} | 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 |
| 01a0b5f8-33b7-7983-848b-4c359330d886 | LRCX | 2026-09-18 15:22 | call_diagonal_spread | 2 | 1 | 4 | 170500.00 | short | ask | 283.2550 | 7.7000 | ["70","72"] | ["0.9838","1.4145"] | [] | ["XMIO"] | 70.0000 | 72.0000 | 91 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:22:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b049-81a3-7190-8348-11025e929120 | LRCX | 2026-09-17 12:53 | call_vertical_spread | 2 | 1 | 27 | 592002.00 | long | ask | 267.7600 | 6.0500 | ["100","400"] | ["0.6535","0.6003"] | ["234.86"] | ["XCBO"] | 100.0000 | 400.0000 | 491 | 491 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:53:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b01b-5d23-7bf2-b9ad-dc571e939b55 | LRCX | 2026-09-17 12:02 | call_vertical_spread | 2 | 1 | 375 | 1254000.00 | long | ask | 268.5450 | 0.8500 | ["320","340"] | ["0.5725","0.5754"] | ["324.30"] | ["XCBO"] | 320.0000 | 340.0000 | 120 | 120 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:03:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab0f-91ea-7670-b981-de0d72ba90e9 | LRCX | 2026-09-16 12:31 | call_vertical_spread | 2 | 1 | 3 | 113973.00 | long | ask | 271.9800 | 6.8000 | ["80","85"] | ["7.6790","7.3374"] | ["84.99"] | ["XCBO"] | 80.0000 | 85.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:32:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf9-eeda-74d0-a18f-53a0eb1ba020 | LRCX | 2026-09-16 12:08 | call_diagonal_spread | 2 | 1 | 5 | 146550.00 | long | ask | 272.8700 | 7.1000 | ["130","145"] | ["0.6732","0.6044"] | [] | ["XCBO"] | 130.0000 | 145.0000 | 121 | 492 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:09:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa9b-8acb-7241-9fa4-67b53355120d | LRCX | 2026-09-16 10:25 | call_vertical_spread | 2 | 1 | 4 | 172924.00 | long | ask | 273.5200 | 7.8000 | ["55","60"] | ["8.4315","8.0461"] | ["59.99"] | ["XCBO"] | 55.0000 | 60.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:25:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a631-2ede-7d50-92b0-ab6538c09336 | LRCX | 2026-09-15 13:50 | call_diagonal_spread | 2 | 1 | 5 | 145020.00 | long | ask | 266.8300 | 6.8000 | ["125","140"] | ["0.7329","0.6303"] | [] | ["XCBO"] | 125.0000 | 140.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:51:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f5-1bf6-77a1-8c33-ceb339336ff5 | LRCX | 2026-09-15 12:44 | call_diagonal_spread | 2 | 1 | 5 | 157575.00 | long | ask | 267.3450 | 6.5000 | ["110","115"] | ["5.9486","0.6451"] | [] | ["XCBO"] | 110.0000 | 115.0000 | 3 | 275 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:45:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f4-c606-7612-ab85-b12cf3c83b24 | LRCX | 2026-09-15 12:44 | call_diagonal_spread | 2 | 1 | 9 | 260739.00 | long | ask | 267.3150 | 7.3500 | ["125","140"] | ["0.6220","0.6189"] | [] | ["XCBO"] | 125.0000 | 140.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:44:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e3-1e7e-7bd1-b431-fb5e59b6e326 | LRCX | 2026-09-15 12:25 | call_vertical_spread | 2 | 1 | 3 | 113529.00 | long | ask | 266.5500 | 6.1500 | ["75","80"] | ["5.5766","5.3401"] | ["79.99"] | ["XCBO"] | 75.0000 | 80.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:25:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5de-8a9e-7592-940a-dcae0994a3d0 | LRCX | 2026-09-15 12:20 | call_diagonal_spread | 2 | 1 | 10 | 295740.00 | long | ask | 265.9350 | 6.9000 | ["120","135"] | ["0.6436","0.6240"] | [] | ["XMIO"] | 120.0000 | 135.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:20:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c8-fb16-7092-bcf2-6d3277cf9d4f | LRCX | 2026-09-15 11:56 | call_diagonal_spread | 2 | 1 | 10 | 299670.00 | long | ask | 267.4550 | 6.7500 | ["120","135"] | ["0.7477","0.6341"] | [] | ["XCBO"] | 120.0000 | 135.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:57:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c7-16b6-7010-8a82-a530a8896603 | LRCX | 2026-09-15 11:54 | call_diagonal_spread | 2 | 1 | 10 | 299550.00 | long | ask | 267.9500 | 6.5000 | ["120","135"] | ["0.6417","0.6235"] | [] | ["XCBO"] | 120.0000 | 135.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:55:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a09a-d3c9-7733-aac0-fcc3dbecf95e | LRCX | 2026-09-14 11:48 | put_vertical_spread | 2 | 1 | 300 | 447900.00 | long | ask | 277.1700 | 1.6500 | ["275","280"] | ["0.6314","0.6282"] | ["277.45"] | ["XCBO"] | 275.0000 | 280.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:48:20Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091a6-84e8-78f1-bc6f-178483a30ecb | LRCX | 2026-09-11 14:06 | call_vertical_spread | 2 | 1 | 30 | 340110.00 | long | ask | 301.4500 | 6.3000 | ["240","250"] | ["0.4109","0.6076"] | ["249.89"] | ["XCBO"] | 240.0000 | 250.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:07:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce5-a178-7bd1-b080-d256cc9927c5 | LRCX | 2026-09-10 15:57 | put_diagonal_spread | 2 | 1 | 19 | 129960.00 | long | ask | 297.6950 | 5.0000 | ["310","320"] | ["0.6174","0.5762"] | [] | ["XMIO"] | 310.0000 | 320.0000 | 8 | 99 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:57:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0c-c5d8-7701-a378-e1297a180930 | LRCX | 2026-09-10 12:00 | call_vertical_spread | 2 | 1 | 500 | 3898500.00 | long | ask | 303.0050 | 5.4500 | ["270","280"] | ["0.5938","0.5891"] | ["276.85"] | ["XMIO"] | 270.0000 | 280.0000 | 36 | 36 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:00:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bf7-d678-77e3-8560-2df91aaf15f1 | LRCX | 2026-09-10 11:37 | call_vertical_spread | 2 | 1 | 2026 | 6695930.00 | long | ask | 304.6350 | 2.6500 | ["285","292.5"] | ["0.8024","0.7547"] | ["291.87"] | ["XCBO"] | 285.0000 | 292.5000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:37:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08286-1140-7fd2-80e2-0cbf94fd44fe | LRCX | 2026-09-08 15:36 | call_diagonal_spread | 2 | 1 | 24 | 171576.00 | long | ask | 320.6700 | 4.2000 | ["290","390"] | ["0.6396","0.6320"] | [] | ["XMIO"] | 290.0000 | 390.0000 | 10 | 192 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:37:01Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081bb-4f01-7082-94fe-9b016ebc3c0f | LRCX | 2026-09-08 11:55 | call_vertical_spread | 2 | 1 | 4 | 130284.00 | long | ask | 319.9875 | 7.2000 | ["155","160"] | ["3.5761","3.4449"] | ["159.99"] | ["XCBO"] | 155.0000 | 160.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:55:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08194-fa80-7481-bdce-c57d106c6564 | LRCX | 2026-09-08 11:13 | call_diagonal_spread | 2 | 1 | 48 | 968544.00 | long | ask | 319.1450 | 6.4500 | ["220","240"] | ["0.8992","0.6225"] | [] | ["EDGO"] | 220.0000 | 240.0000 | 10 | 192 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:13:50Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d7c-e42d-72c0-987d-fbd56ec9d79a | LRCX | 2026-09-04 13:34 | call_diagonal_spread_bearish | 2 | 1 | 19 | 578303.00 | short | ask | 302.5700 | 7.2500 | ["145","270"] | ["0.6222","0.6089"] | [] | ["XMIO"] | 145.0000 | 270.0000 | 504 | 833 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:35:32Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |