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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b06d-2e73-7522-8358-f8612e50b1c4 | AAPL | 2026-09-17 13:32 | put_vertical_spread | 2 | 2 | 10 | 33350.00 | long | ask | 335.5100 | 0.3000 | ["320","350"] | ["0.2700","0.2594"] | ["336.15"] | ["C2OX"] | 320.0000 | 350.0000 | 92 | 92 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:32:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b053-8fdb-7ac1-a5aa-138a2641a1a3 | AAPL | 2026-09-17 13:04 | put_vertical_spread | 2 | 1 | 5 | 40450.00 | long | ask | 336.3900 | 1.1000 | ["340","350"] | ["0.2974","0.2982"] | ["345"] | ["C2OX"] | 340.0000 | 350.0000 | 547 | 547 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:04:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a09c-3359-7bc3-8b9a-6f7f8f498f2c | AAPL | 2026-09-14 11:49 | put_vertical_spread | 2 | 1 | 40 | 27800.00 | long | ask | 334.7700 | 0.1500 | ["315","320"] | ["0.2645","0.2585"] | ["318.95"] | ["XISX"] | 315.0000 | 320.0000 | 32 | 32 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:49:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091c1-cd48-7160-87cf-41315be7b23f | AAPL | 2026-09-11 14:36 | put_vertical_spread | 2 | 2 | 466 | 68968.00 | long | ask | 333.0300 | 0.0400 | ["327.5","330"] | ["0.1896","0.1855"] | ["329.48"] | ["ARCO"] | 327.5000 | 330.0000 | 3 | 3 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:37:11Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b7-6d08-73e2-b7e9-9d6d2c12df21 | AAPL | 2026-09-11 14:25 | put_vertical_spread | 2 | 2 | 17 | 79995.00 | long | ask | 332.8300 | 0.7824 | ["250","350"] | ["0.3127","0.2804"] | ["317.04"] | ["C2OX"] | 250.0000 | 350.0000 | 371 | 371 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:25:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09150-0849-7ae3-95c7-61aeec71a914 | AAPL | 2026-09-11 12:32 | put_vertical_spread | 2 | 1 | 231 | 60291.00 | unknown | — | 334.1750 | 0.0300 | ["330","332.5"] | ["0.2080","0.2056"] | [] | ["C2OX"] | 330.0000 | 332.5000 | 3 | 3 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:32:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09119-5c30-70c1-9681-309c5675a66e | AAPL | 2026-09-11 11:32 | put_vertical_spread | 2 | 1 | 9 | 28620.00 | unknown | — | 335.2000 | 0.8000 | ["250","260"] | ["0.3058","0.3026"] | [] | ["C2OX"] | 250.0000 | 260.0000 | 826 | 826 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:33:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c7-e8a0-70d0-8f41-e464909048f3 | AAPL | 2026-09-11 10:03 | put_vertical_spread | 2 | 1 | 30 | 92400.00 | long | ask | 332.2050 | 0.6500 | ["240","330"] | ["0.3257","0.2806"] | ["307.40"] | ["C2OX"] | 240.0000 | 330.0000 | 279 | 279 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:03:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b92-3ac1-7331-95e9-28140ff988ce | AAPL | 2026-09-10 09:46 | put_vertical_spread | 2 | 1 | 35 | 57400.00 | unknown | — | 320.9994 | 0.3800 | ["305","335"] | ["0.3322","0.3139"] | [] | ["MCRY"] | 305.0000 | 335.0000 | 8 | 8 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:46:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06d9b-0aed-7262-aa48-bed9d9989ebd | AAPL | 2026-09-04 14:07 | put_vertical_spread | 2 | 1 | 316 | 77104.00 | short | bid | 321.1400 | 0.0200 | ["307.5","312.5"] | ["0.2838","0.2755"] | ["311.68"] | ["XISX"] | 307.5000 | 312.5000 | 7 | 7 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:08:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |