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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a682-8ee6-7733-9a2f-23c0f8ec70cd | MSFT | 2026-09-15 15:19 | other | 3 | 1 | 5 | 68650.00 | unknown | — | 497.0150 | 2.6500 | ["435","490"] | ["0.3276","0.3103"] | [] | ["XCBO"] | 435.0000 | 490.0000 | 31 | 275 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:20:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a114-beb8-7360-be2f-40ad5856789b | MSFT | 2026-09-14 14:01 | other | 3 | 1 | 3 | 43095.00 | unknown | — | 509.1000 | 5.4500 | ["440","455","510"] | ["0.4908","0.3283","0.2400"] | [] | ["XCBO"] | 440.0000 | 510.0000 | 18 | 46 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:01:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a04e-7500-73c3-b64a-0eb06bef4ebc | MSFT | 2026-09-14 10:24 | other | 4 | 1 | 12 | 190500.00 | unknown | — | 499.7550 | 5.4500 | ["440","460","465","490"] | ["0.6134","0.3922","0.2830","0.2579"] | [] | ["XCBO"] | 440.0000 | 490.0000 | 4 | 25 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:24:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c72-7900-74b2-92be-c4f0e5acc87f | MSFT | 2026-09-10 13:51 | other | 3 | 1 | 2 | 44885.00 | unknown | — | 492.6350 | 7.3000 | ["330","530","730"] | ["0.3527","0.3492","0.4221"] | [] | ["XISX"] | 330.0000 | 730.0000 | 827 | 827 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:52:24Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c2e-f3d8-7853-9b27-00b79966d9d0 | MSFT | 2026-09-10 12:37 | other | 3 | 1 | 2 | 47130.00 | unknown | — | 492.9100 | 6.3500 | ["340","540","740"] | ["0.3517","0.3508","0.4288"] | [] | ["XISX"] | 340.0000 | 740.0000 | 827 | 827 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:38:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bbc-7b28-79f2-8c5b-9bf03bd70712 | MSFT | 2026-09-10 10:32 | other | 2 | 1 | 11 | 42240.00 | unknown | — | 491.7700 | 1.4000 | ["430","515"] | ["0.3973","0.3130"] | [] | ["MCRY"] | 430.0000 | 515.0000 | 8 | 71 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:33:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bae-ac00-7bc3-a0a4-b23285a20206 | MSFT | 2026-09-10 10:17 | other | 2 | 1 | 117 | 33813.00 | unknown | — | 489.1850 | 0.2800 | ["475"] | ["0.3310"] | [] | ["XISX"] | 475.0000 | 475.0000 | 1 | 8 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:18:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |