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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a640-d2c6-7a92-b5a6-452fc89bc3f2 | AAPL | 2026-09-15 14:07 | other | 4 | 1 | 2 | 61830.00 | unknown | — | 330.7900 | 7.2250 | ["250","260"] | ["0.4840","0.4069"] | [] | ["XCBO"] | 250.0000 | 260.0000 | 38 | 45 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:08:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0fd-3b30-71a1-8c8b-9e800a405c84 | AAPL | 2026-09-14 13:35 | other | 2 | 5 | 18 | 50488.00 | unknown | — | 334.3605 | 0.3944 | ["280","410"] | ["0.3073","0.2744"] | [] | ["ARCO","BATO","EDGO","XCBO"] | 280.0000 | 410.0000 | 494 | 494 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:36:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c1-0cf0-7aa0-9ab3-74c7d22a8bf2 | AAPL | 2026-09-14 12:29 | other | 2 | 1 | 56 | 374360.00 | unknown | — | 334.5700 | 0.7000 | ["300","315"] | ["0.5523","0.2819"] | [] | ["XCBO"] | 300.0000 | 315.0000 | 4 | 95 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:30:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091de-f620-7a20-af16-37a2b3527449 | AAPL | 2026-09-11 15:08 | other | 4 | 1 | 2 | 49160.00 | unknown | — | 332.5600 | 3.5500 | ["290","300","320","330"] | ["0.3051","0.2916","0.3150","0.3136"] | [] | ["XCBO"] | 290.0000 | 330.0000 | 98 | 826 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:08:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091d0-5fc0-7693-938f-a7b77655d439 | AAPL | 2026-09-11 14:52 | other | 2 | 1 | 6 | 26220.00 | unknown | — | 332.7977 | 0.5500 | ["310","312.5"] | ["1.8820","0.3020"] | [] | ["XISX"] | 310.0000 | 312.5000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:52:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0918f-7a78-7ab3-88c5-08a8dda665fe | AAPL | 2026-09-11 13:41 | other | 2 | 1 | 10 | 47500.00 | unknown | — | 333.2800 | 2.5000 | ["302.5","317.5"] | ["2.9347","0.2772"] | [] | ["XCBO"] | 302.5000 | 317.5000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:42:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e8-d268-71b2-89f3-a7c5a9337762 | AAPL | 2026-09-11 10:39 | other | 2 | 2 | 15 | 105675.00 | unknown | — | 334.2300 | 0.8500 | ["340","355"] | ["0.2898","0.2886"] | [] | ["XCBO"] | 340.0000 | 355.0000 | 279 | 371 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:39:40Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090da-e7e8-7e21-9a85-06db70aa6939 | AAPL | 2026-09-11 10:24 | other | 2 | 1 | 20 | 34800.00 | unknown | — | 333.4500 | 0.2000 | ["325"] | ["0.3756"] | [] | ["XISX"] | 325.0000 | 325.0000 | 0 | 3 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:24:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c2-4f08-7942-89ff-18a632bac28b | AAPL | 2026-09-11 09:57 | other | 2 | 1 | 18 | 28485.00 | unknown | — | 332.5400 | 0.2500 | ["280","320"] | ["0.3024","0.2806"] | [] | ["XMIO"] | 280.0000 | 320.0000 | 189 | 189 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:57:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce1-f410-7fb1-ae8e-0f023770068e | AAPL | 2026-09-10 15:53 | other | 2 | 2 | 5 | 36500.00 | unknown | — | 325.6400 | 3.1000 | ["290","370"] | ["0.4476","0.2915"] | [] | ["XCBO"] | 290.0000 | 370.0000 | 8 | 554 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:53:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c1e-d6d9-7f31-8978-440406c3f58c | AAPL | 2026-09-10 12:20 | other | 2 | 1 | 7 | 27895.00 | unknown | — | 320.3750 | 0.1500 | ["315","325"] | ["0.2809","0.2704"] | [] | ["XBOX"] | 315.0000 | 325.0000 | 71 | 127 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:20:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086af-38f0-7603-9b85-6424a90b706f | AAPL | 2026-09-09 11:00 | other | 3 | 1 | 15 | 44370.00 | unknown | — | 313.1900 | 0.6300 | ["250","300","320"] | ["0.3320","0.2855","0.2764"] | [] | ["XCBO"] | 250.0000 | 320.0000 | 100 | 100 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:00:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08680-7060-7652-a779-ff387769989d | AAPL | 2026-09-09 10:09 | other | 2 | 1 | 3 | 54210.00 | unknown | — | 317.8700 | 3.6500 | ["230"] | ["0.6193"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 9 | 128 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:09:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081f1-7648-7881-aae2-14e2a9963742 | AAPL | 2026-09-08 12:54 | other | 2 | 2 | 15 | 130050.00 | unknown | — | 316.0400 | 0.6500 | ["270","320"] | ["0.3098","0.2819"] | [] | ["XCBO"] | 270.0000 | 320.0000 | 101 | 282 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:55:25Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081da-7790-73f2-bd5a-1c7c113b0d6d | AAPL | 2026-09-08 12:29 | other | 2 | 1 | 28 | 149100.00 | unknown | — | 316.1100 | 0.9500 | ["290","305"] | ["0.3762","0.2780"] | [] | ["XCBO"] | 290.0000 | 305.0000 | 10 | 101 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:30:01Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e01-23a6-76f0-ae4f-26cff21e5fcc | AAPL | 2026-09-04 15:59 | other | 2 | 1 | 5 | 74750.00 | unknown | — | 319.7150 | 4.2500 | ["245","250"] | ["0.6860","0.3261"] | [] | ["C2OX"] | 245.0000 | 250.0000 | 14 | 105 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:59:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfe-b68d-7ec3-b5d0-6dcd553a316b | AAPL | 2026-09-04 15:56 | other | 2 | 2 | 10 | 63790.00 | unknown | — | 320.3800 | 3.8500 | ["260","335"] | ["0.3577","0.2514"] | [] | ["XCBO"] | 260.0000 | 335.0000 | 14 | 42 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d38-3625-7f80-b755-e252d2161cdd | AAPL | 2026-09-04 12:19 | other | 2 | 1 | 20 | 31900.00 | unknown | — | 321.3000 | 1.0000 | ["327.5"] | ["0.3920"] | [] | ["XCBO"] | 327.5000 | 327.5000 | 0 | 14 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:19:53Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d32-275d-7273-9af2-bcce1cb2ae7c | AAPL | 2026-09-04 12:13 | other | 2 | 2 | 5 | 41775.00 | unknown | — | 321.2550 | 2.1000 | ["280","285"] | ["2.7097","0.2920"] | [] | ["XCBO"] | 280.0000 | 285.0000 | 0 | 77 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:13:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |