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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-947f-7451-bf90-6df3b5f3b016 | SPX | 2026-09-18 15:59 | box_spread | 4 | 1 | 23 | 36540.00 | short | bid | 7647.8100 | 1.4261 | ["7635","7645"] | ["2.0176","0.5110"] | [] | ["XCBO"] | 7635.0000 | 7645.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-c098-79f0-a884-d3f5dff26b38 | GLD | 2026-09-18 15:51 | box_spread | 4 | 2 | 20 | 298700.00 | short | bid | 401.6400 | 1.0138 | ["350","475"] | ["0.2414","0.2707"] | [] | ["ARCO"] | 350.0000 | 475.0000 | 154 | 154 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-b5c8-7093-9639-720c692b61aa | SPX | 2026-09-18 10:10 | box_spread | 4 | 1 | 8 | 54520.00 | short | bid | 7626.9200 | 0.5750 | ["7625","7670"] | ["0.1478","0.1513"] | [] | ["XCBO"] | 7625.0000 | 7670.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:10:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-aa17-7920-b635-9c3ef32ece46 | SPX | 2026-09-18 09:39 | box_spread | 4 | 2 | 6 | 30240.00 | short | bid | 7642.3200 | 0.4667 | ["7630","7645"] | ["0.1493","0.1452"] | ["0","7630","7645"] | ["XCBO"] | 7630.0000 | 7645.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ba-9338-78b0-95d4-e6320a0696db | SPX | 2026-09-18 09:35 | box_spread | 4 | 1 | 10 | 52200.00 | short | bid | 7639.8800 | 0.5000 | ["7640","7645"] | ["0.1571","0.1576"] | ["0","7640","7645"] | ["XCBO"] | 7640.0000 | 7645.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:35:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ee-c253-7322-9dc8-a7c238eee130 | SPX | 2026-09-17 15:53 | box_spread | 4 | 1 | 5 | 27730.00 | short | bid | 7646.4600 | 1.8000 | ["7620","7675"] | ["0.6358","0.6020"] | [] | ["XCBO"] | 7620.0000 | 7675.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:54:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b07e-ddcb-7103-aba3-1b0e48da31db | SPX | 2026-09-17 13:51 | box_spread | 4 | 1 | 4 | 27120.00 | short | bid | 7634.9700 | 0.6000 | ["7620","7685"] | ["0.1279","0.1834"] | ["0","7620","7685"] | ["XCBO"] | 7620.0000 | 7685.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:51:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b079-963b-7b41-ab52-2595aabb9299 | SPX | 2026-09-17 13:45 | box_spread | 4 | 1 | 9 | 35460.00 | short | bid | 7635.8500 | 0.3500 | ["7635","7665"] | ["0.1004","0.1350"] | ["0","7635","7665"] | ["XCBO"] | 7635.0000 | 7665.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:45:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b01d-d5f2-7970-9e28-7863f8d0db68 | SPX | 2026-09-17 12:05 | box_spread | 4 | 1 | 10 | 83950.00 | short | bid | 7634.0800 | 0.4500 | ["7625","7700"] | ["0.1257","0.1903"] | [] | ["XCBO"] | 7625.0000 | 7700.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:06:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af94-953b-7b53-8964-f1e16b87a306 | SPX | 2026-09-17 09:35 | box_spread | 4 | 1 | 3 | 63360.00 | short | bid | 7626.0200 | 1.2667 | ["7545","7600"] | ["0.1374","0.1236"] | [] | ["XCBO"] | 7545.0000 | 7600.0000 | 5 | 5 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:35:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abcd-82eb-7f41-90fd-dd5da002f485 | SPX | 2026-09-16 15:59 | box_spread | 4 | 2 | 10 | 26820.00 | short | bid | 7553.0000 | 0.7750 | ["7550","7575"] | ["0.6222","1.7458"] | [] | ["XCBO"] | 7550.0000 | 7575.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:59:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab95-5beb-7a61-8bc0-99dc7534ba51 | SPX | 2026-09-16 14:58 | box_spread | 4 | 1 | 9 | 88975.00 | short | bid | 7553.3000 | 1.4889 | ["7555","7615"] | ["0.5179","0.5371"] | [] | ["XCBO"] | 7555.0000 | 7615.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:58:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab72-1c7b-7212-b725-9170dd173978 | SPX | 2026-09-16 14:19 | box_spread | 4 | 1 | 3 | 43320.00 | short | bid | 7609.5500 | 0.5500 | ["7535","7670"] | ["0.5677","0.4129"] | ["0","7535","7670"] | ["XCBO"] | 7535.0000 | 7670.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:19:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-a0c3-70e3-a1cd-9be62914b002 | SPX | 2026-09-16 13:53 | box_spread | 4 | 1 | 2 | 30480.00 | short | bid | 7608.8900 | 0.7000 | ["7575","7650"] | ["0.2347","0.2044"] | ["0","7575","7650"] | ["XCBO"] | 7575.0000 | 7650.0000 | 1 | 1 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:54:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab30-029b-7473-87f3-c620a7495e5d | SPX | 2026-09-16 13:07 | box_spread | 4 | 3 | 3 | 31380.00 | short | bid | 7605.7800 | 0.4667 | ["7575","7605"] | ["0.4612","0.4373"] | ["0","7575","7605"] | ["XCBO"] | 7575.0000 | 7605.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:07:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae6-a55b-7741-9284-171a35534f25 | SPX | 2026-09-16 11:47 | box_spread | 4 | 1 | 3 | 47325.00 | short | bid | 7624.8200 | 4.4000 | ["7520","7620"] | ["0.4278","0.3617"] | [] | ["XCBO"] | 7520.0000 | 7620.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:47:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab2-27db-72a2-928e-c9fd216cd492 | SPX | 2026-09-16 10:49 | box_spread | 4 | 1 | 4 | 40240.00 | short | bid | 7607.8700 | 0.4500 | ["7580","7625"] | ["0.3305","0.3040"] | ["0","7580","7625"] | ["XCBO"] | 7580.0000 | 7625.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:49:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7d-9ea3-7cd2-8bb7-ced5890c337c | SPX | 2026-09-16 09:52 | box_spread | 4 | 1 | 2 | 28080.00 | short | bid | 7613.7900 | 0.4500 | ["7530","7590"] | ["0.3244","0.2900"] | ["0","7530","7590"] | ["XCBO"] | 7530.0000 | 7590.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:52:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a66e-6aa6-7853-9b6c-242dee12466f | SPX | 2026-09-15 14:57 | box_spread | 4 | 2 | 15 | 50400.00 | short | bid | 7584.1300 | 0.3500 | ["7585","7610"] | ["0.1177","0.1444"] | ["0","7585","7610"] | ["XCBO"] | 7585.0000 | 7610.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:57:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a656-a89e-7273-aea5-da1cf759b4d9 | SPX | 2026-09-15 14:31 | box_spread | 4 | 1 | 10 | 74000.00 | short | bid | 7585.2200 | 0.6300 | ["7585","7650"] | ["0.1095","0.3272"] | [] | ["XCBO"] | 7585.0000 | 7650.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:32:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a654-d3de-71b3-99af-0fa5512d663d | SPX | 2026-09-15 14:29 | box_spread | 4 | 1 | 8 | 33600.00 | short | bid | 7587.5100 | 0.3500 | ["7570","7610"] | ["0.1502","0.1362"] | ["0","7570","7610"] | ["XCBO"] | 7570.0000 | 7610.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:29:36Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a653-e596-7f83-a3db-688a921a0389 | SPX | 2026-09-15 14:28 | box_spread | 4 | 1 | 15 | 49200.00 | short | bid | 7586.6400 | 0.3500 | ["7585","7610"] | ["0.1152","0.1357"] | ["0","7585","7610"] | ["XCBO"] | 7585.0000 | 7610.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | 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 |
| 01a0a62f-330e-7e12-b84a-45f97bbd674d | SPX | 2026-09-15 13:48 | box_spread | 4 | 1 | 3 | 25350.00 | short | bid | 7581.6900 | 0.4500 | ["7585","7655"] | ["0.1106","0.2777"] | [] | ["XCBO"] | 7585.0000 | 7655.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:49:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a55f-09fe-7fd0-b074-aa3f6fbc80f7 | SPX | 2026-09-15 10:01 | box_spread | 4 | 1 | 2 | 29780.00 | short | bid | 7604.7500 | 0.7500 | ["7615","7730"] | ["0.1336","0.3002"] | [] | ["XCBO"] | 7615.0000 | 7730.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:01:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0920d-d621-7cb2-a9cf-1a37ccae4244 | SPX | 2026-09-11 15:59 | box_spread | 4 | 2 | 25 | 27995.00 | short | bid | 7655.5900 | 1.5160 | ["7650","7660"] | ["0.6520","0.7027"] | [] | ["XCBO"] | 7650.0000 | 7660.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:59:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0920d-d621-7cb2-a9cf-184cdb41c6dc | SPX | 2026-09-11 15:59 | box_spread | 4 | 2 | 40 | 33845.00 | short | bid | 7656.3100 | 0.4863 | ["7655","7660"] | ["0.5495","0.6962"] | [] | ["XCBO"] | 7655.0000 | 7660.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:59:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09172-da58-7ae2-a45f-580bb0c8b6fc | GLD | 2026-09-11 13:10 | box_spread | 4 | 1 | 19 | 294595.00 | short | bid | 400.0600 | 1.0500 | ["370","490"] | ["0.2434","0.2964"] | [] | ["ARCO"] | 370.0000 | 490.0000 | 161 | 161 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:10:30Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c2-85b8-7c43-bc15-9d8a91dfec46 | SPX | 2026-09-11 09:57 | box_spread | 4 | 2 | 6 | 32160.00 | short | bid | 7670.4500 | 0.4667 | ["7665","7680"] | ["0.1670","0.1574"] | ["0","7665","7680"] | ["XCBO"] | 7665.0000 | 7680.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:57:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb1-eb30-7420-8a09-a0c5542fdbbf | SPX | 2026-09-10 15:01 | box_spread | 4 | 1 | 5 | 70665.00 | short | bid | 7589.5700 | 0.7000 | ["7630","7690"] | ["0.2243","0.5301"] | [] | ["XCBO"] | 7630.0000 | 7690.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:01:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7c-2d60-7a33-9bc0-4de65df1faa9 | SPY | 2026-09-10 14:02 | box_spread | 4 | 1 | 10 | 182220.00 | short | bid | 758.0350 | 0.5700 | ["755","775"] | ["0.1753","0.1679"] | [] | ["AMXO"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:02:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08727-8da0-7292-bb93-534182168dd1 | SPX | 2026-09-09 13:11 | box_spread | 4 | 1 | 9 | 33795.00 | short | bid | 7642.3700 | 0.3500 | ["7645","7665"] | ["0.1205","0.1294"] | [] | ["XCBO"] | 7645.0000 | 7665.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:12:27Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08276-0f98-71c0-a575-8f48bfcdec8e | SPX | 2026-09-08 15:19 | box_spread | 4 | 1 | 5 | 37850.00 | short | bid | 7682.6000 | 0.4000 | ["7685","7750"] | ["0.1395","0.4721"] | [] | ["XCBO"] | 7685.0000 | 7750.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:19:58Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08273-b608-7a52-91c9-fe7b343eb56e | SPX | 2026-09-08 15:16 | box_spread | 4 | 1 | 7 | 50765.00 | short | bid | 7685.0700 | 0.6500 | ["7685","7750"] | ["0.1345","0.3843"] | [] | ["XCBO"] | 7685.0000 | 7750.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:17:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0820e-7428-7652-b5ba-d5f61ab9c9d3 | SPX | 2026-09-08 13:26 | box_spread | 4 | 1 | 8 | 68500.00 | short | bid | 7688.0800 | 0.5375 | ["7715","7745"] | ["0.1372","0.2291"] | [] | ["XCBO"] | 7715.0000 | 7745.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:26:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08136-859a-7e82-8160-940fb3bae035 | SPX | 2026-09-08 09:30 | box_spread | 4 | 1 | 2 | 27230.00 | short | bid | 7710.9200 | 5.3000 | ["7725","7820"] | ["0.1397","0.2605"] | [] | ["XCBO"] | 7725.0000 | 7820.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:30:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d39-e3d5-7401-89c7-19f93267b5df | SPX | 2026-09-04 12:21 | box_spread | 4 | 1 | 6 | 25680.00 | short | bid | 7726.1700 | 0.4000 | ["7735","7750"] | ["0.1186","0.1310"] | ["0","7735","7750"] | ["XCBO"] | 7735.0000 | 7750.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:21:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |