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-da1f-72e2-9e24-3b7839b1fa8c | SPCX | 2026-09-18 15:50 | iron_condor | 4 | 1 | 50 | 62100.00 | unknown | — | 154.2100 | 0.2400 | ["150","152.5","155","157.5"] | ["0.4940","0.4960","0.4905","0.4961"] | [] | ["XCBO"] | 150.0000 | 157.5000 | 7 | 7 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c3-6cd8-7521-8364-fc79d005ba13 | SPCX | 2026-09-18 09:44 | iron_condor | 4 | 1 | 70 | 43470.00 | unknown | bid | 154.0500 | 0.2800 | ["125","135","185","195"] | ["0.5342","0.5053","0.5135","0.5299"] | ["128.79","191.21"] | ["XCBO"] | 125.0000 | 195.0000 | 35 | 35 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:45:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d5-a0bb-7023-8e5e-3cd543dec6af | SPCX | 2026-09-17 15:26 | iron_condor | 4 | 1 | 35 | 30905.00 | unknown | — | 155.2900 | 0.1200 | ["148","150","160","162.5"] | ["0.5070","0.5020","0.5001","0.5067"] | [] | ["XCBO"] | 148.0000 | 162.5000 | 8 | 8 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:26:38Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b040-07db-7853-8bdd-00b7f7462588 | SPCX | 2026-09-17 12:42 | iron_condor | 4 | 1 | 5 | 59705.00 | long | ask | 154.7700 | 3.4500 | ["100","145","225","270"] | ["0.5906","0.5904","0.5588","0.5566"] | ["115.75","254.25"] | ["XCBO"] | 100.0000 | 270.0000 | 820 | 820 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:43:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a62d-eaee-7de2-b110-6d72deb671f7 | SPCX | 2026-09-15 13:46 | iron_condor | 4 | 1 | 5 | 57130.00 | long | ask | 143.6700 | 3.7500 | ["100","145","225","270"] | ["0.5846","0.5877","0.5635","0.5627"] | ["115.30","254.70"] | ["XMIO"] | 100.0000 | 270.0000 | 822 | 822 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:47:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08c5e-a6c8-7853-9ff2-3144efe862a6 | SPCX | 2026-09-10 13:30 | iron_condor | 4 | 1 | 20 | 29200.00 | unknown | — | 151.6201 | 0.4400 | ["120","125","160","165"] | ["0.5868","0.5654","0.5185","0.5196"] | [] | ["XMIO"] | 120.0000 | 165.0000 | 36 | 36 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:30:14Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08261-d3e8-78b3-a067-1ea868f24bad | SPCX | 2026-09-08 14:57 | iron_condor | 4 | 1 | 10 | 29980.00 | unknown | — | 153.7300 | 0.7500 | ["120","135","180","195"] | ["0.5813","0.5723","0.5637","0.5753"] | [] | ["AMXO"] | 120.0000 | 195.0000 | 101 | 101 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:57:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0819a-8479-7930-b03c-a459ec6f2c63 | SPCX | 2026-09-08 11:19 | iron_condor | 4 | 2 | 110 | 30800.00 | unknown | — | 149.6870 | 0.1100 | ["125","130","165","170"] | ["0.6506","0.6106","0.5790","0.6008"] | [] | ["XCBO"] | 125.0000 | 170.0000 | 10 | 10 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:19:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |