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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b528-165f-7b63-920d-66fe38016c4d | SPX | 2026-09-18 11:34 | put_diagonal_spread | 2 | 1 | 2 | 42060.00 | short | bid | 7626.9800 | 2.1000 | ["7715","7725"] | ["0.1036","0.1052"] | [] | ["XCBO"] | 7715.0000 | 7725.0000 | 3 | 17 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:35:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bc-96d7-7381-addc-72202943f65a | SPX | 2026-09-18 09:37 | put_diagonal_spread | 2 | 1 | 146 | 30660.00 | long | ask | 7640.3900 | 0.2394 | ["6800","7000"] | ["0.2901","0.2964"] | [] | ["XCBO"] | 6800.0000 | 7000.0000 | 5 | 12 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b5-d84a-74a3-b504-5c647b3bc7e3 | SPX | 2026-09-18 09:30 | put_diagonal_spread | 2 | 1 | 6 | 30140.00 | unknown | bid | 7647.4900 | 2.4000 | ["7625","7650"] | ["0.1212","0.2048"] | [] | ["XCBO"] | 7625.0000 | 7650.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:30:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d5-1fd3-76e3-aa99-d99815e2ca6b | SPX | 2026-09-17 15:25 | put_diagonal_spread | 2 | 1 | 2 | 39420.00 | short | bid | 7638.3600 | 1.2000 | ["7715","7735"] | ["0.1051","0.6259"] | [] | ["XCBO"] | 7715.0000 | 7735.0000 | 0 | 14 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:25:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba6-dc63-7483-abfc-9fa18555dc56 | SPX | 2026-09-16 15:17 | put_diagonal_spread | 2 | 1 | 4 | 85040.00 | short | ask | 7522.9100 | 3.0000 | ["7600","7650"] | ["0.1655","0.6016"] | [] | ["XCBO"] | 7600.0000 | 7650.0000 | 0 | 2 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69d-2396-7173-8ba8-a96d94983afd | SPX | 2026-09-15 15:48 | put_diagonal_spread | 2 | 1 | 2 | 48520.00 | short | bid | 7579.5400 | 4.9000 | ["7695","7700"] | ["0.1157","1.4148"] | [] | ["XCBO"] | 7695.0000 | 7700.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:48:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a69a-f116-7e62-87a2-076dd0637e72 | SPX | 2026-09-15 15:46 | put_diagonal_spread | 2 | 1 | 2 | 29100.00 | short | bid | 7578.4100 | 0.8000 | ["7615","7650"] | ["0.1375","0.2316"] | [] | ["XCBO"] | 7615.0000 | 7650.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:46:19Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a690-8906-7492-b219-fd324b699eed | SPX | 2026-09-15 15:34 | put_diagonal_spread | 2 | 1 | 5 | 261050.00 | short | bid | 7580.3500 | 19.4000 | ["7840","7845"] | ["0.2534","0.4716"] | [] | ["XCBO"] | 7840.0000 | 7845.0000 | 0 | 1 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:35:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a67b-3be6-7b11-95b2-c2cbc2ce939c | SPX | 2026-09-15 15:11 | put_diagonal_spread | 2 | 1 | 3 | 37260.00 | short | bid | 7584.0400 | 0.6000 | ["7630","7645"] | ["0.1682","0.1994"] | [] | ["XCBO"] | 7630.0000 | 7645.0000 | 0 | 2 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:12:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d4-c2b6-75a0-910d-abdc736f3b68 | SPX | 2026-09-15 12:09 | put_diagonal_spread | 2 | 1 | 5 | 147800.00 | long | ask | 7578.5400 | 0.7000 | ["7560","7650"] | ["0.1530","0.1505"] | [] | ["XCBO"] | 7560.0000 | 7650.0000 | 9 | 107 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:09:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0be-cad0-70b0-af2c-67586363c12d | SPX | 2026-09-14 12:27 | put_diagonal_spread | 2 | 2 | 38 | 48640.00 | long | ask | 7632.7400 | 0.2500 | ["7600","7615"] | ["0.1460","0.1438"] | [] | ["XCBO"] | 7600.0000 | 7615.0000 | 0 | 1 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:28:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0bd-f3f8-7f82-8d6f-5cfdd8ffa4bf | SPX | 2026-09-14 12:26 | put_diagonal_spread | 2 | 4 | 65 | 82550.00 | long | ask | 7633.7000 | 0.2654 | ["7600","7615"] | ["0.1473","0.1480"] | [] | ["XCBO"] | 7600.0000 | 7615.0000 | 0 | 1 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:26:41Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c9e-c8c0-7990-9fa7-5ae8d20f4712 | SPX | 2026-09-10 14:40 | put_diagonal_spread | 2 | 1 | 21 | 43260.00 | long | ask | 7591.7300 | 0.2476 | ["7400","7500"] | ["0.1921","0.2267"] | [] | ["XCBO"] | 7400.0000 | 7500.0000 | 1 | 6 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:40:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c02-3aa0-7d71-b78d-d18515e64dd0 | SPX | 2026-09-10 11:49 | put_diagonal_spread | 2 | 1 | 6 | 60000.00 | short | bid | 7601.9500 | 0.7500 | ["7570","7600"] | ["0.1485","0.1925"] | [] | ["XCBO"] | 7570.0000 | 7600.0000 | 1 | 15 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:49:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c02-3aa0-7d71-b78d-d15898eb8c93 | SPX | 2026-09-10 11:49 | put_diagonal_spread | 2 | 1 | 4 | 40000.00 | short | bid | 7601.9500 | 0.8000 | ["7570","7600"] | ["0.1485","0.1925"] | [] | ["XCBO"] | 7570.0000 | 7600.0000 | 1 | 15 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:49:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0868d-5528-7022-83a5-0bdabad00457 | SPX | 2026-09-09 10:23 | put_diagonal_spread | 2 | 1 | 4 | 81000.00 | short | bid | 7643.3900 | 0.7000 | ["7700","7725"] | ["0.1252","0.1184"] | [] | ["XCBO"] | 7700.0000 | 7725.0000 | 7 | 19 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:23:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0818f-ed88-7840-8dc1-7e91dc5490fc | SPX | 2026-09-08 11:08 | put_diagonal_spread | 2 | 1 | 2 | 54240.00 | long | ask | 7692.2300 | 3.4000 | ["7500","7800"] | ["0.1618","0.1155"] | [] | ["XCBO"] | 7500.0000 | 7800.0000 | 8 | 114 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:08:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |