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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d2a-4f8d-72c3-98de-7c310c88e606 | SPCX | 2026-09-04 12:04 | call_diagonal_spread_bearish | 2 | 1 | 10 | 26500.00 | short | ask | 148.9600 | 0.5500 | ["135","137"] | ["2.1731","0.4740"] | [] | ["SPHR"] | 135.0000 | 137.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:05:10Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d5b-7595-7b50-982f-b44940a7eaf8 | SPCX | 2026-09-04 12:58 | call_diagonal_spread_bearish | 2 | 1 | 65 | 75985.00 | short | ask | 148.8900 | 0.3000 | ["141","149"] | ["1.6063","0.4621"] | [] | ["XCBO"] | 141.0000 | 149.0000 | 0 | 7 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:59:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d5b-cf6d-74a0-bf7b-b8c760a92302 | SPCX | 2026-09-04 12:58 | call_diagonal_spread_bearish | 2 | 1 | 99 | 26235.00 | short | bid | 148.9201 | 0.0300 | ["150","152.5"] | ["0.5777","0.4688"] | [] | ["XPHO"] | 150.0000 | 152.5000 | 0 | 7 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:59:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6c-ee3d-7620-a855-c1f6707d8c3f | SPCX | 2026-09-04 13:17 | call_diagonal_spread_bearish | 2 | 1 | 10 | 47770.00 | long | ask | 148.8100 | 1.0500 | ["145","155"] | ["0.5393","0.5498"] | [] | ["XMIO"] | 145.0000 | 155.0000 | 105 | 286 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:17:57Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d75-a0cd-7031-9b9f-4a551453f903 | SPCX | 2026-09-04 13:26 | call_diagonal_spread_bearish | 2 | 1 | 300 | 39900.00 | long | ask | 148.8300 | 0.0200 | ["150","157.5"] | ["0.5652","0.4838"] | [] | ["ARCO"] | 150.0000 | 157.5000 | 0 | 7 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:27:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d88-751d-7eb1-b530-41cbe8e82572 | SPCX | 2026-09-04 13:47 | call_diagonal_spread_bearish | 2 | 1 | 30 | 32190.00 | long | bid | 148.4300 | 0.2000 | ["145","150"] | ["0.4628","0.4808"] | [] | ["XISX"] | 145.0000 | 150.0000 | 7 | 14 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:47:51Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8d-33f5-7301-8e65-bd601a8c4a48 | SPCX | 2026-09-04 13:52 | call_diagonal_spread_bearish | 2 | 1 | 10 | 49730.00 | long | bid | 148.3800 | 0.6500 | ["130","140"] | ["0.5499","0.5342"] | [] | ["AMXO"] | 130.0000 | 140.0000 | 77 | 133 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:53:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d98-5f55-7cb2-bc00-1367ec2f43ad | SPCX | 2026-09-04 14:04 | call_diagonal_spread_bearish | 2 | 1 | 44 | 149380.00 | long | ask | 148.3000 | 0.6500 | ["145","150"] | ["0.5450","0.5390"] | [] | ["XISX"] | 145.0000 | 150.0000 | 77 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:05:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da8-9f7d-77d1-974e-b65a6bc34596 | SPCX | 2026-09-04 14:22 | call_diagonal_spread_bearish | 2 | 1 | 10 | 41730.00 | long | ask | 148.7200 | 1.2500 | ["128","130"] | ["5.7926","0.5175"] | [] | ["XCBO"] | 128.0000 | 130.0000 | 0 | 28 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:22:41Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da9-726d-75f2-afa7-1739bb93942d | SPCX | 2026-09-04 14:23 | call_diagonal_spread_bearish | 2 | 1 | 8 | 33384.00 | short | bid | 148.6750 | 1.4500 | ["128","129"] | ["6.2751","0.4977"] | [] | ["XMIO"] | 128.0000 | 129.0000 | 0 | 21 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:24:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |