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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b526-9b77-7293-94a3-9b65c97efaf1 | AAPL | 2026-09-18 11:33 | strangle_swap | 4 | 1 | 10 | 121240.00 | unknown | bid | 335.1100 | 3.7600 | ["195","270","300","410"] | ["0.4262","0.3213","0.2959","0.2750"] | [] | ["C2OX"] | 195.0000 | 410.0000 | 119 | 546 | false | false | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:33:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b524-6128-7932-96f8-9b59ba614504 | AAPL | 2026-09-18 11:30 | strangle_swap | 4 | 1 | 8 | 96968.00 | unknown | bid | 335.0750 | 4.2100 | ["195","270","300","410"] | ["0.4189","0.3239","0.2955","0.2751"] | [] | ["C2OX"] | 195.0000 | 410.0000 | 119 | 546 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0af9c-3e2b-7b63-806c-a82c53d2d7f1 | MU | 2026-09-17 09:44 | strangle_swap | 4 | 1 | 55 | 161150.00 | unknown | — | 975.0050 | 1.2000 | ["750","1150"] | ["0.7318","0.6782"] | [] | ["XISX"] | 750.0000 | 1150.0000 | 15 | 22 | false | true | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:44:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af8f-9fb4-7c83-8eb6-9b7683ad6e13 | SPX | 2026-09-17 09:30 | strangle_swap | 4 | 1 | 4 | 31440.00 | unknown | — | 7641.9900 | 1.0000 | ["7650","7710","7715"] | ["0.1336","0.0966","0.1525"] | [] | ["XCBO"] | 7650.0000 | 7715.0000 | 1 | 4 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:12Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0ab86-5ffa-76a1-8f89-a451f6ee37a8 | SPX | 2026-09-16 14:41 | strangle_swap | 4 | 1 | 6 | 54060.00 | unknown | — | 7598.3000 | 0.7000 | ["7585","7600","7620","7625"] | ["0.1858","0.4637","0.4551","0.1807"] | [] | ["XCBO"] | 7585.0000 | 7625.0000 | 0 | 2 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:42:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3d-9343-7c00-981b-1dbfa825136b | SPX | 2026-09-16 13:22 | strangle_swap | 4 | 1 | 12 | 135120.00 | unknown | — | 7609.5500 | 0.7000 | ["7580","7630"] | ["0.2132","0.2007"] | [] | ["XCBO"] | 7580.0000 | 7630.0000 | 1 | 2 | false | true | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:23:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3d-77eb-7cd1-9c35-e47dc4634a03 | SPX | 2026-09-16 13:22 | strangle_swap | 4 | 1 | 4 | 45040.00 | unknown | — | 7609.7300 | 0.6000 | ["7580","7630"] | ["0.2130","0.2008"] | [] | ["XCBO"] | 7580.0000 | 7630.0000 | 1 | 2 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:22:08Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab06-5e73-78d3-b3f2-8e402cd4c9a0 | HOOD | 2026-09-16 12:21 | strangle_swap | 4 | 1 | 94 | 104528.00 | unknown | — | 105.1744 | 0.2800 | ["100","110"] | ["0.6353","0.6340"] | [] | ["ARCO"] | 100.0000 | 110.0000 | 9 | 16 | false | true | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:22:44Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac0-9efa-7082-bb0c-3e8dd7e92e8c | MSFT | 2026-09-16 11:05 | strangle_swap | 4 | 1 | 148 | 589040.00 | unknown | — | 493.3200 | 1.8000 | ["490","495","505"] | ["0.3230","0.2513","0.2829"] | [] | ["XISX"] | 490.0000 | 505.0000 | 2 | 23 | false | false | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:05:53Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa87-e773-7963-b364-713890945dd9 | SPY | 2026-09-16 10:03 | strangle_swap | 4 | 1 | 42 | 38220.00 | unknown | — | 759.7699 | 0.0400 | ["754","760"] | ["0.2765","0.2200"] | [] | ["XPHO"] | 754.0000 | 760.0000 | 0 | 2 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:04:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa70-e8bb-7cb0-8ace-f0fe006e91e5 | QQQ | 2026-09-16 09:38 | strangle_swap | 4 | 1 | 55 | 38940.00 | unknown | — | 708.2405 | 0.0400 | ["704","712"] | ["0.3377","0.2936"] | [] | ["XISX"] | 704.0000 | 712.0000 | 0 | 1 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:38:45Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a64e-4815-7593-9840-93abf18eaa93 | SPX | 2026-09-15 14:22 | strangle_swap | 4 | 1 | 11 | 170720.00 | unknown | — | 7586.6300 | 0.8000 | ["7605","7610"] | ["0.1813","0.1848"] | [] | ["XCBO"] | 7605.0000 | 7610.0000 | 1 | 3 | false | false | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:22:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0920d-b2f8-75a2-b581-1737436ee6b0 | SPX | 2026-09-11 15:59 | strangle_swap | 4 | 1 | 44 | 27060.00 | unknown | — | 7657.7200 | 0.4000 | ["7150","7460","7730","7800"] | ["0.2665","0.1417","0.0589","0.0925"] | [] | ["XCBO"] | 7150.0000 | 7800.0000 | 3 | 6 | false | true | true | true | true | mesl | tracked | 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 |
| 01a08c5f-4ec0-7e00-8afd-3d7500c90311 | SPX | 2026-09-10 13:30 | strangle_swap | 4 | 1 | 11 | 31130.00 | unknown | — | 7597.2600 | 0.4273 | ["7580","7690"] | ["0.1741","0.2387"] | [] | ["XCBO"] | 7580.0000 | 7690.0000 | 0 | 1 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:30:53Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd1-f341-7183-adb0-fc9a69d762bf | ORCL | 2026-09-10 10:56 | strangle_swap | 4 | 1 | 49 | 66885.00 | unknown | — | 158.7250 | 0.1900 | ["140","175"] | ["1.7955","2.0341"] | [] | ["XISX"] | 140.0000 | 175.0000 | 1 | 8 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:56:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087a8-bfd8-7ee3-ac95-8979a0c865bc | COST | 2026-09-09 15:32 | strangle_swap | 4 | 1 | 37 | 174899.00 | unknown | — | 901.9200 | 3.0500 | ["915","1015"] | ["0.2415","0.3112"] | [] | ["XISX"] | 915.0000 | 1015.0000 | 9 | 16 | false | false | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:33:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086bb-5a68-7c23-8cc2-700ed25fd2fb | QQQ | 2026-09-09 11:13 | strangle_swap | 4 | 1 | 98 | 81144.00 | unknown | — | 715.0000 | 0.0900 | ["678","738"] | ["0.2640","0.1681"] | [] | ["XISX"] | 678.0000 | 738.0000 | 9 | 16 | false | true | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:13:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |