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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b611-5d20-7ed0-b8f5-3df92239f876 | SPCX | 2026-09-18 15:49 | put_vertical_spread | 2 | 1 | 80 | 78400.00 | long | ask | 153.2095 | 0.0600 | ["145","160"] | ["0.4973","0.5193"] | ["152.62"] | ["SPHR"] | 145.0000 | 160.0000 | 7 | 7 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:49:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b54a-5017-76e2-b084-d1610d156b21 | SPCX | 2026-09-18 12:12 | synthetic | 2 | 2 | 287 | 72324.00 | long | ask | 151.3450 | 0.0400 | ["150"] | ["0.9067"] | ["151.50"] | ["AMXO"] | 150.0000 | 150.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:12:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b518-fb2f-7523-a7bd-8639c94b043c | SPCX | 2026-09-18 11:18 | synthetic | 2 | 2 | 125 | 30250.00 | short | bid | 151.5450 | 0.0400 | ["150"] | ["0.7390"] | ["151.40"] | ["AMXO"] | 150.0000 | 150.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:18:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afcb-a2fb-7780-b95d-38f6ae9a53cc | SPCX | 2026-09-17 10:35 | call_diagonal_spread | 2 | 1 | 71 | 35642.00 | short | bid | 154.7200 | 0.0800 | ["155","175"] | ["0.7266","0.5204"] | [] | ["SPHR"] | 155.0000 | 175.0000 | 1 | 29 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:36:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a62e-f876-7681-a159-1e20338c674d | SPCX | 2026-09-15 13:48 | put_calendar | 2 | 1 | 50 | 99450.00 | long | bid | 143.6200 | 0.8500 | ["152.5"] | ["0.5529"] | [] | ["SPHR"] | 152.5000 | 152.5000 | 3 | 10 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:49:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09205-5658-7862-beb2-9950af5d43a7 | SPCX | 2026-09-11 15:50 | call_calendar | 2 | 1 | 76 | 43700.00 | long | bid | 151.0200 | 0.2400 | ["150"] | ["0.9818"] | [] | ["SPHR"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:50:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091fc-8871-71d2-8fd2-51c869bfbc4c | SPCX | 2026-09-11 15:40 | put_diagonal_spread | 2 | 1 | 50 | 35350.00 | long | ask | 151.7200 | 0.1100 | ["152.5","155"] | ["1.2785","0.5133"] | [] | ["SPHR"] | 152.5000 | 155.0000 | 0 | 7 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:40:55Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bb5-d021-7ba2-bfa0-c3467484384d | SPCX | 2026-09-10 10:25 | call_vertical_spread | 2 | 1 | 60 | 54480.00 | long | ask | 150.0350 | 0.2200 | ["155","195"] | ["0.5293","0.5718"] | ["162.02"] | ["XBOX"] | 155.0000 | 195.0000 | 36 | 36 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:26:03Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087ba-ffb8-71e2-8ba2-9823e54bdaea | SPCX | 2026-09-09 15:52 | call_calendar | 2 | 1 | 60 | 71160.00 | short | bid | 147.5226 | 0.2000 | ["144"] | ["0.5858"] | [] | ["SPHR"] | 144.0000 | 144.0000 | 2 | 9 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:53:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081c7-b6c9-7143-adf6-ba67c59bcd4b | SPCX | 2026-09-08 12:09 | call_diagonal_spread | 2 | 1 | 50 | 49500.00 | short | ask | 153.4850 | 0.5000 | ["155","175"] | ["0.5751","0.5414"] | [] | ["SPHR"] | 155.0000 | 175.0000 | 10 | 45 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:09:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d68-9cc5-7031-8357-6869c4e338eb | SPCX | 2026-09-04 13:12 | risk_reversal | 2 | 1 | 75 | 98775.00 | short | bid | 148.7580 | 0.4000 | ["120","195"] | ["0.5562","0.5378"] | ["195.17"] | ["XBOX"] | 120.0000 | 195.0000 | 133 | 133 | false | true | false | true | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:13:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |