Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4a2-2c6f-7a61-b327-d8c3a1ccfce6 | SPX | 2026-09-21 11:42 | straddle | 2 | 1 | 10 | 34975.00 | short | bid | 7733.9500 | 0.4000 | ["7740"] | ["0.1075"] | ["7705.02","7774.98"] | ["XCBO"] | 7740.0000 | 7740.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:42:41Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c49b-6226-7182-bf1b-4f1335356469 | SPX | 2026-09-21 11:35 | straddle | 2 | 1 | 8 | 500530.00 | short | bid | 7729.1600 | 2.1000 | ["7900"] | ["0.1448"] | ["7274.34","8525.66"] | ["XCBO"] | 7900.0000 | 7900.0000 | 179 | 179 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:35:17Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46e-4746-7673-9c6f-ef9755a0c519 | SPX | 2026-09-21 10:45 | straddle | 2 | 1 | 2 | 26000.00 | short | bid | 7718.1100 | 0.8000 | ["7740"] | ["0.1039"] | ["7610","7870.00"] | ["XCBO"] | 7740.0000 | 7740.0000 | 15 | 15 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:46:14Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5e8-5d07-7d73-8448-c6ba00c7f943 | SPX | 2026-09-18 15:04 | straddle | 2 | 1 | 8 | 493810.00 | short | bid | 7643.6200 | 2.4000 | ["8025"] | ["0.1362"] | ["7407.74","8642.26"] | ["XCBO"] | 8025.0000 | 8025.0000 | 182 | 182 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:05:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b550-bc9f-7792-af75-b2749f539505 | SPX | 2026-09-18 12:19 | straddle | 2 | 1 | 7 | 29260.00 | short | bid | 7621.3600 | 0.4000 | ["7620"] | ["0.0756"] | ["7578.20","7661.80"] | ["XCBO"] | 7620.0000 | 7620.0000 | 3 | 3 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:19:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afae-b0d3-7a40-92f2-7aa3c89c0083 | SPX | 2026-09-17 10:04 | straddle | 2 | 1 | 10 | 25050.00 | short | bid | 7617.5100 | 0.2000 | ["7620"] | ["0.1580"] | ["7594.95","7645.05"] | ["XCBO"] | 7620.0000 | 7620.0000 | 0 | 0 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:04:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afad-7c3b-74b3-b915-78b5f94656cd | SPX | 2026-09-17 10:02 | straddle | 2 | 1 | 5 | 26650.00 | unknown | — | 7617.3300 | 0.4000 | ["7620"] | ["0.1675"] | [] | ["XCBO"] | 7620.0000 | 7620.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:02:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab92-a883-7930-abd6-4629e70560f1 | SPX | 2026-09-16 14:55 | straddle | 2 | 1 | 2 | 33328.00 | short | bid | 7563.1400 | 2.8500 | ["7730"] | ["0.1463"] | ["7563.36","7896.64"] | ["XCBO"] | 7730.0000 | 7730.0000 | 2 | 2 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:55:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab13-acb3-7443-a690-5f9475c1326b | SPX | 2026-09-16 12:36 | straddle | 2 | 1 | 5 | 40650.00 | long | ask | 7609.4200 | 0.7000 | ["7610"] | ["0.1809"] | ["7528.70","7691.30"] | ["XCBO"] | 7610.0000 | 7610.0000 | 2 | 2 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:37:06Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac7-78e3-7213-b534-d796f9c69c23 | SPX | 2026-09-16 11:13 | straddle | 2 | 1 | 10 | 135850.00 | long | ask | 7616.3500 | 0.6000 | ["7615"] | ["0.1423"] | ["7479.15","7750.85"] | ["XCBO"] | 7615.0000 | 7615.0000 | 9 | 9 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:13:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac0-125b-7740-be21-81afae6369b2 | SPX | 2026-09-16 11:05 | straddle | 2 | 1 | 2 | 26920.00 | long | ask | 7616.0800 | 0.6000 | ["7615"] | ["0.1410"] | ["7480.40","7749.60"] | ["XCBO"] | 7615.0000 | 7615.0000 | 9 | 9 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:05:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa3-0cab-7350-ae4c-f164f0b0e1bb | SPX | 2026-09-16 10:33 | straddle | 2 | 1 | 10 | 79900.00 | long | ask | 7602.0400 | 0.9000 | ["7605"] | ["0.1779"] | ["7525.10","7684.90"] | ["XCBO"] | 7605.0000 | 7605.0000 | 2 | 2 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:33:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6aa-855d-7d41-b31d-e5a8630b27cb | SPX | 2026-09-15 16:03 | straddle | 2 | 1 | 5 | 229850.00 | short | bid | 7585.7600 | 2.0000 | ["7600"] | ["0.1493"] | ["7140.30","8059.70"] | ["XCBO"] | 7600.0000 | 7600.0000 | 94 | 94 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T20:05:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a68c-f6f6-7420-aa4c-9d9155466b63 | SPX | 2026-09-15 15:30 | straddle | 2 | 1 | 5 | 30985.00 | long | ask | 7581.2900 | 0.4000 | ["7580"] | ["0.1957"] | ["7518.03","7641.97"] | ["XCBO"] | 7580.0000 | 7580.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:31:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0c1-d428-7623-a758-a1c478c46966 | SPX | 2026-09-14 12:30 | straddle | 2 | 1 | 10 | 473010.00 | short | bid | 7633.6900 | 1.8000 | ["7600"] | ["0.1505"] | ["7126.99","8073.01"] | ["XCBO"] | 7600.0000 | 7600.0000 | 95 | 95 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:30:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a04f-b938-7891-b454-fc8bc9cb8a7f | SPX | 2026-09-14 10:26 | straddle | 2 | 2 | 9 | 42300.00 | long | ask | 7598.3700 | 0.6000 | ["7615"] | ["0.1424"] | ["7568","7662.00"] | ["XCBO"] | 7615.0000 | 7615.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:26:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02e-17d8-7311-998b-d33f34db2773 | SPX | 2026-09-14 09:49 | straddle | 2 | 1 | 10 | 49310.00 | long | ask | 7618.8500 | 0.5000 | ["7605"] | ["0.1506"] | ["7555.69","7654.31"] | ["XCBO"] | 7605.0000 | 7605.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:49:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a024-4c08-7f63-9dd6-72ccc3ed503a | SPX | 2026-09-14 09:38 | straddle | 2 | 1 | 10 | 241700.00 | long | ask | 7599.0900 | 2.3000 | ["7660"] | ["0.1335"] | ["7418.30","7901.70"] | ["XCBO"] | 7660.0000 | 7660.0000 | 32 | 32 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:38:53Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0920d-c680-7503-be24-2a5e2c40b00d | SPX | 2026-09-11 15:59 | straddle | 2 | 1 | 5 | 224315.00 | long | ask | 7657.3200 | 1.9000 | ["7700"] | ["0.1417"] | ["7251.37","8148.63"] | ["XCBO"] | 7700.0000 | 7700.0000 | 98 | 98 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:59:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091fa-1b58-7f43-8e15-32d7457a48db | SPX | 2026-09-11 15:38 | straddle | 2 | 1 | 10 | 101750.00 | unknown | — | 7663.2400 | 0.5000 | ["7720"] | ["0.1095"] | [] | ["XCBO"] | 7720.0000 | 7720.0000 | 7 | 7 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:38:09Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f6-0478-74c1-87a6-3f5ccdbd3a8a | SPX | 2026-09-11 15:33 | straddle | 2 | 1 | 5 | 225825.00 | unknown | — | 7663.2600 | 1.7000 | ["7700"] | ["0.1425"] | [] | ["XCBO"] | 7700.0000 | 7700.0000 | 98 | 98 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:33:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b7-0850-75f0-a76e-c888c93dc5c5 | SPX | 2026-09-11 09:45 | straddle | 2 | 1 | 10 | 459200.00 | long | ask | 7667.2300 | 2.1000 | ["7700"] | ["0.1448"] | ["7240.80","8159.20"] | ["XCBO"] | 7700.0000 | 7700.0000 | 98 | 98 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:45:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce1-30c0-7873-880a-ca44acef1e7c | SPX | 2026-09-10 15:52 | straddle | 2 | 1 | 10 | 79990.00 | long | ask | 7591.1900 | 0.5000 | ["7610"] | ["0.1245"] | ["7530.01","7689.99"] | ["XCBO"] | 7610.0000 | 7610.0000 | 4 | 4 | false | false | false | false | true | 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 |
| 01a08cd6-2c70-7b72-954d-d16e49e0784b | SPX | 2026-09-10 15:40 | straddle | 2 | 1 | 6 | 115500.00 | unknown | — | 7593.8300 | 1.0000 | ["7675"] | ["0.1301"] | [] | ["XCBO"] | 7675.0000 | 7675.0000 | 20 | 20 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:40:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c16-89d8-73f0-b149-9a5c482978d0 | SPX | 2026-09-10 12:11 | straddle | 2 | 1 | 5 | 31700.00 | unknown | — | 7592.0800 | 0.6000 | ["7605"] | ["0.1974"] | [] | ["XCBO"] | 7605.0000 | 7605.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:11:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba1-0000-7870-9972-b9f2391630ea | SPX | 2026-09-10 10:02 | straddle | 2 | 1 | 10 | 26900.00 | long | ask | 7587.9800 | 0.3000 | ["7590"] | ["0.1702"] | ["7563.10","7616.90"] | ["XCBO"] | 7590.0000 | 7590.0000 | 0 | 0 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:02:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087b0-41b9-7db3-bf94-1f8f9f5dad11 | SPX | 2026-09-09 15:41 | straddle | 2 | 1 | 2 | 49780.00 | long | ask | 7642.5100 | 1.5000 | ["7715"] | ["0.1267"] | ["7466.10","7963.90"] | ["XCBO"] | 7715.0000 | 7715.0000 | 37 | 37 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:41:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086bb-fa90-7801-82e8-47038213a0b4 | SPX | 2026-09-09 11:14 | straddle | 2 | 1 | 10 | 48130.00 | short | bid | 7631.6700 | 0.5000 | ["7635"] | ["0.1509"] | ["7586.87","7683.13"] | ["XCBO"] | 7635.0000 | 7635.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:14:39Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081ee-0f30-70c3-b848-c5268043b413 | SPX | 2026-09-08 12:50 | straddle | 2 | 1 | 10 | 34900.00 | unknown | — | 7689.5700 | 0.4000 | ["7690"] | ["0.1087"] | [] | ["XCBO"] | 7690.0000 | 7690.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:50:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081a6-f028-7573-a34e-da6dbfb3b40d | SPX | 2026-09-08 11:33 | straddle | 2 | 1 | 10 | 122750.00 | short | bid | 7693.2800 | 0.8000 | ["7720"] | ["0.1198"] | ["7597.25","7842.75"] | ["XCBO"] | 7720.0000 | 7720.0000 | 10 | 10 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:33:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |