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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4cf-dfa7-75b3-a764-fa61815ead1a | XSP | 2026-09-21 12:32 | other | 7 | 1 | 1103 | 75617.80 | unknown | — | 775.3500 | 0.2200 | ["764","770","772","773","776","777"] | ["0.3273","0.2196","0.1890","0.1565","0.1282","0.1314"] | [] | ["XCBO"] | 764.0000 | 777.0000 | 0 | 0 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:32:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c489-1a77-7640-9519-8780b5291869 | XSP | 2026-09-21 11:15 | other | 4 | 1 | 100 | 44740.00 | unknown | bid | 772.9000 | 1.0400 | ["766","770","785"] | ["0.1105","0.1356","0.1101"] | [] | ["XCBO"] | 766.0000 | 785.0000 | 9 | 60 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:15:31Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b585-595f-7bd1-9875-49d2e6a13c40 | XSP | 2026-09-18 13:16 | other | 4 | 1 | 45 | 25479.00 | unknown | bid | 762.3600 | 6.0900 | ["750","755","760"] | ["0.1220","0.1256","0.1264"] | [] | ["XCBO"] | 750.0000 | 760.0000 | 7 | 35 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:16:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b554-a888-7bc2-af66-119d0746fba3 | XSP | 2026-09-18 12:23 | other | 4 | 2 | 531 | 52072.80 | unknown | — | 761.6100 | 1.4000 | ["719","728","757","758"] | ["0.1851","0.1740","0.0728","0.0726"] | [] | ["XCBO"] | 719.0000 | 758.0000 | 3 | 42 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:23:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f9-22d7-7570-979b-28d83188507d | XSP | 2026-09-18 10:43 | other | 8 | 3 | 1650 | 97077.80 | unknown | — | 761.9600 | 1.5600 | ["757","758","760","761","762","763","764","765"] | ["0.0819","0.0808","0.1476","0.1408","0.0858","0.0843","0.1380","0.1395"] | [] | ["XCBO"] | 757.0000 | 765.0000 | 0 | 3 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:43:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab93-92e4-74d3-89e6-2d412a55fa2c | XSP | 2026-09-16 14:56 | other | 6 | 2 | 161 | 167948.20 | unknown | — | 756.1300 | 9.8000 | ["759","760","780","790"] | ["0.5348","0.5457","0.1411","0.1358"] | [] | ["XCBO"] | 759.0000 | 790.0000 | 0 | 212 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:56:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab71-709b-7e72-8482-c16acce2cf92 | XSP | 2026-09-16 14:18 | other | 4 | 1 | 105 | 64548.00 | unknown | — | 760.8900 | 1.8000 | ["810","815","820"] | ["0.1319","0.1321","0.1272"] | [] | ["XCBO"] | 810.0000 | 820.0000 | 184 | 212 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:18:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa8-dcf3-7ec0-a57c-639a4d9e8ca8 | XSP | 2026-09-16 10:39 | other | 4 | 1 | 45 | 30060.00 | unknown | — | 760.5100 | 1.0100 | ["745","750","755"] | ["0.1799","0.1583","0.1434"] | [] | ["XCBO"] | 745.0000 | 755.0000 | 5 | 29 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:40:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5d4-da26-7792-ad79-0b9696e85ee3 | XSP | 2026-09-15 12:09 | other | 4 | 1 | 45 | 28188.00 | unknown | — | 757.8200 | 0.9700 | ["745","750","755"] | ["0.2324","0.1820","0.1444"] | [] | ["XCBO"] | 745.0000 | 755.0000 | 3 | 36 | false | false | true | true | false | mlet | tracked | 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 |
| 01a0a0bc-1768-7850-bf0c-2a1e948e5e85 | XSP | 2026-09-14 12:24 | other | 4 | 2 | 730 | 113214.00 | unknown | — | 763.7900 | 1.1435 | ["756","757","773","774"] | ["0.1531","0.1502","0.1102","0.1091"] | [] | ["XCBO"] | 756.0000 | 774.0000 | 1 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:24:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b4-7e19-7050-8403-22c58056e096 | XSP | 2026-09-14 12:16 | other | 4 | 1 | 40 | 29052.00 | unknown | — | 763.4000 | 1.9400 | ["745","750","755"] | ["0.5493","0.2674","0.1418"] | [] | ["XCBO"] | 745.0000 | 755.0000 | 0 | 30 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:16:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a04d-d8c1-7851-961c-f60677501f32 | XSP | 2026-09-14 10:24 | other | 4 | 3 | 595 | 58877.10 | unknown | — | 760.4100 | 0.8000 | ["756","757","759","760"] | ["0.1563","0.1525","0.1569","0.1516"] | [] | ["XCBO"] | 756.0000 | 760.0000 | 0 | 1 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:24:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a025-b369-7603-bcd4-42d568c922cf | XSP | 2026-09-14 09:40 | other | 7 | 3 | 250 | 72616.90 | unknown | — | 760.0400 | 1.0900 | ["745","750","766","773","810","815","820"] | ["0.1675","0.1588","0.1295","0.1391","0.1384","0.1365","0.1348"] | [] | ["XCBO"] | 745.0000 | 820.0000 | 1 | 186 | false | true | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091e7-2bb0-7c12-b627-559cc309debf | XSP | 2026-09-11 15:17 | other | 4 | 1 | 26 | 26988.00 | unknown | — | 766.4200 | 1.9200 | ["738","743"] | ["1.2623","1.0755"] | [] | ["XCBO"] | 738.0000 | 743.0000 | 0 | 3 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:17:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09132-7dc8-7211-819e-82a38ead3a2f | XSP | 2026-09-11 11:59 | other | 2 | 1 | 1368 | 52129.10 | unknown | — | 767.0400 | 0.2000 | ["799","810"] | ["0.1223","0.1154"] | [] | ["XCBO"] | 799.0000 | 810.0000 | 7 | 70 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:00:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08beb-c889-7e33-9cda-fe14bf3060f5 | XSP | 2026-09-10 11:24 | other | 3 | 1 | 100 | 30600.00 | unknown | — | 760.4400 | 0.4100 | ["810","815","820"] | ["0.1357","0.1341","0.1326"] | [] | ["XCBO"] | 810.0000 | 820.0000 | 190 | 190 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:24:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bca-36c9-7e61-9a30-2e90a948fe28 | XSP | 2026-09-10 10:47 | other | 6 | 2 | 176 | 27611.30 | unknown | — | 759.9100 | 0.6900 | ["753","754","757","760","763"] | ["0.2370","0.2318","0.1767","0.1563","0.1501"] | [] | ["XCBO"] | 753.0000 | 763.0000 | 0 | 1 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:48:23Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087bb-c308-7d80-8773-bbf48c9e4eeb | XSP | 2026-09-09 15:53 | other | 4 | 1 | 32 | 27430.40 | unknown | — | 763.7700 | 10.4000 | ["740","745"] | ["2.7895","1.9627"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 1 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:54:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087a7-f0d1-7f50-82f5-2cf1a7b0c07d | XSP | 2026-09-09 15:32 | other | 4 | 1 | 45 | 34348.50 | unknown | — | 764.5100 | 2.6900 | ["745","750","755"] | ["0.2216","0.1713","0.1395"] | [] | ["XCBO"] | 745.0000 | 755.0000 | 2 | 29 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:32:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0879b-61f8-76a0-b988-7c02d500cb28 | XSP | 2026-09-09 15:18 | other | 4 | 1 | 45 | 31923.00 | unknown | — | 764.7100 | 5.1800 | ["750","755","760"] | ["0.2453","0.1286","0.1417"] | [] | ["XCBO"] | 750.0000 | 760.0000 | 1 | 55 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:18:25Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0827d-7df0-77c2-93c8-71b84dd80d6d | XSP | 2026-09-08 15:27 | other | 4 | 1 | 31 | 28027.10 | unknown | — | 768.2900 | 4.2700 | ["741","751"] | ["1.5853","1.0863"] | [] | ["XCBO"] | 741.0000 | 751.0000 | 0 | 1 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:27:43Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0827d-1090-7fe3-a6a8-3febc151a70e | XSP | 2026-09-08 15:27 | other | 4 | 1 | 26 | 26816.40 | unknown | — | 768.1300 | 1.9800 | ["740","745"] | ["1.3283","1.0685"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 1 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:27:43Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08278-cad0-7d92-8ca9-2bd0583058e3 | XSP | 2026-09-08 15:22 | other | 4 | 1 | 26 | 28867.80 | unknown | — | 768.1400 | 2.3200 | ["738","743"] | ["1.3378","1.2770"] | [] | ["XCBO"] | 738.0000 | 743.0000 | 0 | 1 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:22:43Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e5-8f68-7173-9fb5-ec1e727ffeb3 | XSP | 2026-09-08 12:41 | other | 4 | 1 | 257 | 45000.70 | unknown | — | 768.4700 | 0.2500 | ["721","724","759","760"] | ["0.1900","0.1854","0.1372","0.1361"] | [] | ["XCBO"] | 721.0000 | 760.0000 | 24 | 31 | true | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:41:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dea-ffad-7de0-b13f-7cab80873516 | XSP | 2026-09-04 15:35 | other | 4 | 1 | 26 | 32312.80 | unknown | — | 771.5000 | 2.5900 | ["738","743"] | ["2.0107","1.3694"] | [] | ["XCBO"] | 738.0000 | 743.0000 | 0 | 4 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:35:19Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de5-4abd-7c10-8de3-949bf84a31af | XSP | 2026-09-04 15:28 | other | 4 | 1 | 26 | 30248.40 | unknown | — | 771.5900 | 2.2000 | ["740","745"] | ["1.6377","1.4017"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 4 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:29:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de4-8b55-7e32-8d65-2969d23e48d2 | XSP | 2026-09-04 15:28 | other | 4 | 1 | 31 | 31595.20 | unknown | — | 771.5200 | 2.3600 | ["741","751"] | ["1.1787","1.1125"] | [] | ["XCBO"] | 741.0000 | 751.0000 | 0 | 4 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:28:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |