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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61d-3c2f-7783-a988-2dc71afe4762 | SPX | 2026-09-18 16:02 | call_vertical_spread | 2 | 1 | 20 | 101520.00 | unknown | bid | 7650.1600 | 0.6000 | ["7625","7660"] | ["0.0717","0.0634"] | ["7667.88"] | ["XCBO"] | 7625.0000 | 7660.0000 | 3 | 3 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:02:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a693-8e76-73a3-a7ca-ae02b1c3e9ae | SPX | 2026-09-15 15:38 | call_vertical_spread | 2 | 2 | 750 | 270000.00 | long | ask | 7579.3900 | 0.2500 | ["7775","7800"] | ["0.1085","0.1055"] | ["7776.20"] | ["XCBO"] | 7775.0000 | 7800.0000 | 7 | 7 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:38:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a4-5ffe-7303-951e-232e9f5e5c98 | SPX | 2026-09-15 11:16 | call_vertical_spread | 2 | 1 | 15 | 136380.00 | unknown | — | 7581.9400 | 0.4000 | ["7590","7600"] | ["0.1856","0.1828"] | [] | ["XCBO"] | 7590.0000 | 7600.0000 | 3 | 3 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:17:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09203-1439-7ac2-830a-8c536f780a82 | SPX | 2026-09-11 15:47 | call_vertical_spread | 2 | 1 | 100 | 785000.00 | short | bid | 7661.8500 | 0.6000 | ["7700","7850"] | ["0.1090","0.0945"] | ["7752.30"] | ["XCBO"] | 7700.0000 | 7850.0000 | 19 | 19 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:48:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a5-40b0-74a0-9228-8ef66fd68bb5 | SPX | 2026-09-11 14:05 | call_vertical_spread | 2 | 4 | 500 | 150000.00 | unknown | — | 7671.6700 | 0.2000 | ["7750","7775"] | ["0.0683","0.0688"] | [] | ["XCBO"] | 7750.0000 | 7775.0000 | 4 | 4 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:05:59Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090f0-d148-7c11-abb3-4216c55b0768 | SPX | 2026-09-11 10:48 | call_vertical_spread | 2 | 2 | 275 | 842325.00 | unknown | — | 7651.5300 | 0.6000 | ["7850","8000"] | ["0.1051","0.0994"] | [] | ["XCBO"] | 7850.0000 | 8000.0000 | 26 | 26 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:48:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce6-93a8-7ea2-baf5-b88f625a95fd | SPX | 2026-09-10 15:58 | call_vertical_spread | 2 | 4 | 500 | 139500.00 | unknown | — | 7592.5900 | 0.2000 | ["7750","7775"] | ["0.1032","0.1020"] | [] | ["XCBO"] | 7750.0000 | 7775.0000 | 5 | 5 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:58:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c8e-9c20-7cf0-ac61-3ed967ac9bc3 | SPX | 2026-09-10 14:22 | call_vertical_spread | 2 | 1 | 35 | 84840.00 | unknown | — | 7593.2000 | 0.6000 | ["7775","7835"] | ["0.1162","0.1103"] | [] | ["XCBO"] | 7775.0000 | 7835.0000 | 15 | 15 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:22:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c6d-3d28-71b3-88fe-3aeb66cff7c6 | SPX | 2026-09-10 13:46 | call_vertical_spread | 2 | 1 | 35 | 63875.00 | unknown | — | 7596.7700 | 0.6000 | ["7775","7800"] | ["0.1114","0.1088"] | [] | ["XCBO"] | 7775.0000 | 7800.0000 | 12 | 12 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:46:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c60-5090-7cb2-a787-896d63d35b31 | SPX | 2026-09-10 13:31 | call_vertical_spread | 2 | 1 | 30 | 41730.00 | unknown | — | 7598.4500 | 0.6000 | ["7775","7815"] | ["0.1101","0.1067"] | [] | ["XCBO"] | 7775.0000 | 7815.0000 | 11 | 11 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:32:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c41-6a68-7683-9bf4-ee3e374f0b67 | SPX | 2026-09-10 12:58 | call_vertical_spread | 2 | 1 | 30 | 80160.00 | unknown | — | 7604.0700 | 0.5000 | ["7735","7750"] | ["0.1254","0.1232"] | [] | ["XCBO"] | 7735.0000 | 7750.0000 | 8 | 8 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:58:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c21-3450-7033-b800-39601a508b1c | SPX | 2026-09-10 12:22 | call_vertical_spread | 2 | 1 | 180 | 135000.00 | unknown | — | 7595.0000 | 0.3000 | ["7675","7700"] | ["0.1829","0.1788"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 1 | 1 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:23:09Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0825d-c8c0-7842-8ad8-00bac332da05 | SPX | 2026-09-08 14:52 | call_vertical_spread | 2 | 1 | 50 | 173600.00 | unknown | — | 7678.0500 | 0.5000 | ["7850","7950"] | ["0.1063","0.1013"] | [] | ["XCBO"] | 7850.0000 | 7950.0000 | 22 | 22 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:52:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08232-05a0-7800-91df-a2f9da0d0020 | SPX | 2026-09-08 14:05 | call_vertical_spread | 2 | 2 | 608 | 796480.00 | unknown | — | 7691.5100 | 0.5000 | ["7950","8000"] | ["0.0967","0.0961"] | [] | ["XCBO"] | 7950.0000 | 8000.0000 | 22 | 22 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:05:26Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08232-05a0-7800-91df-a2df08b6cb38 | SPX | 2026-09-08 14:05 | call_vertical_spread | 2 | 2 | 2500 | 3275000.00 | unknown | — | 7691.5100 | 0.5000 | ["7950","8000"] | ["0.0967","0.0961"] | [] | ["XCBO"] | 7950.0000 | 8000.0000 | 22 | 22 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:05:26Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0821a-ad10-75e1-8b25-f1a1c9779b0d | SPX | 2026-09-08 13:39 | call_vertical_spread | 2 | 1 | 200 | 272000.00 | short | bid | 7693.1900 | 0.4000 | ["7950","8000"] | ["0.0970","0.0965"] | ["7953.98"] | ["XCBO"] | 7950.0000 | 8000.0000 | 22 | 22 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:40:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |