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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e3-f037-7132-9f55-70003a0cf20e | SPCX | 2026-09-18 15:00 | strangle | 2 | 1 | 18 | 202842.00 | short | bid | 151.0700 | 3.8000 | ["120","155"] | ["0.5711","0.5851"] | ["42.31","232.69"] | ["MCRY"] | 120.0000 | 155.0000 | 854 | 854 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:00:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b018-4813-7050-84c1-8e9be23cd8a5 | SPCX | 2026-09-17 11:59 | strangle | 2 | 1 | 69 | 399993.00 | unknown | — | 154.2450 | 2.4500 | ["125","265"] | ["0.5857","0.5553"] | [] | ["XCBO"] | 125.0000 | 265.0000 | 855 | 855 | true | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:59:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aaac-1143-7c53-92e3-45db4b84fad8 | SPCX | 2026-09-16 10:43 | strangle | 2 | 1 | 3 | 31569.00 | unknown | — | 150.8100 | 2.1500 | ["100","200"] | ["0.6167","0.5786"] | [] | ["XPHO"] | 100.0000 | 200.0000 | 93 | 93 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:43:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a62d-b43e-71c3-bb5f-1fabcf1016ca | SPCX | 2026-09-15 13:46 | strangle | 2 | 1 | 3 | 31860.00 | unknown | — | 143.6600 | 1.6500 | ["100","135"] | ["0.5799","0.5890"] | [] | ["XCBO"] | 100.0000 | 135.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 |
| 01a0a629-7266-7060-8727-d220801cdb66 | SPCX | 2026-09-15 13:42 | strangle | 2 | 1 | 120 | 63360.00 | short | bid | 143.8700 | 0.1600 | ["105","200"] | ["0.5798","0.5449"] | ["99.72","205.28"] | ["XCBO"] | 105.0000 | 200.0000 | 94 | 94 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:43:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a61c-0cb6-76c0-9bd8-848dbee7d1b9 | SPCX | 2026-09-15 13:27 | strangle | 2 | 1 | 10 | 106120.00 | unknown | — | 143.9150 | 1.1500 | ["100","135"] | ["0.5787","0.5867"] | [] | ["XMIO"] | 100.0000 | 135.0000 | 822 | 822 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:28:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a619-1eb6-70c1-a40a-30f1de1c811d | SPCX | 2026-09-15 13:24 | strangle | 2 | 1 | 10 | 106170.00 | unknown | — | 143.8300 | 0.9500 | ["100","135"] | ["0.5806","0.5867"] | [] | ["XMIO"] | 100.0000 | 135.0000 | 822 | 822 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:24:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ff-0aee-7f00-9631-ecc42618aa22 | SPCX | 2026-09-15 12:55 | strangle | 2 | 1 | 3 | 32013.00 | unknown | — | 144.5100 | 1.7000 | ["100","135"] | ["0.5821","0.5877"] | [] | ["MCRY"] | 100.0000 | 135.0000 | 822 | 822 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:56:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56e-5bde-7aa0-b742-90e872d8236f | SPCX | 2026-09-15 10:17 | strangle | 2 | 1 | 3 | 32259.00 | unknown | — | 146.3795 | 0.8500 | ["100","135"] | ["0.5781","0.5871"] | [] | ["XCBO"] | 100.0000 | 135.0000 | 822 | 822 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:18:04Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a569-27d6-7f11-b749-a57cc574bd79 | SPCX | 2026-09-15 10:12 | strangle | 2 | 1 | 4 | 43136.00 | unknown | — | 146.5650 | 1.2500 | ["100","135"] | ["0.5800","0.5884"] | [] | ["MCRY"] | 100.0000 | 135.0000 | 822 | 822 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a563-efe6-7160-a429-505dccef78c2 | SPCX | 2026-09-15 10:06 | strangle | 2 | 1 | 5 | 53885.00 | unknown | — | 146.6600 | 1.1500 | ["100","135"] | ["0.5783","0.5879"] | [] | ["XCBO"] | 100.0000 | 135.0000 | 822 | 822 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:06:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a556-43e6-7f72-9000-7c8241fc0cda | SPCX | 2026-09-15 09:51 | strangle | 2 | 1 | 10 | 107410.00 | unknown | — | 145.2519 | 3.3000 | ["100","135"] | ["0.5823","0.5914"] | [] | ["XMIO"] | 100.0000 | 135.0000 | 822 | 822 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:51:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091ec-82e0-7a22-b46f-1d7e722421e7 | SPCX | 2026-09-11 15:23 | strangle | 2 | 1 | 14 | 266140.00 | long | ask | 149.8750 | 0.8500 | ["75","250"] | ["0.5881","0.6357"] | ["59.90","265.10"] | ["XPHO"] | 75.0000 | 250.0000 | 462 | 462 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:23:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc0-8190-7e83-8016-a99a1d043201 | SPCX | 2026-09-10 15:16 | strangle | 2 | 1 | 20 | 107000.00 | unknown | — | 148.2650 | 1.0000 | ["135","200"] | ["0.5873","0.5656"] | [] | ["AMXO"] | 135.0000 | 200.0000 | 498 | 498 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:17:15Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cba-6ee0-7d00-9e91-b66efd002c67 | SPCX | 2026-09-10 15:10 | strangle | 2 | 1 | 20 | 30960.00 | short | bid | 148.7000 | 0.3000 | ["135","220"] | ["0.5575","0.5664"] | ["119.52","235.48"] | ["XMIO"] | 135.0000 | 220.0000 | 127 | 127 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:10:54Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0875f-eb50-71f2-940f-6c6c9815ef70 | SPCX | 2026-09-09 14:13 | strangle | 2 | 1 | 6 | 60612.00 | unknown | — | 148.6889 | 2.8500 | ["135","145"] | ["0.5861","0.5806"] | [] | ["MCRY"] | 135.0000 | 145.0000 | 828 | 828 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:13:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0813e-fae0-7f83-ab64-1339a5a0852a | SPCX | 2026-09-08 09:39 | strangle | 2 | 1 | 100 | 321600.00 | unknown | — | 146.6450 | 0.9500 | ["100","140"] | ["0.5823","0.5523"] | [] | ["XCBO"] | 100.0000 | 140.0000 | 192 | 192 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:39:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813b-1e98-70e0-9a94-258a86a620ff | SPCX | 2026-09-08 09:35 | strangle | 2 | 1 | 10 | 31650.00 | unknown | — | 145.6000 | 1.2000 | ["100","140"] | ["0.5833","0.5526"] | [] | ["MCRY"] | 100.0000 | 140.0000 | 192 | 192 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:35:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06de2-d9be-7da0-bad3-91f0762145d6 | SPCX | 2026-09-04 15:26 | strangle | 2 | 1 | 100 | 99300.00 | long | ask | 149.0800 | 0.2500 | ["120","200"] | ["0.5680","0.5546"] | ["110.07","209.93"] | ["XCBO"] | 120.0000 | 200.0000 | 105 | 105 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:26:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de1-0115-7a21-8ea3-cd735fe4f7ac | SPCX | 2026-09-04 15:24 | strangle | 2 | 1 | 50 | 50000.00 | long | ask | 149.2236 | 0.2500 | ["120","200"] | ["0.5702","0.5554"] | ["110","210.00"] | ["XBOX"] | 120.0000 | 200.0000 | 105 | 105 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:24:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de0-64d5-7180-b969-e36adc53a060 | SPCX | 2026-09-04 15:23 | strangle | 2 | 1 | 40 | 104920.00 | short | bid | 149.1800 | 0.7100 | ["175","250"] | ["0.5723","0.9130"] | ["148.77","276.23"] | ["XCBO"] | 175.0000 | 250.0000 | 14 | 14 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:23:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06ddf-c895-77b2-865d-23d92a93fc2b | SPCX | 2026-09-04 15:22 | strangle | 2 | 1 | 10 | 26450.00 | short | bid | 148.9800 | 0.5100 | ["175","225"] | ["0.5739","0.8219"] | ["148.55","251.45"] | ["XCBO"] | 175.0000 | 225.0000 | 14 | 14 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:23:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |