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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ec-c5ef-75c2-872d-eac8be2a78ad | AMAT | 2026-09-18 15:09 | other | 4 | 1 | 865 | 1182455.00 | unknown | bid | 436.9000 | 2.4400 | ["435","445","457.5"] | ["0.8223","0.7210","0.4452"] | [] | ["XPHO"] | 435.0000 | 457.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:10:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f3-2753-7391-aee9-7a05800c41b2 | AMAT | 2026-09-17 15:58 | other | 3 | 1 | 5 | 107950.00 | unknown | — | 417.3050 | 15.1000 | ["360","380","420"] | ["0.5560","0.5424","0.5536"] | [] | ["XCBO"] | 360.0000 | 420.0000 | 273 | 273 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab9e-452b-7531-96d1-5c3bf70a696a | AMAT | 2026-09-16 15:07 | other | 4 | 1 | 20 | 226360.00 | unknown | — | 413.8400 | 16.5000 | ["405","410","455","460"] | ["0.5214","0.5202","1.1773","1.2773"] | [] | ["XBOX"] | 405.0000 | 460.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:08:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab96-88b3-76b0-b41e-55df6f550df6 | AMAT | 2026-09-16 14:59 | other | 4 | 1 | 5 | 125160.00 | unknown | — | 414.5525 | 13.7300 | ["350","360","450","460"] | ["0.5502","0.5496","0.6435","0.6750"] | [] | ["XCBO"] | 350.0000 | 460.0000 | 2 | 366 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:59:45Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab7f-5733-7702-9783-f1b721b2a618 | AMAT | 2026-09-16 14:34 | other | 4 | 1 | 5 | 137950.00 | unknown | — | 417.2600 | 16.2100 | ["330","340","450","460"] | ["0.5502","0.5489","0.6486","0.6678"] | [] | ["XMIO"] | 330.0000 | 460.0000 | 2 | 366 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:34:12Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a585-eb1e-7552-9a8d-0d9ecc50725c | AMAT | 2026-09-15 10:43 | other | 4 | 1 | 4 | 108088.00 | unknown | — | 419.2550 | 17.2500 | ["410","430","500","510"] | ["0.5403","0.5461","1.4808","1.0187"] | [] | ["XMIO"] | 410.0000 | 510.0000 | 3 | 122 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:43:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a12b-82d8-7383-9107-60d992e3c666 | AMAT | 2026-09-14 14:26 | other | 3 | 1 | 270 | 341958.00 | unknown | — | 427.7700 | 2.5600 | ["420","460"] | ["0.5898","0.6021"] | [] | ["EDGO"] | 420.0000 | 460.0000 | 4 | 4 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:27:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a122-e3d1-7892-b2f2-c8f83756aa3a | AMAT | 2026-09-14 14:16 | other | 4 | 1 | 45 | 178335.00 | unknown | — | 428.0650 | 3.0500 | ["330","360","380","390"] | ["0.5877","0.5367","0.5618","0.5191"] | [] | ["XCBO"] | 330.0000 | 390.0000 | 32 | 67 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:17:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a062-bc69-7743-a4d3-80f7665de422 | AMAT | 2026-09-14 10:46 | other | 3 | 1 | 5 | 111600.00 | unknown | — | 426.7200 | 13.4000 | ["360","380","420"] | ["0.5609","0.5654","0.5676"] | [] | ["XCBO"] | 360.0000 | 420.0000 | 276 | 276 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:47:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a030-2348-75b2-9eff-ca1b7ca9c9e2 | AMAT | 2026-09-14 09:51 | other | 4 | 1 | 10 | 235480.00 | unknown | — | 426.5100 | 20.6000 | ["460","480","490","500"] | ["0.5393","0.6863","0.5630","0.7708"] | [] | ["XCBO"] | 460.0000 | 500.0000 | 4 | 18 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:51:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0912f-87f8-7f22-bbb0-38a25fb9e69e | AMAT | 2026-09-11 11:56 | other | 4 | 1 | 841 | 1564260.00 | unknown | — | 462.5000 | 0.8500 | ["460","470","482.5"] | ["0.4911","0.4862","0.5005"] | [] | ["EDGO"] | 460.0000 | 482.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:57:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c3c-bb30-7c42-aae5-60e758703cce | AMAT | 2026-09-10 12:53 | other | 4 | 1 | 15 | 270705.00 | unknown | — | 457.5050 | 4.6000 | ["470","480"] | ["0.5334","0.5335"] | [] | ["XCBO"] | 470.0000 | 480.0000 | 8 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:53:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb9-6a00-79c0-bafd-27c15a7f9d2c | AMAT | 2026-09-10 10:29 | other | 4 | 1 | 10 | 118660.00 | unknown | — | 458.3489 | 13.8000 | ["465","470","480"] | ["0.5478","0.6823","0.6016"] | [] | ["XCBO"] | 465.0000 | 480.0000 | 1 | 43 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:29:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086e7-3cc8-7782-b1f6-964695515c11 | AMAT | 2026-09-09 12:01 | other | 2 | 1 | 4 | 135596.00 | unknown | — | 467.6850 | 4.3000 | ["300"] | ["1.9279"] | [] | ["XCBO"] | 300.0000 | 300.0000 | 2 | 37 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:01:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0826d-a740-7f12-8e9f-240b1ceaa924 | AMAT | 2026-09-08 15:10 | other | 2 | 1 | 40 | 117360.00 | unknown | — | 471.7450 | 2.3500 | ["490"] | ["0.5514"] | [] | ["AMXO"] | 490.0000 | 490.0000 | 10 | 24 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b7-e7e8-7ff2-981e-cb3a5636d2b5 | AMAT | 2026-09-08 11:51 | other | 3 | 1 | 173 | 482162.00 | unknown | — | 469.1400 | 3.1000 | ["470","520"] | ["0.5667","0.5774"] | [] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 17 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:52:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08197-c940-7303-abc6-1c186447a7f7 | AMAT | 2026-09-08 11:16 | other | 2 | 1 | 100 | 110658.00 | unknown | — | 468.0955 | 1.7500 | ["600","700"] | ["0.5970","0.6371"] | [] | ["XPHO"] | 600.0000 | 700.0000 | 38 | 73 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:16:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d26-8ab5-7321-900e-b3eb5e771560 | AMAT | 2026-09-04 12:00 | other | 2 | 1 | 450 | 2833425.00 | unknown | — | 454.7300 | 6.8500 | ["420","550"] | ["0.5597","0.5399"] | [] | ["XMIO"] | 420.0000 | 550.0000 | 77 | 133 | true | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:00:58Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d22-393d-7763-87f5-7ba302b2c8df | AMAT | 2026-09-04 11:55 | other | 3 | 1 | 5 | 138240.00 | unknown | — | 454.4100 | 18.8500 | ["420","535"] | ["0.5548","0.5838"] | [] | ["XCBO"] | 420.0000 | 535.0000 | 14 | 378 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:56:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |