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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b606-d1e8-7353-bd42-0e0e99da453f | SPX | 2026-09-18 15:38 | straddle | 2 | 1 | 112 | 4659200.00 | long | ask | 7640.0500 | 1.4000 | ["7710"] | ["0.1368"] | ["7294","8126.00"] | ["XCBO"] | 7710.0000 | 7710.0000 | 91 | 91 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:38:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ca-26a7-7792-bc1b-e1d8daca0ab2 | SPX | 2026-09-18 14:31 | straddle | 2 | 2 | 20 | 836000.00 | long | ask | 7632.8700 | 1.6000 | ["7700"] | ["0.1376"] | ["7282","8118.00"] | ["XCBO"] | 7700.0000 | 7700.0000 | 91 | 91 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:32:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59e-211f-70e1-bec4-d4511c3039ea | SPX | 2026-09-18 13:43 | straddle | 2 | 1 | 25 | 184525.00 | long | ask | 7626.8700 | 0.7500 | ["7700"] | ["0.2923"] | ["7626.19","7773.81"] | ["XCBO"] | 7700.0000 | 7700.0000 | 0 | 0 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:44:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ea-6180-7901-8c0b-8303842fee39 | SPX | 2026-09-18 10:27 | straddle | 2 | 1 | 39 | 1649700.00 | long | ask | 7622.8800 | 1.3000 | ["7690"] | ["0.1394"] | ["7267","8113.00"] | ["XCBO"] | 7690.0000 | 7690.0000 | 91 | 91 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:27:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0c9-fc43-7133-bfb4-af1380d1d944 | SPX | 2026-09-17 15:13 | straddle | 2 | 1 | 11 | 465300.00 | long | ask | 7639.2800 | 1.5000 | ["7710"] | ["0.1383"] | ["7287","8133.00"] | ["XCBO"] | 7710.0000 | 7710.0000 | 92 | 92 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:14:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abd8-cd8b-7371-bfda-1c0d1f9066c3 | SPX | 2026-09-16 16:11 | straddle | 2 | 2 | 75 | 3367500.00 | long | ask | 7551.8100 | 2.3000 | ["7620"] | ["0.1477"] | ["7171","8069.00"] | ["XCBO"] | 7620.0000 | 7620.0000 | 93 | 93 | false | false | false | false | true | 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 |
| 01a0ab2e-1a53-7113-9515-90456abbbd1c | SPX | 2026-09-16 13:05 | straddle | 2 | 1 | 126 | 5537700.00 | long | ask | 7605.5400 | 1.5000 | ["7680"] | ["0.1436"] | ["7240.50","8119.50"] | ["XCBO"] | 7680.0000 | 7680.0000 | 93 | 93 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:05:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab03-1a83-78a3-93ac-0c85f26c00ef | SPX | 2026-09-16 12:18 | straddle | 2 | 2 | 192 | 8428800.00 | long | ask | 7615.3700 | 1.6000 | ["7685"] | ["0.1432"] | ["7246","8124.00"] | ["XCBO"] | 7685.0000 | 7685.0000 | 93 | 93 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:18:49Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf0-b77a-7b01-8510-a25d3f980bd4 | SPX | 2026-09-16 11:58 | straddle | 2 | 1 | 250 | 2410250.00 | long | ask | 7619.2000 | 2.3000 | ["7700"] | ["0.1537"] | ["7603.59","7796.41"] | ["XCBO"] | 7700.0000 | 7700.0000 | 2 | 2 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:58:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a653-60c6-77c3-af4a-56e001758c7e | SPX | 2026-09-15 14:27 | straddle | 2 | 1 | 6 | 267600.00 | long | ask | 7585.3300 | 1.5000 | ["7655"] | ["0.1453"] | ["7209","8101.00"] | ["XCBO"] | 7655.0000 | 7655.0000 | 94 | 94 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:28:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a045-d5f8-71b0-a8fd-58017f11919a | SPX | 2026-09-14 10:15 | straddle | 2 | 1 | 2 | 90110.00 | long | ask | 7619.3100 | 1.9000 | ["7685"] | ["0.1454"] | ["7234.45","8135.55"] | ["XCBO"] | 7685.0000 | 7685.0000 | 95 | 95 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:15:33Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a020-a288-7d63-8694-c6292cca5d99 | SPX | 2026-09-14 09:34 | straddle | 2 | 1 | 4 | 182400.00 | long | ask | 7600.2700 | 2.7000 | ["7670"] | ["0.1475"] | ["7214","8126.00"] | ["XCBO"] | 7670.0000 | 7670.0000 | 95 | 95 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:34:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09215-aa08-7a73-8318-f6ca322a1975 | SPX | 2026-09-11 16:08 | straddle | 2 | 1 | 42 | 411600.00 | long | ask | 7656.9800 | 1.6000 | ["7660"] | ["0.1158"] | ["7562","7758.00"] | ["XCBO"] | 7660.0000 | 7660.0000 | 7 | 7 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T20:09:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091fc-3e38-74b1-bd9b-7d874d451bbe | SPX | 2026-09-11 15:40 | straddle | 2 | 1 | 125 | 164000.00 | long | ask | 7662.8000 | 0.2500 | ["7650"] | ["0.1558"] | ["7636.88","7663.12"] | ["XCBO"] | 7650.0000 | 7650.0000 | 0 | 0 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:40:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f3-9760-77c1-81af-3dbfb663c98e | SPX | 2026-09-11 15:30 | straddle | 2 | 1 | 40 | 380000.00 | long | ask | 7664.3500 | 1.0000 | ["7670"] | ["0.1122"] | ["7575","7765.00"] | ["XCBO"] | 7670.0000 | 7670.0000 | 7 | 7 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:31:06Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ea-6bb8-7491-85dc-655b626a6ae7 | SPX | 2026-09-11 15:20 | straddle | 2 | 1 | 40 | 384440.00 | long | ask | 7663.5000 | 1.1000 | ["7665"] | ["0.1135"] | ["7568.89","7761.11"] | ["XCBO"] | 7665.0000 | 7665.0000 | 7 | 7 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:21:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc6-07a0-79c1-b4e8-ff0e762edced | SPX | 2026-09-10 15:23 | straddle | 2 | 2 | 4 | 54400.00 | long | ask | 7588.2800 | 1.3000 | ["7595"] | ["0.1517"] | ["7459","7731.00"] | ["XCBO"] | 7595.0000 | 7595.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:23:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0870d-6a39-72d1-8d4e-897c296190da | SPX | 2026-09-09 12:43 | straddle | 2 | 3 | 230 | 2898000.00 | long | ask | 7636.1800 | 1.2000 | ["7640"] | ["0.1317"] | ["7514","7766.00"] | ["XCBO"] | 7640.0000 | 7640.0000 | 9 | 9 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:44:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08232-05a0-7800-91df-a331e5452f79 | SPX | 2026-09-08 14:05 | straddle | 2 | 2 | 24 | 285600.00 | long | ask | 7691.5100 | 1.0000 | ["7695"] | ["0.1171"] | ["7576","7814.00"] | ["XCBO"] | 7695.0000 | 7695.0000 | 10 | 10 | false | false | false | false | true | 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-a32fda481cbf | SPX | 2026-09-08 14:05 | straddle | 2 | 2 | 100 | 1190000.00 | long | ask | 7691.5100 | 1.0000 | ["7695"] | ["0.1171"] | ["7576","7814.00"] | ["XCBO"] | 7695.0000 | 7695.0000 | 10 | 10 | false | false | false | false | true | 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 |
| 01a081ad-b2a0-7f82-833f-952f4eeebddc | SPX | 2026-09-08 11:40 | straddle | 2 | 3 | 115 | 1397250.00 | long | ask | 7689.8000 | 1.1000 | ["7695"] | ["0.1196"] | ["7573.50","7816.50"] | ["XCBO"] | 7695.0000 | 7695.0000 | 10 | 10 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:40:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ac-7e08-7741-84b7-909134860f6b | SPX | 2026-09-08 11:39 | straddle | 2 | 3 | 200 | 2430000.00 | long | ask | 7690.0600 | 1.2000 | ["7695"] | ["0.1196"] | ["7573.50","7816.50"] | ["XCBO"] | 7695.0000 | 7695.0000 | 10 | 10 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:39:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d99-1305-7e42-8280-75ab203f7d9e | SPX | 2026-09-04 14:05 | straddle | 2 | 1 | 5 | 63300.00 | long | ask | 7708.5100 | 0.9000 | ["7715"] | ["0.1051"] | ["7588.40","7841.60"] | ["XCBO"] | 7715.0000 | 7715.0000 | 14 | 14 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:06:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d75-79bd-7e20-a1be-75d00ad81da9 | SPX | 2026-09-04 13:26 | straddle | 2 | 1 | 75 | 144375.00 | long | ask | 7716.6200 | 0.2500 | ["7700"] | ["0.1231"] | ["7680.75","7719.25"] | ["XCBO"] | 7700.0000 | 7700.0000 | 0 | 0 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:27:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d75-79bd-7e20-a1be-754bace4b4be | SPX | 2026-09-04 13:26 | straddle | 2 | 1 | 75 | 968250.00 | long | ask | 7716.6200 | 1.2000 | ["7700"] | ["0.1056"] | ["7570.90","7829.10"] | ["XCBO"] | 7700.0000 | 7700.0000 | 14 | 14 | false | false | false | false | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:27:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |