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-bec7-7112-a281-d43e000060b2 | SPCX | 2026-09-18 15:50 | put_diagonal_spread | 2 | 1 | 100 | 281700.00 | unknown | ask | 154.7200 | 3.4500 | ["160","175"] | ["7.0521","0.5308"] | [] | ["XCBO"] | 160.0000 | 175.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b607-df6f-7162-b246-59a231eb89d1 | SPCX | 2026-09-18 15:39 | put_diagonal_spread | 2 | 2 | 50 | 107700.00 | unknown | ask | 152.7100 | 0.3640 | ["160","165"] | ["4.3961","0.5196"] | [] | ["XISX"] | 160.0000 | 165.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:39:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b550-a147-7ef1-9b1a-2e66508bc8cc | SPCX | 2026-09-18 12:19 | put_diagonal_spread | 2 | 1 | 2454 | 377916.00 | unknown | bid | 150.3300 | 0.0300 | ["138","150"] | ["0.5034","0.9601"] | [] | ["XISX"] | 138.0000 | 150.0000 | 0 | 7 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:19:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-1237-7432-9e02-793d9af9f3a0 | SPCX | 2026-09-18 11:06 | put_diagonal_spread | 2 | 1 | 25 | 34175.00 | unknown | — | 152.2900 | 0.5500 | ["120","125"] | ["0.5573","0.5399"] | [] | ["XCBO"] | 120.0000 | 125.0000 | 91 | 272 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:06:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e1-418f-7c72-84a3-bf88435436c1 | SPCX | 2026-09-18 10:17 | put_diagonal_spread | 2 | 1 | 33 | 51117.00 | unknown | bid | 151.1899 | 0.4000 | ["140","147"] | ["0.5404","0.4959"] | [] | ["BATO"] | 140.0000 | 147.0000 | 42 | 63 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:17:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b04e-cd1b-7f33-8ab1-d73f462f9fa3 | SPCX | 2026-09-17 12:59 | put_diagonal_spread | 2 | 1 | 30 | 37500.00 | unknown | — | 154.7900 | 0.2500 | ["95","125"] | ["0.5865","0.5436"] | [] | ["XISX"] | 95.0000 | 125.0000 | 120 | 365 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:59:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00a-4a0b-7bb1-817f-a9a77488619b | SPCX | 2026-09-17 11:44 | put_diagonal_spread | 2 | 1 | 20 | 29260.00 | unknown | — | 153.7500 | 0.2500 | ["140","150"] | ["0.5069","0.5476"] | [] | ["XISX"] | 140.0000 | 150.0000 | 29 | 64 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:44:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc6-47e3-7653-ad63-d2c053148195 | SPCX | 2026-09-17 10:30 | put_diagonal_spread | 2 | 1 | 65 | 36660.00 | unknown | — | 154.9800 | 0.1200 | ["150","155"] | ["0.7605","0.5463"] | [] | ["XCBO"] | 150.0000 | 155.0000 | 1 | 8 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:30:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc0-2d63-70f2-95d7-0acf2a87ffbd | SPCX | 2026-09-17 10:23 | put_diagonal_spread | 2 | 6 | 106 | 31017.00 | unknown | — | 154.1550 | 0.1100 | ["150","152.5"] | ["0.7484","0.5519"] | [] | ["AMXO","EMLD","XBOX","XCBO","XMIO","XPHO"] | 150.0000 | 152.5000 | 1 | 8 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:23:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af96-046b-78a3-93c3-1bbafe91248f | SPCX | 2026-09-17 09:37 | put_diagonal_spread | 2 | 1 | 10 | 83040.00 | unknown | — | 154.1300 | 3.9000 | ["175","200"] | ["0.5592","0.6062"] | [] | ["XCBO"] | 175.0000 | 200.0000 | 64 | 183 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:37:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aab8-32bb-7201-862e-bedc967d8386 | SPCX | 2026-09-16 10:56 | put_diagonal_spread | 2 | 1 | 20 | 85600.00 | unknown | — | 151.6900 | 0.4500 | ["165","170"] | ["0.5635","0.5285"] | [] | ["EDGO"] | 165.0000 | 170.0000 | 30 | 65 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:57:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab8-1b4b-7841-8275-84305a6d8fa3 | SPCX | 2026-09-16 10:56 | put_diagonal_spread | 2 | 1 | 7 | 29960.00 | unknown | — | 151.7400 | 0.7000 | ["165","170"] | ["0.5646","0.5312"] | [] | ["EDGO"] | 165.0000 | 170.0000 | 30 | 65 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:57:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab8-1b4b-7841-8275-842bf68f4984 | SPCX | 2026-09-16 10:56 | put_diagonal_spread | 2 | 1 | 7 | 29967.00 | unknown | — | 151.7400 | 0.7000 | ["165","170"] | ["0.5650","0.5312"] | [] | ["C2OX"] | 165.0000 | 170.0000 | 30 | 65 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:57:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab6-dee3-7641-b217-958fbdf0ee38 | SPCX | 2026-09-16 10:55 | put_diagonal_spread | 2 | 1 | 20 | 27000.00 | unknown | — | 151.0300 | 0.1500 | ["150","155"] | ["0.5122","0.6817"] | [] | ["XPHO"] | 150.0000 | 155.0000 | 2 | 30 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:55:21Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa81-731b-7161-bcd4-a0763794daab | SPCX | 2026-09-16 09:56 | put_diagonal_spread | 2 | 1 | 3 | 32070.00 | unknown | — | 150.0500 | 5.2000 | ["165","175"] | ["0.6156","0.6097"] | [] | ["XBOX"] | 165.0000 | 175.0000 | 639 | 821 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:56:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69d-100e-75d2-a281-f5a5469dab43 | SPCX | 2026-09-15 15:48 | put_diagonal_spread | 2 | 1 | 10 | 25200.00 | unknown | — | 143.6900 | 1.3000 | ["100","105"] | ["0.5783","0.5756"] | [] | ["XMIO"] | 100.0000 | 105.0000 | 458 | 493 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:48:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a67d-a516-7051-bc46-400ea01fd2e0 | SPCX | 2026-09-15 15:14 | put_diagonal_spread | 2 | 1 | 16 | 35200.00 | unknown | — | 143.6700 | 0.1800 | ["135","150"] | ["0.5524","0.5361"] | [] | ["XMIO"] | 135.0000 | 150.0000 | 10 | 122 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:14:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a61f-fc86-77a2-ba13-8aa08fbf9cf6 | SPCX | 2026-09-15 13:31 | put_diagonal_spread | 2 | 1 | 20 | 46440.00 | unknown | — | 143.7500 | 0.3500 | ["150","155"] | ["0.4973","0.6172"] | [] | ["XCBO"] | 150.0000 | 155.0000 | 3 | 31 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:32:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a589-69a6-7f31-aa42-eebac5c65950 | SPCX | 2026-09-15 10:47 | put_diagonal_spread | 2 | 1 | 10 | 48280.00 | unknown | — | 145.0561 | 1.5000 | ["120","165"] | ["0.5898","0.5903"] | [] | ["XBOX"] | 120.0000 | 165.0000 | 17 | 822 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:47:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a556-8e1d-7961-be41-740b3c3997c1 | SPCX | 2026-09-15 09:51 | put_diagonal_spread | 2 | 1 | 30 | 66270.00 | unknown | — | 145.0500 | 0.6500 | ["147","149"] | ["0.5038","0.4989"] | [] | ["XISX"] | 147.0000 | 149.0000 | 38 | 45 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:52:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a553-de9e-77a3-96e2-5782a982e4d9 | SPCX | 2026-09-15 09:48 | put_diagonal_spread | 2 | 1 | 50 | 59150.00 | unknown | — | 145.9200 | 0.2500 | ["148","150"] | ["0.5273","0.6166"] | [] | ["XMIO"] | 148.0000 | 150.0000 | 3 | 10 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:48:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a548-6135-79d0-81f4-2ed85fc9fbf7 | SPCX | 2026-09-15 09:36 | put_diagonal_spread | 2 | 1 | 2352 | 616606.00 | unknown | — | 146.4400 | 0.0800 | ["133","140"] | ["0.5496","0.6548"] | [] | ["SPHR"] | 133.0000 | 140.0000 | 3 | 17 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:36:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08b91-2180-70e0-a9da-32a0ab1b145b | SPCX | 2026-09-10 09:45 | put_diagonal_spread | 2 | 1 | 20 | 28160.00 | unknown | — | 151.4150 | 0.5000 | ["65","135"] | ["0.6154","0.5859"] | [] | ["XPHO"] | 65.0000 | 135.0000 | 71 | 827 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:45:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086d6-7fa0-7143-be23-ae4acf779d4b | SPCX | 2026-09-09 11:43 | put_diagonal_spread | 2 | 1 | 33 | 75636.00 | unknown | — | 146.3401 | 0.5500 | ["148","152.5"] | ["0.5166","0.5154"] | [] | ["XISX"] | 148.0000 | 152.5000 | 30 | 44 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:43:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08275-b5c0-7603-a56c-0a2e809315ae | SPCX | 2026-09-08 15:19 | put_diagonal_spread | 2 | 1 | 34 | 477020.00 | unknown | — | 154.3950 | 6.1000 | ["200","250"] | ["2.2552","2.2415"] | [] | ["XBOX"] | 200.0000 | 250.0000 | 3 | 10 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:19:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |