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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e4-c70f-7b11-828f-f0ee752dde52 | SPCX | 2026-09-18 15:01 | put_calendar | 2 | 1 | 243 | 45684.00 | long | ask | 151.0950 | 0.0700 | ["100"] | ["0.6043"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 63 | 91 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:01:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d6-5f8f-7942-be2f-f04d6174b51c | SPCX | 2026-09-18 14:45 | put_calendar | 2 | 1 | 22 | 115720.00 | long | ask | 150.7700 | 1.4000 | ["135"] | ["0.5694"] | [] | ["XCBO"] | 135.0000 | 135.0000 | 455 | 637 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:45:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b529-182f-70c3-a222-52f022831a46 | SPCX | 2026-09-18 11:36 | put_calendar | 2 | 1 | 300 | 318300.00 | short | bid | 150.8700 | 0.1500 | ["155"] | ["0.6919"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:36:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0df-fd13-7b31-ae66-6a09be2bcb58 | SPCX | 2026-09-17 15:37 | put_calendar | 2 | 1 | 6 | 41760.00 | short | ask | 154.9700 | 1.4000 | ["180"] | ["0.5509"] | [] | ["AMXO"] | 180.0000 | 180.0000 | 92 | 183 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:38:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b083-69db-7880-8156-67c31cc0b4a3 | SPCX | 2026-09-17 13:56 | put_calendar | 2 | 1 | 26 | 84266.00 | unknown | — | 154.9300 | 0.6000 | ["170"] | ["0.5913"] | [] | ["AMXO"] | 170.0000 | 170.0000 | 1 | 22 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:57:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afdc-44cb-7541-86a2-b272d17b8bf5 | SPCX | 2026-09-17 10:54 | put_calendar | 2 | 1 | 66 | 112398.00 | short | bid | 153.9900 | 0.7000 | ["75"] | ["0.5993"] | [] | ["XCBO"] | 75.0000 | 75.0000 | 820 | 855 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:54:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb5-e87b-7540-9e46-a58a7a4cf3dd | SPCX | 2026-09-17 10:12 | put_calendar | 2 | 1 | 150 | 32700.00 | unknown | — | 156.1050 | 0.1500 | ["100"] | ["0.6570"] | [] | ["XMIO"] | 100.0000 | 100.0000 | 64 | 92 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:12:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb8-262b-7913-bee3-04963f9d5d84 | SPCX | 2026-09-16 15:36 | put_calendar | 2 | 1 | 10 | 67230.00 | short | ask | 149.8400 | 1.6000 | ["175"] | ["0.5580"] | [] | ["XCBO"] | 175.0000 | 175.0000 | 65 | 184 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:36:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5e-4e2b-70b1-b28e-f3e51acc4669 | SPCX | 2026-09-16 13:57 | put_calendar | 2 | 1 | 670 | 729630.00 | short | bid | 151.0071 | 0.0700 | ["150"] | ["0.6138"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 2 | 30 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:58:03Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae1-b7a3-7001-be4f-ea7025672b57 | SPCX | 2026-09-16 11:41 | put_calendar | 2 | 1 | 800 | 132000.00 | short | ask | 151.9400 | 0.0300 | ["140"] | ["0.6802"] | [] | ["XCBO"] | 140.0000 | 140.0000 | 2 | 9 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:42:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa9c-dea2-7740-8dab-c84a355588ad | SPCX | 2026-09-16 10:26 | put_calendar | 2 | 1 | 28 | 45696.00 | unknown | — | 151.4100 | 0.8500 | ["85"] | ["0.5966"] | [] | ["XCBO"] | 85.0000 | 85.0000 | 492 | 639 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:26:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7c-047b-7453-8efc-90ce34f880b7 | SPCX | 2026-09-16 09:50 | put_calendar | 2 | 1 | 30 | 32250.00 | short | bid | 150.4350 | 0.2000 | ["143"] | ["0.5277"] | [] | ["XMIO"] | 143.0000 | 143.0000 | 23 | 37 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:50:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa6f-a86b-7f12-b381-29694c3c349b | SPCX | 2026-09-16 09:37 | put_calendar | 2 | 1 | 10 | 33190.00 | long | ask | 146.7000 | 0.8000 | ["140"] | ["0.5468"] | [] | ["AMXO"] | 140.0000 | 140.0000 | 156 | 184 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:37:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a57e-0b7e-7242-a5c2-b1b48a68d480 | SPCX | 2026-09-15 10:34 | put_calendar | 2 | 1 | 3 | 26496.00 | unknown | — | 145.6900 | 4.9500 | ["190"] | ["0.5440"] | [] | ["XCBO"] | 190.0000 | 190.0000 | 24 | 31 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:35:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a570-0d76-7fe1-a830-01c30771ee7e | SPCX | 2026-09-15 10:19 | put_calendar | 2 | 1 | 9 | 25470.00 | unknown | — | 146.4944 | 1.2000 | ["160"] | ["0.6033"] | [] | ["XCBO"] | 160.0000 | 160.0000 | 3 | 10 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:20:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a542-c7a3-7b53-804c-fab6779edb34 | SPCX | 2026-09-15 09:30 | put_calendar | 2 | 1 | 10 | 103520.00 | long | bid | 148.2450 | 9.7250 | ["200"] | ["0.6440"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 24 | 31 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:30:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a171-e660-73e3-ac32-1c7d57898f1b | SPCX | 2026-09-14 15:43 | put_calendar | 2 | 1 | 20 | 84040.00 | short | ask | 149.4600 | 3.1500 | ["170"] | ["0.6885"] | [] | ["XMIO"] | 170.0000 | 170.0000 | 4 | 25 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:43:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a145-2170-7d71-bb5e-a1733b8bd4be | SPCX | 2026-09-14 14:54 | put_calendar | 2 | 1 | 8 | 57800.00 | short | ask | 150.3800 | 4.7000 | ["185"] | ["1.0161"] | [] | ["XCBO"] | 185.0000 | 185.0000 | 4 | 67 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:55:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a144-9ca0-7852-b44e-eca3e16610fe | SPCX | 2026-09-14 14:53 | put_calendar | 2 | 1 | 7 | 44177.00 | short | bid | 150.3863 | 3.1000 | ["180"] | ["0.8796"] | [] | ["MCRY"] | 180.0000 | 180.0000 | 4 | 67 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:54:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a137-0428-75c0-a434-98959383d41b | SPCX | 2026-09-14 14:38 | put_calendar | 2 | 1 | 20 | 33440.00 | unknown | — | 150.9950 | 0.2500 | ["145"] | ["0.5325"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 32 | 67 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:39:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b4-33e0-7262-b666-fb08bbe893a4 | SPCX | 2026-09-14 12:15 | put_calendar | 2 | 1 | 10 | 39720.00 | short | ask | 151.3700 | 2.8000 | ["170"] | ["0.7188"] | [] | ["XCBO"] | 170.0000 | 170.0000 | 4 | 18 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:16:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b0-3858-7e73-82f4-8f9b3ceabccd | SPCX | 2026-09-14 12:11 | put_calendar | 2 | 1 | 7 | 36708.00 | long | ask | 150.7350 | 1.1500 | ["140"] | ["0.5743"] | [] | ["EDGO"] | 140.0000 | 140.0000 | 368 | 494 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:12:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09138-de98-7e62-b020-78e29f1b90fd | SPCX | 2026-09-11 12:06 | put_calendar | 2 | 1 | 30 | 34870.00 | short | bid | 148.5020 | 0.2000 | ["150"] | ["0.5158"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 7 | 14 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:07:03Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce3-4bd0-7053-8524-d971dd05645a | SPCX | 2026-09-10 15:54 | put_calendar | 2 | 1 | 5 | 25355.00 | short | bid | 147.5500 | 2.2500 | ["170"] | ["0.5162"] | [] | ["EDGO"] | 170.0000 | 170.0000 | 8 | 71 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:55:00Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ce1-01e0-7931-9c89-3816d4b78135 | SPCX | 2026-09-10 15:52 | put_calendar | 2 | 1 | 14 | 34146.00 | long | bid | 148.0700 | 1.9500 | ["160"] | ["0.7249"] | [] | ["XMIO"] | 160.0000 | 160.0000 | 1 | 8 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:52:53Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c57-e450-7130-968e-e52d4b51a5fb | SPCX | 2026-09-10 13:22 | put_calendar | 2 | 1 | 26 | 77610.00 | long | ask | 150.8476 | 3.0000 | ["165"] | ["0.9362"] | [] | ["XMIO"] | 165.0000 | 165.0000 | 1 | 8 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:23:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bf6-53c0-71d0-b47c-48ed7d66ed4a | SPCX | 2026-09-10 11:36 | put_calendar | 2 | 1 | 30 | 68730.00 | short | bid | 150.0150 | 0.4500 | ["160"] | ["0.6843"] | [] | ["XCBO"] | 160.0000 | 160.0000 | 1 | 15 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:36:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08236-ad08-7922-b860-3e22e24cb012 | SPCX | 2026-09-08 14:10 | put_calendar | 2 | 1 | 30 | 38640.00 | short | bid | 153.0400 | 0.2500 | ["150"] | ["0.5512"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 10 | 38 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:10:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |