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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d3a-5905-76f1-a5ea-e0f9bf5b789c | NOW | 2026-09-04 12:22 | call_condor | 4 | 1 | 10 | 106260.00 | long | ask | 141.2950 | 1.9500 | ["110","120","140","150"] | ["0.5718","0.5675","0.5574","0.5571"] | ["112.66","147.34"] | ["XMIO"] | 110.0000 | 150.0000 | 133 | 133 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:22:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d73-2fcd-76d0-a4bd-af0e5352d319 | NOW | 2026-09-04 13:24 | call_diagonal_spread_bullish | 2 | 2 | 123 | 532344.00 | short | bid | 141.5950 | 0.6000 | ["110","130"] | ["0.6122","1.7933"] | [] | ["XCBO"] | 110.0000 | 130.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:24:30Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d9b-978d-74e2-9063-33446e9795af | NOW | 2026-09-04 14:08 | risk_reversal | 2 | 1 | 80 | 284560.00 | short | bid | 141.8950 | 1.2000 | ["115","190"] | ["0.5788","0.5622"] | ["193.99"] | ["XCBO"] | 115.0000 | 190.0000 | 378 | 378 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:08:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dad-7d95-78c1-94c7-e42a828571c5 | NOW | 2026-09-04 14:27 | put_calendar | 2 | 1 | 80 | 135120.00 | short | ask | 142.2000 | 0.7500 | ["150"] | ["1.5270"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | 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 |
| 01a06ddb-4c25-7753-b779-9c6adf7a406d | NOW | 2026-09-04 15:18 | risk_reversal | 2 | 1 | 105 | 371595.00 | long | ask | 141.8200 | 1.3000 | ["115","190"] | ["0.5750","0.5622"] | ["194.11"] | ["XMIO"] | 115.0000 | 190.0000 | 378 | 378 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:18:22Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a081f9-80e0-7f43-bfae-45d65996f54d | NOW | 2026-09-08 13:03 | call_vertical_spread | 2 | 1 | 43 | 138030.00 | unknown | — | 134.1400 | 0.3500 | ["110","127"] | ["1.0018","0.6383"] | [] | ["XCBO"] | 110.0000 | 127.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:03:30Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08282-a258-7882-b77b-2b5c1b444224 | NOW | 2026-09-08 15:33 | call_calendar | 2 | 1 | 10 | 103150.00 | short | ask | 133.7300 | 2.4000 | ["115"] | ["0.5821"] | [] | ["XCBO"] | 115.0000 | 115.0000 | 500 | 829 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:33:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08293-28d0-7170-a315-982fdeda0389 | NOW | 2026-09-08 15:51 | put_vertical_spread | 2 | 1 | 26 | 143546.00 | unknown | — | 134.1200 | 0.7500 | ["140","170"] | ["0.5754","0.5877"] | [] | ["XBOX"] | 140.0000 | 170.0000 | 73 | 73 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:51:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08715-0b58-77a2-a454-f4424a84b971 | NOW | 2026-09-09 12:51 | other | 4 | 1 | 345 | 134205.00 | unknown | — | 131.2000 | 0.2200 | ["137","142","148"] | ["0.5549","0.6379","0.7914"] | [] | ["XCBO"] | 137.0000 | 148.0000 | 2 | 9 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:51:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08bbf-ab91-70c0-9a6e-9f18d7eee9cc | NOW | 2026-09-10 10:36 | put_vertical_spread | 2 | 1 | 417 | 267714.00 | unknown | — | 132.7350 | 0.2600 | ["129","132"] | ["0.5472","0.5438"] | [] | ["XCBO"] | 129.0000 | 132.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:36:37Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c05-43f8-7b80-a849-8e1ba7363e87 | NOW | 2026-09-10 11:52 | call_vertical_spread | 2 | 1 | 18 | 146142.00 | short | bid | 133.8700 | 6.8000 | ["94","95"] | ["5.0218","4.9130"] | ["94.99"] | ["XCBO"] | 94.0000 | 95.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:53:00Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cdf-63d0-7301-9b9b-41a0870d2fc2 | NOW | 2026-09-10 15:50 | put_vertical_spread | 2 | 1 | 417 | 951177.00 | unknown | — | 131.0900 | 0.7500 | ["141","144"] | ["0.6424","1.1422"] | [] | ["XCBO"] | 141.0000 | 144.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:50:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a090c4-0c58-79d1-bf53-3df226041c1b | NOW | 2026-09-11 09:59 | call_vertical_spread | 2 | 1 | 160 | 158080.00 | short | bid | 134.2550 | 0.5000 | ["140","150"] | ["0.5187","0.5221"] | ["142.92"] | ["XCBO"] | 140.0000 | 150.0000 | 35 | 35 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:59:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090cd-b118-7ea3-828a-17114f657099 | NOW | 2026-09-11 10:09 | risk_reversal | 2 | 1 | 45 | 161202.00 | short | bid | 133.2707 | 1.1000 | ["110","170"] | ["0.5789","0.5631"] | ["175.02"] | ["EDGO"] | 110.0000 | 170.0000 | 371 | 371 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:09:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091cf-7d31-7571-948f-81d9f819592b | NOW | 2026-09-11 14:51 | other | 3 | 1 | 200 | 129700.00 | unknown | — | 132.8200 | 0.4400 | ["130","132","134"] | ["0.4979","0.4980","0.4975"] | [] | ["XMIO"] | 130.0000 | 134.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:52:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ef-74c8-7f33-9695-aa1300e44a28 | NOW | 2026-09-11 15:26 | other | 2 | 1 | 123 | 147477.00 | unknown | — | 133.0290 | 0.4300 | ["125","130"] | ["0.4994","1.9998"] | [] | ["XMIO"] | 125.0000 | 130.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:26:28Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a15f-e500-7d20-b217-1ee949b5fab7 | NOW | 2026-09-14 15:23 | call_vertical_spread | 2 | 1 | 99 | 125730.00 | unknown | — | 142.0500 | 0.2600 | ["130","160"] | ["0.6547","0.6508"] | [] | ["XCBO"] | 130.0000 | 160.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:23:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a57c-80f5-7360-a05b-2b6ede223134 | NOW | 2026-09-15 10:33 | call_vertical_spread | 2 | 1 | 30 | 168240.00 | unknown | — | 141.4300 | 1.0500 | ["110","120"] | ["0.6040","0.5638"] | [] | ["XMIO"] | 110.0000 | 120.0000 | 31 | 31 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:33:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b0-b056-7fb1-b68d-68f4de19f1a4 | NOW | 2026-09-15 11:30 | call_calendar | 2 | 1 | 25 | 199100.00 | unknown | — | 144.3700 | 1.3500 | ["110"] | ["0.5942"] | [] | ["XMIO"] | 110.0000 | 110.0000 | 94 | 122 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:30:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5bf-b416-70b1-a994-cdc2e2f73eb1 | NOW | 2026-09-15 11:46 | call_diagonal_spread | 2 | 1 | 20 | 139280.00 | short | bid | 145.3099 | 0.8000 | ["112","125"] | ["0.6040","0.5872"] | [] | ["XCBO"] | 112.0000 | 125.0000 | 17 | 275 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:46:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a64c-d116-7bf2-9530-fb90b73199f1 | NOW | 2026-09-15 14:20 | call_vertical_spread | 2 | 1 | 50 | 415400.00 | unknown | — | 144.0500 | 0.6500 | ["100","105"] | ["1.8816","1.6551"] | [] | ["XCBO"] | 100.0000 | 105.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:20:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-ff4e-75d2-9ad9-27fc6b7b175f | NOW | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 194 | 442902.00 | short | ask | 141.8500 | 0.3500 | ["125","150"] | ["0.7614","0.5400"] | [] | ["EDGO"] | 125.0000 | 150.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a5-b2fe-7712-8932-379141ddd71c | NOW | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 192 | 438720.00 | unknown | — | 141.8800 | 0.2500 | ["125","150"] | ["0.7509","0.5392"] | [] | ["EDGO"] | 125.0000 | 150.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aacc-204b-7d53-b110-430308c0d980 | NOW | 2026-09-16 11:18 | risk_reversal | 3 | 1 | 500 | 923502.00 | long | bid | 140.8600 | 0.9300 | ["125","155","185"] | ["0.5960","0.5896","0.5929"] | ["124.51"] | ["XMIO"] | 125.0000 | 185.0000 | 65 | 65 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:18:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aacc-b0d3-7580-92c4-025a1185facb | NOW | 2026-09-16 11:18 | risk_reversal | 3 | 1 | 500 | 925001.00 | long | bid | 140.9600 | 0.8500 | ["125","155","185"] | ["0.5964","0.5896","0.5924"] | ["124.56"] | ["EDGO"] | 125.0000 | 185.0000 | 65 | 65 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:19:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afe7-3d63-7d41-bedf-e866658b5ccf | NOW | 2026-09-17 11:05 | call_vertical_spread | 2 | 1 | 25 | 122475.00 | unknown | — | 139.2100 | 1.0000 | ["125","130"] | ["0.5613","0.5586"] | [] | ["XCBO"] | 125.0000 | 130.0000 | 120 | 120 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:06:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b004-a0d3-7560-afda-01d226c0a9ec | NOW | 2026-09-17 11:38 | other | 4 | 1 | 416 | 291616.00 | unknown | — | 139.3500 | 0.4000 | ["129","132","136","139"] | ["0.7535","0.6644","0.5283","0.5224"] | [] | ["XCBO"] | 129.0000 | 139.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:38:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06a-fbf3-7c52-ba07-c95d63fbe83d | NOW | 2026-09-17 13:29 | put_diagonal_spread | 2 | 1 | 132 | 347292.00 | long | ask | 138.5500 | 0.4000 | ["140","145"] | ["0.5648","0.6752"] | [] | ["XCBO"] | 140.0000 | 145.0000 | 1 | 155 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:30:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b54d-8c37-7930-a0f0-b504c76eaa77 | NOW | 2026-09-18 12:15 | other | 3 | 1 | 500 | 157500.00 | unknown | ask | 136.6950 | 0.1200 | ["140","145","175"] | ["0.7582","1.3126","0.5777"] | [] | ["XPHO"] | 140.0000 | 175.0000 | 0 | 63 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:16:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56a-10ff-73b0-9c04-e3e2faf2449e | NOW | 2026-09-18 12:46 | risk_reversal | 3 | 1 | 250 | 394500.00 | long | bid | 136.3200 | 0.6600 | ["125","155","185"] | ["0.5712","0.5704","0.5825"] | ["122.50"] | ["XMIO"] | 125.0000 | 185.0000 | 63 | 63 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:47:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56a-4b97-7520-ad60-a7b86b726fd1 | NOW | 2026-09-18 12:47 | risk_reversal | 3 | 1 | 250 | 395000.00 | long | bid | 136.3150 | 0.6600 | ["125","155","185"] | ["0.5712","0.5710","0.5834"] | ["122.50"] | ["EDGO"] | 125.0000 | 185.0000 | 63 | 63 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:47:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ce-35b7-79a0-9c7b-b46257427413 | NOW | 2026-09-18 14:36 | call_diagonal_spread | 2 | 1 | 123 | 161991.00 | short | bid | 137.0800 | 0.5500 | ["130","132"] | ["0.4671","1.8463"] | [] | ["XMIO"] | 130.0000 | 132.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:36:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b605-3ba7-7973-9fe6-3725cea6726a | NOW | 2026-09-18 15:36 | other | 4 | 1 | 304 | 103056.00 | unknown | — | 136.4400 | 0.2000 | ["137","140","142","145"] | ["0.9284","0.4825","2.6370","0.5007"] | [] | ["XCBO"] | 137.0000 | 145.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:36:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c468-fbcf-7933-9de8-c52e67f7c9c8 | NOW | 2026-09-21 10:40 | call_vertical_spread | 2 | 1 | 60 | 156780.00 | short | bid | 137.0900 | 0.8000 | ["140","160"] | ["0.5519","0.5505"] | ["146.87"] | ["XCBO"] | 140.0000 | 160.0000 | 116 | 116 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:40:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c468-fbcf-7933-9de8-c538a90eef90 | NOW | 2026-09-21 10:40 | call_vertical_spread | 2 | 1 | 60 | 156780.00 | short | bid | 137.0200 | 0.8000 | ["140","160"] | ["0.5532","0.5514"] | ["146.87"] | ["XCBO"] | 140.0000 | 160.0000 | 116 | 116 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:40:26Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51b-b99f-73d2-9077-57bc352564f1 | NOW | 2026-09-21 13:55 | put_vertical_spread | 2 | 1 | 50 | 312000.00 | unknown | — | 137.3950 | 1.0000 | ["160","162"] | ["0.5586","0.5605"] | [] | ["XCBO"] | 160.0000 | 162.0000 | 116 | 116 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:55:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |