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-720f-77b0-82d9-d0a7452592a2 | SPCX | 2026-09-18 15:38 | put_diagonal_spread | 2 | 1 | 50 | 107400.00 | long | ask | 152.7300 | 0.3500 | ["160","165"] | ["4.2293","0.5180"] | [] | ["XCBO"] | 160.0000 | 165.0000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:38:57Z"} | 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 |
| 01a0b02c-6c53-7683-b664-17b29a2c8535 | SPCX | 2026-09-17 12:21 | put_diagonal_spread | 2 | 1 | 5 | 39295.00 | short | bid | 154.8350 | 0.9500 | ["160","180"] | ["0.5598","0.5797"] | [] | ["XCBO"] | 160.0000 | 180.0000 | 273 | 456 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:21:52Z"} | 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 |
| 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 |
| 01a0aa69-34a9-77e1-abfc-f77482f6ac00 | SPCX | 2026-09-16 09:30 | put_diagonal_spread | 2 | 1 | 4 | 25636.00 | short | bid | 145.7850 | 2.7500 | ["120","140"] | ["0.5855","0.5881"] | [] | ["XCBO"] | 120.0000 | 140.0000 | 821 | 856 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:12Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 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 |
| 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 |
| 01a0a180-8490-7bd1-a350-163cd97348a3 | SPCX | 2026-09-14 15:59 | put_diagonal_spread | 2 | 1 | 50 | 138600.00 | long | ask | 148.1450 | 0.6500 | ["160","162.5"] | ["0.6039","0.5364"] | [] | ["AMXO"] | 160.0000 | 162.5000 | 4 | 11 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:59:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091fa-fa00-7351-b948-1f2e5f0577c9 | SPCX | 2026-09-11 15:38 | put_diagonal_spread | 2 | 1 | 10 | 25660.00 | long | bid | 151.0460 | 0.8500 | ["110","125"] | ["0.5773","0.5646"] | [] | ["XCBO"] | 110.0000 | 125.0000 | 279 | 371 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:39:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09139-a5d0-7633-a3f0-0c947b6d1fa7 | SPCX | 2026-09-11 12:07 | put_diagonal_spread | 2 | 1 | 15 | 37170.00 | short | bid | 148.5900 | 0.5000 | ["155","165"] | ["1.0818","0.5235"] | [] | ["XCBO"] | 155.0000 | 165.0000 | 0 | 21 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:07:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090cd-3800-7f70-a09f-0003d81be9d3 | SPCX | 2026-09-11 10:09 | put_diagonal_spread | 2 | 1 | 20 | 35700.00 | short | bid | 148.8801 | 0.6000 | ["75","150"] | ["0.6022","0.5136"] | [] | ["XMIO"] | 75.0000 | 150.0000 | 28 | 826 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:09:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ca9-bd70-7da3-a36d-da04a092b83a | SPCX | 2026-09-10 14:52 | put_diagonal_spread | 2 | 1 | 200 | 29600.00 | short | bid | 148.6900 | 0.0200 | ["135","145"] | ["0.5781","0.6693"] | [] | ["XMIO"] | 135.0000 | 145.0000 | 1 | 8 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:52:38Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08252-2c18-70e0-aebd-8972083e28e5 | SPCX | 2026-09-08 14:40 | put_diagonal_spread | 2 | 1 | 15 | 27015.00 | short | ask | 153.6000 | 0.2500 | ["150","160"] | ["0.5339","0.5753"] | [] | ["XISX"] | 150.0000 | 160.0000 | 10 | 38 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:41:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |