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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4e1-418f-7c72-84a3-bfefdc1cd65b | SPX | 2026-09-18 10:17 | strangle | 2 | 1 | 4 | 45940.00 | short | bid | 7620.5600 | 0.6000 | ["7530","7640"] | ["0.2042","0.1575"] | ["7525.15","7644.85"] | ["XCBO"] | 7530.0000 | 7640.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:17:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ca-565f-79b2-b800-c86491542d10 | SPX | 2026-09-18 09:52 | strangle | 2 | 1 | 5 | 452075.00 | short | bid | 7634.4800 | 34.1000 | ["7200","8100"] | ["0.1350","0.1878"] | ["7195.85","8104.15"] | ["XCBO"] | 7200.0000 | 8100.0000 | 12 | 12 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:52:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0e5-c973-7ca3-b885-f2a6fac8cf3a | SPX | 2026-09-17 15:44 | strangle | 2 | 1 | 2 | 27610.00 | long | ask | 7641.2700 | 13.4000 | ["7535","7540"] | ["0.1270","0.1311"] | ["7401.95","7673.05"] | ["XCBO"] | 7535.0000 | 7540.0000 | 6 | 6 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:44:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e3-642b-74e3-9980-c5f0dde9b364 | SPX | 2026-09-17 15:41 | strangle | 2 | 1 | 6 | 239200.00 | short | bid | 7640.5800 | 1.8000 | ["7250","7950"] | ["0.1837","0.1345"] | ["6851.33","8348.67"] | ["XCBO"] | 7250.0000 | 7950.0000 | 183 | 183 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:41:49Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e3-0e3b-7503-9e68-e695f0c7b4cb | SPX | 2026-09-17 15:41 | strangle | 2 | 1 | 2 | 40780.00 | long | ask | 7640.3100 | 4.1000 | ["7550","7750"] | ["0.1991","0.1235"] | ["7546.10","7753.90"] | ["XCBO"] | 7550.0000 | 7750.0000 | 1 | 1 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:41:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b086-dcab-7fd0-ae0f-b279a18983fe | SPX | 2026-09-17 14:00 | strangle | 2 | 1 | 2 | 58034.00 | unknown | — | 7637.5200 | 1.8000 | ["7600","7750"] | ["0.1283","0.1118"] | [] | ["XCBO"] | 7600.0000 | 7750.0000 | 29 | 29 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:01:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd2-6d43-7d31-a3c8-b4448a641528 | SPX | 2026-09-17 10:43 | strangle | 2 | 1 | 5 | 42675.00 | long | ask | 7631.8900 | 0.7000 | ["7450","7825"] | ["0.1520","0.1102"] | ["7364.65","7910.35"] | ["XCBO"] | 7450.0000 | 7825.0000 | 29 | 29 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:43:20Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd1-57eb-7220-bf4f-5044525f07cd | SPX | 2026-09-17 10:42 | strangle | 2 | 1 | 10 | 85300.00 | long | ask | 7632.5100 | 0.8000 | ["7450","7825"] | ["0.1521","0.1101"] | ["7364.70","7910.30"] | ["XCBO"] | 7450.0000 | 7825.0000 | 29 | 29 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:42:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa8-4063-7233-ac8f-175f5c615271 | SPX | 2026-09-17 09:57 | strangle | 2 | 1 | 5 | 148425.00 | short | bid | 7619.9000 | 1.0000 | ["7575","7720"] | ["0.1347","0.1184"] | ["7423.15","7871.85"] | ["XCBO"] | 7575.0000 | 7720.0000 | 29 | 29 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:57:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af92-531b-70a3-bbad-047ce79ee591 | SPX | 2026-09-17 09:33 | strangle | 2 | 1 | 2 | 40180.00 | short | bid | 7634.1900 | 2.4000 | ["7540","7740"] | [null,"0.3135"] | ["7539.10","7740.90"] | ["XCBO"] | 7540.0000 | 7740.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:33:20Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0abd1-8e13-7b50-97bf-4c115d10758f | SPX | 2026-09-16 16:03 | strangle | 2 | 1 | 2 | 25580.00 | long | ask | 7552.1600 | 1.4000 | ["7550","7555"] | ["0.1432","0.1490"] | ["7422.10","7682.90"] | ["XCBO"] | 7550.0000 | 7555.0000 | 8 | 8 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T20:04:41Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abc8-df6b-76f1-8f4b-2b3044c56461 | SPX | 2026-09-16 15:54 | strangle | 2 | 1 | 10 | 61000.00 | short | bid | 7548.8100 | 0.6000 | ["7500","7520"] | ["0.2027","0.1968"] | ["7439","7581.00"] | ["XCBO"] | 7500.0000 | 7520.0000 | 1 | 1 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:54:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab7e-229b-7250-86c3-c50988861fe2 | SPX | 2026-09-16 14:32 | strangle | 2 | 1 | 10 | 39850.00 | long | ask | 7592.2400 | 1.4000 | ["7100","7900"] | ["0.2082","0.1082"] | ["7060.15","7939.85"] | ["XCBO"] | 7100.0000 | 7900.0000 | 30 | 30 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:32:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5b-bdeb-7450-8fff-a51f96ad7505 | SPX | 2026-09-16 13:55 | strangle | 2 | 1 | 10 | 33300.00 | short | bid | 7608.2400 | 0.3000 | ["7590","7625"] | ["0.5289","0.5146"] | ["7556.70","7658.30"] | ["XCBO"] | 7590.0000 | 7625.0000 | 0 | 0 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:55:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab33-fe22-7381-aa5d-f282480025c3 | SPX | 2026-09-16 13:11 | strangle | 2 | 1 | 3 | 37515.00 | long | ask | 7606.4500 | 0.7000 | ["7605","7610"] | ["0.1429","0.1409"] | ["7479.95","7735.05"] | ["XCBO"] | 7605.0000 | 7610.0000 | 8 | 8 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:12:21Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf3-9dab-74e3-bf5c-e9edef02781f | SPX | 2026-09-16 12:01 | strangle | 2 | 1 | 3 | 37200.00 | long | ask | 7617.9600 | 0.8000 | ["7615","7620"] | ["0.1410","0.1400"] | ["7491","7744.00"] | ["XCBO"] | 7615.0000 | 7620.0000 | 8 | 8 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:01:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aada-688a-7212-8f3c-58b44a1c0d69 | SPX | 2026-09-16 11:33 | strangle | 2 | 1 | 4 | 124170.00 | long | ask | 7611.8300 | 1.0000 | ["7575","7720"] | ["0.1417","0.1232"] | ["7409.58","7885.42"] | ["XCBO"] | 7575.0000 | 7720.0000 | 30 | 30 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:34:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6b2-12f6-76a2-9e47-bcd598573557 | SPX | 2026-09-15 16:11 | strangle | 2 | 1 | 3 | 134615.00 | long | ask | 7585.7300 | 2.7000 | ["7150","8500"] | ["0.1967","0.1375"] | ["6701.28","8948.72"] | ["XCBO"] | 7150.0000 | 8500.0000 | 339 | 339 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T20:11:38Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a699-b0c6-7063-887f-6b77ecafed88 | SPX | 2026-09-15 15:44 | strangle | 2 | 1 | 10 | 57250.00 | long | ask | 7579.1200 | 0.6000 | ["7530","7790"] | ["0.1559","0.1111"] | ["7472.75","7847.25"] | ["XCBO"] | 7530.0000 | 7790.0000 | 10 | 10 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:45:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a16f-fe19-7921-8f69-12e6a0bb8229 | SPX | 2026-09-14 15:41 | strangle | 2 | 1 | 6 | 29820.00 | unknown | — | 7629.5100 | 0.4000 | ["7575","7725"] | ["0.1431","0.1104"] | [] | ["XCBO"] | 7575.0000 | 7725.0000 | 7 | 7 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:41:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a131-1c70-7a60-9c28-339b04bba28b | SPX | 2026-09-14 14:32 | strangle | 2 | 1 | 5 | 53175.00 | short | bid | 7633.5200 | 1.2000 | ["7475","7825"] | ["0.1559","0.1126"] | ["7368.65","7931.35"] | ["XCBO"] | 7475.0000 | 7825.0000 | 32 | 32 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:32:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d3-a6a8-7cb0-a66d-0365b4f97c4f | SPX | 2026-09-14 12:50 | strangle | 2 | 1 | 7 | 45248.00 | long | ask | 7645.0400 | 0.6000 | ["7600","7700"] | ["0.1394","0.1146"] | ["7535.36","7764.64"] | ["XCBO"] | 7600.0000 | 7700.0000 | 7 | 7 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:50:26Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090f4-bd30-7542-b0a0-8fe34740913d | SPX | 2026-09-11 10:52 | strangle | 2 | 1 | 9 | 525435.00 | short | bid | 7658.3800 | 2.4000 | ["7750","7900"] | ["0.1576","0.1405"] | ["7166.18","8483.82"] | ["XCBO"] | 7750.0000 | 7900.0000 | 189 | 189 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:52:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090cf-b8a1-7bd1-84f9-ab207e5b26ff | SPX | 2026-09-11 10:12 | strangle | 2 | 1 | 4 | 46960.00 | long | ask | 7665.2800 | 0.8000 | ["7590","7705"] | ["0.2165","0.1642"] | ["7587.60","7707.40"] | ["XCBO"] | 7590.0000 | 7705.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:12:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce2-03b0-7fb1-8a43-dcdf93faf7aa | SPX | 2026-09-10 15:53 | strangle | 2 | 1 | 2 | 39990.00 | short | bid | 7590.8400 | 7.9000 | ["7535","7735"] | ["1.2438","3.6490"] | [] | ["XCBO"] | 7535.0000 | 7735.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:53:54Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0875e-d9e0-7f03-92de-f159c78494ca | SPX | 2026-09-09 14:12 | strangle | 2 | 1 | 7 | 27650.00 | long | ask | 7640.6100 | 0.3000 | ["7645","7650"] | ["0.1327","0.1284"] | ["7605.50","7689.50"] | ["XCBO"] | 7645.0000 | 7650.0000 | 1 | 1 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:12:56Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08290-0038-78f1-af94-65a7840e929e | SPX | 2026-09-08 15:47 | strangle | 2 | 1 | 2 | 40000.00 | short | bid | 7680.5100 | 7.9000 | ["7620","7820"] | ["0.8338","1.6287"] | ["7620","7820"] | ["XCBO"] | 7620.0000 | 7820.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:48:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08222-3e90-7aa3-877e-e3e032277e34 | SPX | 2026-09-08 13:47 | strangle | 2 | 1 | 5 | 177675.00 | long | ask | 7690.2300 | 1.8000 | ["7225","7975"] | ["0.1832","0.1356"] | ["6869.65","8330.35"] | ["XCBO"] | 7225.0000 | 7975.0000 | 164 | 164 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08222-2339-73f1-8d93-02ddc304339c | SPX | 2026-09-08 13:47 | strangle | 2 | 1 | 5 | 147625.00 | long | ask | 7690.1600 | 1.5000 | ["7425","8225"] | ["0.1699","0.1272"] | ["7129.75","8520.25"] | ["XCBO"] | 7425.0000 | 8225.0000 | 164 | 164 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0814d-27c9-7fe0-9145-c65da42ddec7 | SPX | 2026-09-08 09:55 | strangle | 2 | 1 | 3 | 75150.00 | unknown | — | 7689.9100 | 1.6000 | ["7500","7750"] | ["0.3599","0.1941"] | [] | ["XCBO"] | 7500.0000 | 7750.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:55:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d4c-1415-7782-83ca-007da67dea93 | SPX | 2026-09-04 12:41 | strangle | 2 | 1 | 4 | 62480.00 | long | ask | 7723.6000 | 12.0000 | ["7630","7775"] | ["0.0633","0.0767"] | ["7618.80","7786.20"] | ["XCBO"] | 7630.0000 | 7775.0000 | 5 | 5 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:49Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d47-3dcd-7713-a584-8f8c3379a8e1 | SPX | 2026-09-04 12:36 | strangle | 2 | 1 | 3 | 46755.00 | short | bid | 7724.8000 | 12.5000 | ["7635","7780"] | ["0.0570","0.0799"] | ["7624.15","7790.85"] | ["XCBO"] | 7635.0000 | 7780.0000 | 5 | 5 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:36:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d24-8afd-7e71-8567-fe3bf8dc84ec | SPX | 2026-09-04 11:58 | strangle | 2 | 1 | 10 | 28290.00 | short | bid | 7714.8000 | 0.8000 | ["7540","7875"] | ["0.1317","0.0912"] | ["7511.71","7903.29"] | ["XCBO"] | 7540.0000 | 7875.0000 | 14 | 14 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:58:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |