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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08141-0e20-7562-a75e-7e2554a68f6c | AMAT | 2026-09-08 09:41 | call_diagonal_spread | 2 | 1 | 19 | 198322.00 | long | ask | 464.0200 | 8.6500 | ["410","550"] | ["0.5861","0.5915"] | [] | ["XMIO"] | 410.0000 | 550.0000 | 38 | 129 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:42:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ab-c288-7a93-9d48-c490a92e9d04 | AMAT | 2026-09-08 11:38 | call_diagonal_spread | 2 | 1 | 40 | 247120.00 | long | ask | 469.1400 | 2.5500 | ["450","520"] | ["0.5750","0.6050"] | [] | ["XCBO"] | 450.0000 | 520.0000 | 10 | 73 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:38:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c3-51c8-74c3-adc1-2acc91053ff6 | AMAT | 2026-09-08 12:04 | call_diagonal_spread | 2 | 1 | 3 | 104628.00 | short | ask | 470.8000 | 17.4500 | ["360","500"] | ["0.5874","0.5875"] | [] | ["XCBO"] | 360.0000 | 500.0000 | 500 | 829 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:04:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c7-1e70-7c02-90cc-4fd8ce2b72ca | AMAT | 2026-09-08 12:08 | call_diagonal_spread | 2 | 1 | 4 | 209520.00 | short | bid | 470.3200 | 14.8000 | ["210","220"] | ["2.5403","0.6217"] | [] | ["XMIO"] | 210.0000 | 220.0000 | 10 | 282 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:08:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08664-ce28-7521-a2d1-2d88fb226aea | AMAT | 2026-09-09 09:39 | call_diagonal_spread | 2 | 3 | 5 | 181962.00 | long | bid | 471.5800 | 11.8000 | ["290","360"] | ["1.6777","0.5817"] | [] | ["EDGO","XCBO","XISX"] | 290.0000 | 360.0000 | 9 | 464 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:39:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08664-ce28-7521-a2d1-2d727c22e54a | AMAT | 2026-09-09 09:39 | call_diagonal_spread | 2 | 5 | 9 | 327306.00 | long | bid | 471.9100 | 11.8000 | ["290","360"] | ["2.1206","0.5791"] | [] | ["EDGO","XCBO","XISX","XPHO"] | 290.0000 | 360.0000 | 9 | 464 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:39:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b6-60f8-7f82-a24c-d2b03f3bbf06 | AMAT | 2026-09-09 11:08 | call_diagonal_spread | 2 | 1 | 50 | 269000.00 | short | ask | 466.5600 | 2.9500 | ["560","610"] | ["0.5942","0.5912"] | [] | ["XCBO"] | 560.0000 | 610.0000 | 100 | 128 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:08:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08be4-4a90-79b3-a149-3072aebac220 | AMAT | 2026-09-10 11:16 | call_diagonal_spread | 2 | 2 | 12 | 136308.00 | long | ask | 458.6400 | 5.3500 | ["440","460"] | ["0.5721","0.5858"] | [] | ["XISX"] | 440.0000 | 460.0000 | 71 | 99 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:16:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c11-fdc8-7753-a5b3-97ed54a8c8c2 | AMAT | 2026-09-10 12:06 | call_diagonal_spread | 2 | 1 | 20 | 277600.00 | long | ask | 458.5950 | 8.2000 | ["410","460"] | ["0.5366","0.5674"] | [] | ["C2OX"] | 410.0000 | 460.0000 | 36 | 190 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:06:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0a039-23f8-78a2-ad57-4acf3188f8a7 | AMAT | 2026-09-14 10:01 | call_diagonal_spread | 2 | 1 | 7 | 315693.00 | short | ask | 427.2550 | 11.8000 | ["190","230"] | ["0.6171","0.5575"] | [] | ["BATO"] | 190.0000 | 230.0000 | 123 | 276 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:01:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a07a-2880-7d92-aa3d-10d435ae3a0f | AMAT | 2026-09-14 11:12 | call_diagonal_spread | 2 | 1 | 10 | 265789.00 | long | bid | 425.3100 | 12.0000 | ["500","520"] | ["0.5771","0.5716"] | [] | ["XCBO"] | 500.0000 | 520.0000 | 823 | 858 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:13:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d7-4470-7cb3-8cee-8a2e92f14e9e | AMAT | 2026-09-14 12:54 | call_diagonal_spread | 2 | 1 | 10 | 360510.00 | long | ask | 428.6650 | 13.7500 | ["250","260"] | ["2.2633","0.5899"] | [] | ["XMIO"] | 250.0000 | 260.0000 | 4 | 186 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:54:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a54e-77ce-7b72-897e-1399576db3a2 | AMAT | 2026-09-15 09:42 | call_diagonal_spread | 2 | 1 | 13 | 405067.00 | short | ask | 423.6490 | 11.3000 | ["420","430"] | ["0.5673","0.5663"] | [] | ["XPHO"] | 420.0000 | 430.0000 | 822 | 857 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:43:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0ab36-730b-7951-aee3-3606c428c4db | AMAT | 2026-09-16 13:14 | call_diagonal_spread | 2 | 2 | 5 | 227500.00 | short | bid | 419.6750 | 7.7000 | ["200","210"] | ["0.6688","0.5618"] | [] | ["XCBO"] | 200.0000 | 210.0000 | 121 | 457 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:14:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab9f-cfb3-7d93-9ebe-1ae424cd49cf | AMAT | 2026-09-16 15:09 | call_diagonal_spread | 2 | 1 | 6 | 139866.00 | unknown | — | 412.5000 | 11.5000 | ["300","310"] | ["2.7721","0.5808"] | [] | ["XISX"] | 300.0000 | 310.0000 | 2 | 121 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:09:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afdc-1dbb-7242-a8f4-17a8a1c0fcb5 | AMAT | 2026-09-17 10:53 | call_diagonal_spread | 2 | 1 | 8 | 132992.00 | short | ask | 414.6100 | 6.2000 | ["260","415"] | ["5.3811","0.4752"] | [] | ["XMIO"] | 260.0000 | 415.0000 | 1 | 8 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:54:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b041-ec3b-75f0-b8fb-3ba10e53ff73 | AMAT | 2026-09-17 12:45 | call_diagonal_spread | 2 | 1 | 50 | 198900.00 | long | ask | 414.8050 | 3.6500 | ["390","410"] | ["0.5020","0.5676"] | [] | ["SPHR"] | 390.0000 | 410.0000 | 1 | 15 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4dd-70ff-7243-9d05-ad889799dc43 | AMAT | 2026-09-18 10:13 | call_diagonal_spread | 2 | 3 | 50 | 283275.00 | long | ask | 428.4605 | 6.2000 | ["380","432.5"] | ["0.5055","0.6147"] | [] | ["EDGO","EMLD","XMIO"] | 380.0000 | 432.5000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:13:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4dd-70ff-7243-9d05-ad66407186f2 | AMAT | 2026-09-18 10:13 | call_diagonal_spread | 2 | 6 | 18 | 102036.00 | long | ask | 428.4605 | 4.7422 | ["380","432.5"] | ["0.5051","0.6270"] | [] | ["ARCO","EMLD","XISX","XPHO"] | 380.0000 | 432.5000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:13:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b561-0c67-7b20-a7bc-2c3bdaafaeb3 | AMAT | 2026-09-18 12:37 | call_diagonal_spread | 2 | 1 | 100 | 144800.00 | long | ask | 435.0900 | 1.8875 | ["430","440"] | ["0.5768","0.4612"] | [] | ["XISX"] | 430.0000 | 440.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:37:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b566-a5ff-71d1-97b3-857d23993fdd | AMAT | 2026-09-18 12:43 | call_diagonal_spread | 2 | 1 | 4 | 163836.00 | unknown | bid | 434.9100 | 6.1000 | ["230","270"] | ["17.8731","0.5576"] | [] | ["XPHO"] | 230.0000 | 270.0000 | 0 | 490 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:43:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56d-1a57-7841-88de-00f6257c9c75 | AMAT | 2026-09-18 12:50 | call_diagonal_spread | 2 | 1 | 10 | 409610.00 | short | ask | 434.9100 | 6.0000 | ["230","270"] | ["18.2025","0.5574"] | [] | ["XPHO"] | 230.0000 | 270.0000 | 0 | 490 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:50:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56d-35af-70d3-90b2-a606cd367f46 | AMAT | 2026-09-18 12:50 | call_diagonal_spread | 2 | 1 | 19 | 558144.00 | long | bid | 435.1700 | 11.8500 | ["360","500"] | ["0.5581","0.5605"] | [] | ["XPHO"] | 360.0000 | 500.0000 | 490 | 854 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:50:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |