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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0eb-5b3b-7c32-b191-0741b1ead4d2 | ORCL | 2026-09-17 15:50 | put_vertical_spread | 2 | 1 | 50 | 41650.00 | long | ask | 150.2500 | 0.2800 | ["135","145"] | ["0.5039","0.5039"] | ["141.73"] | ["C2OX"] | 135.0000 | 145.0000 | 29 | 29 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:50:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a08c6c-f2f0-7860-977b-08c3d36e14df | ORCL | 2026-09-10 13:45 | put_vertical_spread | 2 | 1 | 300 | 30300.00 | short | bid | 156.1250 | 0.0400 | ["122","132"] | ["2.4195","2.4659"] | ["131.33"] | ["XISX"] | 122.0000 | 132.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:46:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08758-afc0-77f1-9357-0c2bf21ec1af | ORCL | 2026-09-09 14:05 | put_vertical_spread | 2 | 1 | 200 | 44800.00 | short | bid | 164.3570 | 0.0400 | ["139","140"] | ["1.8305","1.8276"] | ["139.88"] | ["C2OX"] | 139.0000 | 140.0000 | 2 | 2 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:05:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0869a-ca78-7d62-8c5a-f7fa91c35222 | ORCL | 2026-09-09 10:38 | put_vertical_spread | 2 | 2 | 12 | 30240.00 | unknown | — | 161.4346 | 0.5000 | ["160","170"] | ["1.0319","1.0504"] | [] | ["C2OX"] | 160.0000 | 170.0000 | 9 | 9 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:38:10Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08265-a090-7953-98ab-160cb965e0d5 | ORCL | 2026-09-08 15:01 | put_vertical_spread | 2 | 1 | 117 | 85527.00 | short | bid | 161.8380 | 0.2600 | ["120","130"] | ["0.6253","0.6208"] | ["128.01"] | ["XISX"] | 120.0000 | 130.0000 | 73 | 73 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:01:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |