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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60c-6f67-7242-8f61-62a9afcbefff | SPX | 2026-09-18 15:44 | put_ratio_spread | 2 | 1 | 25 | 37050.00 | unknown | ask | 7643.7100 | 0.4000 | ["7200","7325"] | ["0.1915","0.1671"] | ["7310.18"] | ["XCBO"] | 7200.0000 | 7325.0000 | 14 | 14 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:44:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b604-4978-7601-82b1-b194220ef267 | SPX | 2026-09-18 15:35 | put_ratio_spread | 2 | 1 | 587 | 3129488.00 | unknown | bid | 7637.3500 | 1.2000 | ["6850","7710"] | ["0.2157","0.1408"] | ["6801.33"] | ["XCBO"] | 6850.0000 | 7710.0000 | 91 | 91 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:35:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fd-dcef-7ac3-8ff5-d01fc873f919 | SPX | 2026-09-18 15:28 | put_ratio_spread | 2 | 1 | 80 | 372520.00 | unknown | ask | 7640.1600 | 1.0000 | ["6675","7710"] | ["0.2325","0.1411"] | ["6654.81"] | ["XCBO"] | 6675.0000 | 7710.0000 | 91 | 91 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:28:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5dd-358f-7362-b94b-31737891a990 | SPX | 2026-09-18 14:52 | put_ratio_spread | 2 | 2 | 1975 | 10979450.00 | unknown | ask | 7642.9000 | 0.5000 | ["7350","7400"] | ["0.1642","0.1575"] | ["7333.80"] | ["XCBO"] | 7350.0000 | 7400.0000 | 28 | 28 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:52:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5cd-62c7-7282-b9ad-f5295f199555 | SPX | 2026-09-18 14:35 | put_ratio_spread | 2 | 1 | 400 | 412400.00 | unknown | ask | 7634.6400 | 0.4500 | ["7160","7425"] | ["0.2010","0.1497"] | ["7383.76"] | ["XCBO"] | 7160.0000 | 7425.0000 | 14 | 14 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:35:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c7-ffdf-7521-8202-613998ae1c8d | SPX | 2026-09-18 14:29 | put_ratio_spread | 2 | 1 | 200 | 255000.00 | unknown | ask | 7634.3500 | 0.4000 | ["7400","7600"] | ["0.1579","0.1125"] | ["7549"] | ["XCBO"] | 7400.0000 | 7600.0000 | 7 | 7 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:29:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b9-7537-7e43-ad39-cf2906d2f13e | SPX | 2026-09-18 14:13 | put_ratio_spread | 2 | 3 | 1110 | 8448050.00 | unknown | — | 7628.6600 | 1.1000 | ["6745","7355"] | ["0.2222","0.1692"] | [] | ["XCBO"] | 6745.0000 | 7355.0000 | 104 | 104 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:13:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a2-ebaf-7ad0-b1b2-0c42e84f6b2f | SPX | 2026-09-18 13:49 | put_ratio_spread | 2 | 2 | 479 | 705751.00 | unknown | bid | 7627.2400 | 0.4000 | ["7150","7325"] | ["0.2032","0.1680"] | ["7305.34"] | ["XCBO"] | 7150.0000 | 7325.0000 | 14 | 14 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:49:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55d-9997-7122-87b8-57ea70c33ec0 | SPX | 2026-09-18 12:33 | put_ratio_spread | 2 | 1 | 150 | 378000.00 | unknown | ask | 7620.1100 | 0.4000 | ["7475","7560"] | ["0.1433","0.1247"] | ["7509.60"] | ["XCBO"] | 7475.0000 | 7560.0000 | 7 | 7 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:33:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0fc-b0bb-7922-9ca7-cbd34bc71001 | SPX | 2026-09-17 16:09 | put_ratio_spread | 2 | 1 | 250 | 64700.00 | unknown | — | 7637.7600 | 0.2000 | ["7400","7500"] | ["0.1659","0.1347"] | [] | ["XCBO"] | 7400.0000 | 7500.0000 | 4 | 4 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T20:10:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ec-265a-7b22-bfd6-4aff53b66475 | SPX | 2026-09-17 15:50 | put_ratio_spread | 2 | 4 | 888 | 277940.00 | unknown | — | 7642.6600 | 0.2000 | ["7350","7425"] | ["0.1877","0.1621"] | [] | ["XCBO"] | 7350.0000 | 7425.0000 | 4 | 4 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:51:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d8-63c3-7133-9a7a-1e67cea7c762 | SPX | 2026-09-17 15:29 | put_ratio_spread | 2 | 2 | 40 | 422060.00 | unknown | — | 7637.2700 | 0.5000 | ["7050","7625"] | ["0.2084","0.1272"] | [] | ["XCBO"] | 7050.0000 | 7625.0000 | 29 | 29 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:29:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cd-4803-7c73-baac-0fa4fd5e2b1e | SPX | 2026-09-17 15:17 | put_ratio_spread | 2 | 1 | 300 | 123300.00 | unknown | — | 7639.0800 | 0.2000 | ["7500","7580"] | ["0.2183","0.1657"] | [] | ["XCBO"] | 7500.0000 | 7580.0000 | 1 | 1 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:17:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c6-1443-7190-a88e-e538a07dd484 | SPX | 2026-09-17 15:09 | put_ratio_spread | 2 | 2 | 1200 | 493200.00 | unknown | — | 7639.8800 | 0.1500 | ["7500","7580"] | ["0.2193","0.1671"] | [] | ["XCBO"] | 7500.0000 | 7580.0000 | 1 | 1 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:09:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c0-72db-7b31-82ce-1f4022721f88 | SPX | 2026-09-17 15:03 | put_ratio_spread | 2 | 1 | 270 | 774900.00 | unknown | — | 7639.0100 | 0.3500 | ["7500","7650"] | ["0.2194","0.1409"] | [] | ["XCBO"] | 7500.0000 | 7650.0000 | 1 | 1 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:03:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b037-af23-72e0-8481-5c259bc5b9ae | SPX | 2026-09-17 12:33 | put_ratio_spread | 2 | 2 | 500 | 8727500.00 | unknown | — | 7632.0700 | 0.9000 | ["7000","7600"] | ["0.2039","0.1511"] | [] | ["XCBO"] | 7000.0000 | 7600.0000 | 92 | 92 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:34:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afeb-1d93-7d70-91ea-06f3c9201b0c | SPX | 2026-09-17 11:10 | put_ratio_spread | 2 | 2 | 1600 | 1414000.00 | unknown | — | 7618.4500 | 0.3000 | ["7150","7500"] | ["0.2358","0.1498"] | [] | ["XCBO"] | 7150.0000 | 7500.0000 | 8 | 8 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:10:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afda-f4db-71a1-b2cf-e46f1bcdd2e7 | SPX | 2026-09-17 10:52 | put_ratio_spread | 2 | 3 | 1200 | 2045900.00 | unknown | — | 7621.8900 | 0.5000 | ["6000","7000"] | ["0.3466","0.2100"] | [] | ["XCBO"] | 6000.0000 | 7000.0000 | 43 | 43 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:52:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcf-7f42-79d3-99fb-91542bdbc099 | SPX | 2026-09-17 10:40 | put_ratio_spread | 2 | 1 | 800 | 550200.00 | unknown | — | 7627.9100 | 0.2000 | ["7450","7600"] | ["0.2570","0.1634"] | [] | ["XCBO"] | 7450.0000 | 7600.0000 | 1 | 1 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:40:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abd7-eee3-7312-92ff-60458b94dff0 | SPX | 2026-09-16 16:10 | put_ratio_spread | 2 | 3 | 1000 | 4300000.00 | unknown | — | 7551.8100 | 0.8000 | ["7300","7450"] | ["0.2002","0.1688"] | [] | ["XCBO"] | 7300.0000 | 7450.0000 | 9 | 9 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T20:12:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abd6-54bb-7c90-9d5a-d8d5692f998d | SPX | 2026-09-16 16:09 | put_ratio_spread | 2 | 4 | 3000 | 12795000.00 | unknown | — | 7551.8100 | 0.7000 | ["7300","7450"] | ["0.1994","0.1683"] | [] | ["XCBO"] | 7300.0000 | 7450.0000 | 9 | 9 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T20:09:55Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb9-52f2-7dd3-b900-34460a526b3a | SPX | 2026-09-16 15:37 | put_ratio_spread | 2 | 1 | 300 | 1847200.00 | unknown | — | 7527.4800 | 0.7000 | ["7350","7500"] | ["0.1870","0.1533"] | [] | ["XCBO"] | 7350.0000 | 7500.0000 | 9 | 9 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:37:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab61-ccb3-70a3-ac94-bcc18cf1064e | SPX | 2026-09-16 14:01 | put_ratio_spread | 2 | 1 | 320 | 1519440.00 | unknown | — | 7602.5600 | 4.7000 | ["6500","7600"] | ["0.2741","0.1370"] | [] | ["XCBO"] | 6500.0000 | 7600.0000 | 48 | 48 | true | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:01:49Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab2f-52d3-7ce1-9bd8-0931a4cf7702 | SPX | 2026-09-16 13:06 | put_ratio_spread | 2 | 1 | 75 | 234000.00 | unknown | — | 7605.5600 | 1.2000 | ["6100","7680"] | ["0.2929","0.1474"] | [] | ["XCBO"] | 6100.0000 | 7680.0000 | 93 | 93 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:06:44Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab2b-5363-7d63-b99f-4f659573f1a7 | SPX | 2026-09-16 13:02 | put_ratio_spread | 2 | 1 | 60 | 194180.00 | unknown | — | 7605.4200 | 1.1000 | ["6100","7680"] | ["0.2923","0.1460"] | [] | ["XCBO"] | 6100.0000 | 7680.0000 | 93 | 93 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:02:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab2b-5363-7d63-b99f-4f58bd4839af | SPX | 2026-09-16 13:02 | put_ratio_spread | 2 | 1 | 120 | 366360.00 | unknown | — | 7605.4200 | 1.1000 | ["6100","7680"] | ["0.2923","0.1460"] | [] | ["XCBO"] | 6100.0000 | 7680.0000 | 93 | 93 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:02:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac0-f8d3-7341-9bb7-fe0121727735 | SPX | 2026-09-16 11:06 | put_ratio_spread | 2 | 3 | 750 | 2602250.00 | unknown | — | 7615.0200 | 0.5000 | ["7300","7500"] | ["0.2098","0.1669"] | [] | ["XCBO"] | 7300.0000 | 7500.0000 | 9 | 9 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:06:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a8-bc56-7db1-8591-b9ab41beeb87 | SPX | 2026-09-15 16:01 | put_ratio_spread | 2 | 1 | 99 | 67848.00 | unknown | — | 7585.6800 | 0.2000 | ["7450","7500"] | ["0.2279","0.2119"] | [] | ["XCBO"] | 7450.0000 | 7500.0000 | 1 | 1 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T20:02:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a696-f976-74f2-a4ba-a872258fc589 | SPX | 2026-09-15 15:41 | put_ratio_spread | 2 | 1 | 75 | 305500.00 | unknown | — | 7578.4700 | 0.6000 | ["7150","7375"] | ["0.2174","0.1765"] | [] | ["XCBO"] | 7150.0000 | 7375.0000 | 17 | 17 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:42:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a68a-10c6-7300-a371-199c5ad56c2c | SPX | 2026-09-15 15:27 | put_ratio_spread | 2 | 2 | 250 | 1436800.00 | unknown | — | 7582.1300 | 0.5000 | ["7300","7500"] | ["0.2046","0.1621"] | [] | ["XCBO"] | 7300.0000 | 7500.0000 | 10 | 10 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:27:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a667-0bee-7213-8549-f75157fc3f49 | SPX | 2026-09-15 14:49 | put_ratio_spread | 2 | 1 | 136 | 484800.00 | unknown | — | 7579.4500 | 1.2000 | ["6300","7655"] | ["0.2731","0.1482"] | [] | ["XCBO"] | 6300.0000 | 7655.0000 | 94 | 94 | false | false | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:49:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ed-5f7e-7a52-9f0f-a0ef2a53756c | SPX | 2026-09-15 12:36 | put_ratio_spread | 2 | 2 | 150 | 1378300.00 | unknown | — | 7588.1600 | 1.2000 | ["6850","7250"] | ["0.2327","0.1854"] | [] | ["XCBO"] | 6850.0000 | 7250.0000 | 52 | 52 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:36:48Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b1-c5ae-7ce1-97dc-334efe72ecc0 | SPX | 2026-09-15 11:31 | put_ratio_spread | 2 | 2 | 225 | 990000.00 | unknown | — | 7584.8100 | 0.8000 | ["6700","7550"] | ["0.2851","0.1463"] | [] | ["XCBO"] | 6700.0000 | 7550.0000 | 24 | 24 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:31:59Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a5-3ea6-7001-9c60-41e653dbe7d6 | SPX | 2026-09-15 11:17 | put_ratio_spread | 2 | 3 | 2250 | 4361250.00 | unknown | — | 7583.1300 | 0.4000 | ["7100","7450"] | ["0.2561","0.1786"] | [] | ["XCBO"] | 7100.0000 | 7450.0000 | 10 | 10 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:18:04Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |