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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b601-7ab7-7d71-8bf8-4301fa25f8c4 | AAPL | 2026-09-18 15:32 | call_calendar | 2 | 1 | 18 | 133740.00 | short | bid | 336.1800 | 0.4500 | ["300"] | ["0.3133"] | [] | ["XISX"] | 300.0000 | 300.0000 | 14 | 21 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:32:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52f-b397-7ad3-a962-112278511edf | AAPL | 2026-09-18 11:43 | call_calendar | 2 | 2 | 2 | 28090.00 | short | bid | 334.6700 | 2.9000 | ["265"] | ["2.3913"] | [] | ["XCBO"] | 265.0000 | 265.0000 | 0 | 28 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:43:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d9-a83f-70c0-a55a-8a0aeb5eee6d | AAPL | 2026-09-18 10:09 | call_calendar | 2 | 1 | 5 | 35750.00 | unknown | bid | 334.8800 | 0.8500 | ["300"] | ["0.9193"] | [] | ["XISX"] | 300.0000 | 300.0000 | 0 | 28 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:09:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d8-e108-71b3-b83f-6ef8805ef628 | AAPL | 2026-09-18 10:08 | call_calendar | 2 | 1 | 8 | 217360.00 | short | bid | 334.8200 | 2.6000 | ["200"] | ["3.7620"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 0 | 91 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b6-8427-7fc3-b578-9cf43cccf761 | AAPL | 2026-09-18 09:30 | call_calendar | 2 | 1 | 4 | 40040.00 | short | bid | 336.9900 | 2.0000 | ["290"] | ["1.0301"] | [] | ["XISX"] | 290.0000 | 290.0000 | 0 | 91 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:30:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ef-acb3-75b1-a0f1-7093914f8215 | AAPL | 2026-09-17 15:54 | call_calendar | 2 | 1 | 4 | 30360.00 | short | bid | 337.4899 | 1.0000 | ["300"] | ["0.6724"] | [] | ["XISX"] | 300.0000 | 300.0000 | 1 | 15 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:55:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0eb-f393-72d2-b978-5dd245fe5b58 | AAPL | 2026-09-17 15:50 | call_calendar | 2 | 2 | 2 | 25230.00 | unknown | — | 337.8350 | 4.3000 | ["275"] | ["1.1836"] | [] | ["XCBO"] | 275.0000 | 275.0000 | 1 | 8 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:51:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d7-65db-7573-b121-b75db67e06b5 | AAPL | 2026-09-17 15:28 | call_calendar | 2 | 1 | 15 | 83175.00 | short | bid | 336.9900 | 1.9000 | ["310"] | ["0.5235"] | [] | ["C2OX"] | 310.0000 | 310.0000 | 1 | 22 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:28:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-093b-78c3-9669-8ff3c63ad60a | AAPL | 2026-09-17 15:19 | call_calendar | 2 | 1 | 4 | 70440.00 | short | ask | 337.1750 | 3.0500 | ["250"] | ["1.9841"] | [] | ["XPHO"] | 250.0000 | 250.0000 | 1 | 36 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b4-b30b-7631-8171-26f79c7bfffd | AAPL | 2026-09-17 14:50 | call_calendar | 2 | 2 | 4 | 82520.00 | unknown | — | 336.2300 | 4.2500 | ["235"] | ["0.4718"] | [] | ["XCBO"] | 235.0000 | 235.0000 | 29 | 92 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:50:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc8-dc0b-7af3-8f53-a859d9df4cd7 | AAPL | 2026-09-17 10:32 | call_calendar | 2 | 1 | 13 | 89375.00 | short | bid | 333.2814 | 0.5000 | ["300"] | ["0.6126"] | [] | ["XISX"] | 300.0000 | 300.0000 | 1 | 29 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:33:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-64ab-7d53-bf17-2bcc62645d70 | AAPL | 2026-09-17 09:48 | call_calendar | 2 | 1 | 20 | 30900.00 | unknown | — | 331.0200 | 0.4500 | ["325"] | ["0.3211"] | [] | ["XISX"] | 325.0000 | 325.0000 | 1 | 8 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af91-a353-7431-b7ec-0c20648b6fec | AAPL | 2026-09-17 09:32 | call_calendar | 2 | 1 | 20 | 34820.00 | unknown | — | 333.6050 | 0.5600 | ["360"] | ["0.4210"] | [] | ["XBOX"] | 360.0000 | 360.0000 | 1 | 183 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:32:38Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0aaaf-226b-72e3-9dfa-f2f8a4202854 | AAPL | 2026-09-16 10:46 | call_calendar | 2 | 1 | 20 | 201900.00 | unknown | — | 333.5400 | 1.9000 | ["290"] | ["0.3013"] | [] | ["XCBO"] | 290.0000 | 290.0000 | 65 | 121 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:47:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a640-f5ee-7eb3-a523-8bd39cdd2274 | AAPL | 2026-09-15 14:07 | call_calendar | 2 | 2 | 6 | 92040.00 | short | bid | 330.7450 | 2.6000 | ["255"] | ["0.8489"] | [] | ["XCBO"] | 255.0000 | 255.0000 | 3 | 45 | false | false | true | false | 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 |
| 01a0a588-fc46-7b40-8847-3ae8e0f055c6 | AAPL | 2026-09-15 10:46 | call_calendar | 2 | 1 | 20 | 105500.00 | short | bid | 329.6200 | 0.4500 | ["305"] | ["0.3852"] | [] | ["XISX"] | 305.0000 | 305.0000 | 3 | 31 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:46:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a113-1cc0-7bf0-a52b-396915cb7aa1 | AAPL | 2026-09-14 13:59 | call_calendar | 2 | 1 | 20 | 186200.00 | short | bid | 333.9900 | 1.2000 | ["290"] | ["0.4959"] | [] | ["C2OX"] | 290.0000 | 290.0000 | 4 | 67 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:00:07Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ed-0f80-7bd3-ab3f-ddab9d57e321 | AAPL | 2026-09-11 15:23 | call_calendar | 2 | 2 | 2 | 35520.00 | short | bid | 332.5999 | 1.7000 | ["250"] | ["0.3581"] | [] | ["XCBO"] | 250.0000 | 250.0000 | 98 | 189 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:23:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090bf-8048-7640-a79f-bbf743f7ce9a | AAPL | 2026-09-11 09:54 | call_calendar | 2 | 1 | 500 | 109000.00 | short | ask | 331.8600 | 0.0500 | ["335"] | ["0.3522"] | [] | ["XISX"] | 335.0000 | 335.0000 | 0 | 3 | false | true | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:54:29Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c19-4128-7200-97e8-0ac7c5a93501 | AAPL | 2026-09-10 12:14 | call_calendar | 2 | 1 | 10 | 92750.00 | long | bid | 320.4000 | 3.0500 | ["280"] | ["0.3007"] | [] | ["XISX"] | 280.0000 | 280.0000 | 71 | 99 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:14:32Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0871b-e928-7512-8d06-a83703caef7f | AAPL | 2026-09-09 12:59 | call_calendar | 2 | 2 | 93 | 26970.00 | long | bid | 314.0000 | 0.0200 | ["320"] | ["0.8425"] | [] | ["ARCO"] | 320.0000 | 320.0000 | 0 | 2 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:59:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08713-c721-7df3-990c-f3213c74be49 | AAPL | 2026-09-09 12:50 | call_calendar | 2 | 1 | 17 | 170085.00 | short | bid | 313.8450 | 2.4500 | ["265"] | ["0.4739"] | [] | ["XCBO"] | 265.0000 | 265.0000 | 9 | 37 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:50:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08689-e640-7b42-85be-b3fabb3c426a | AAPL | 2026-09-09 10:19 | call_calendar | 2 | 1 | 199 | 136315.00 | long | ask | 314.8353 | 0.0800 | ["315"] | ["0.6448"] | [] | ["XISX"] | 315.0000 | 315.0000 | 0 | 2 | false | true | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:19:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08689-e640-7b42-85be-b3d40a78b1c6 | AAPL | 2026-09-09 10:19 | call_calendar | 2 | 1 | 130 | 89050.00 | long | ask | 314.8353 | 0.0800 | ["315"] | ["0.6448"] | [] | ["XISX"] | 315.0000 | 315.0000 | 0 | 2 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:19:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081bb-c430-7741-b3ce-818bc8d474f0 | AAPL | 2026-09-08 11:55 | call_calendar | 2 | 2 | 2 | 31280.00 | short | bid | 316.0800 | 1.2000 | ["240"] | ["0.5516"] | [] | ["XCBO"] | 240.0000 | 240.0000 | 10 | 101 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:56:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |