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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a087c4-0068-7181-b875-ae386f1586d6 | SPX | 2026-09-09 16:02 | box_spread | 4 | 3 | 12 | 226600.00 | long | ask | 7636.4900 | 5.5250 | ["7670","7735"] | ["0.1096","0.0973"] | [] | ["XCBO"] | 7670.0000 | 7735.0000 | 5 | 5 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T20:04:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 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 |
| 01a0828e-5e40-73f3-b4b1-ee86f4abd081 | SPX | 2026-09-08 15:46 | box_spread | 4 | 2 | 6 | 27750.00 | long | ask | 7680.4300 | 0.7500 | ["7640","7680"] | ["0.3767","0.1958"] | [] | ["XCBO"] | 7640.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-08T19:46:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 01a0825a-5dc0-7353-a632-ca521d6c3f8c | SPX | 2026-09-08 14:49 | box_spread | 4 | 1 | 8 | 53320.00 | unknown | — | 7675.8900 | 3.0000 | ["7630","7695"] | ["0.3163","0.1582"] | [] | ["XCBO"] | 7630.0000 | 7695.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:49:19Z"} | 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 |