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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b613-2df8-7430-a494-d94695d53462 | XLI | 2026-09-18 15:51 | iron_butterfly | 4 | 1 | 168 | 126000.00 | unknown | — | 169.8200 | 0.8000 | ["155","170","180"] | ["0.2356","0.1772","0.1712"] | [] | ["C2OX"] | 155.0000 | 180.0000 | 28 | 28 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b613-1a70-7953-8d32-d8c64a8121ee | XLI | 2026-09-18 15:51 | iron_butterfly | 4 | 1 | 82 | 61500.00 | long | bid | 169.8200 | 0.5800 | ["155","170","180"] | ["0.2372","0.1772","0.1702"] | ["164.20","175.80"] | ["C2OX"] | 155.0000 | 180.0000 | 28 | 28 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b536-2bd7-7ed1-8562-62857321243f | ORCL | 2026-09-18 11:50 | iron_butterfly | 4 | 1 | 10 | 32150.00 | long | bid | 145.7200 | 1.2000 | ["145","147","149"] | ["0.4931","0.4642","0.4672"] | ["145.65","148.35"] | ["XCBO"] | 145.0000 | 149.0000 | 35 | 35 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:50:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afcb-8b8b-73e2-a89c-1952b66674c3 | AMZN | 2026-09-17 10:35 | iron_butterfly | 4 | 1 | 9 | 181125.00 | unknown | — | 252.2001 | 4.4500 | ["310","340","370"] | ["0.3904","0.3885","0.3627"] | [] | ["C2OX"] | 310.0000 | 370.0000 | 491 | 491 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:35:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcb-165b-7b93-b86d-c9b442c3d966 | AMZN | 2026-09-17 10:35 | iron_butterfly | 4 | 1 | 4 | 80460.00 | unknown | — | 252.2800 | 4.9500 | ["310","340","370"] | ["0.3903","0.3884","0.3624"] | [] | ["C2OX"] | 310.0000 | 370.0000 | 491 | 491 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:35:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afaa-8a53-7e50-8d1c-0385dc4f3f7a | SPY | 2026-09-17 09:59 | iron_butterfly | 4 | 2 | 87 | 28362.00 | unknown | — | 761.2000 | 0.0400 | ["759","762","765"] | ["0.1731","0.1553","0.1559"] | [] | ["XISX"] | 759.0000 | 765.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:59:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a5d0-b78d-7a01-95d5-691abd2afc47 | META | 2026-09-15 12:05 | iron_butterfly | 4 | 1 | 3 | 53160.00 | short | ask | 669.1150 | 1.8900 | ["520","570","610"] | ["0.4548","0.4138","0.3972"] | ["533.40","606.60"] | ["XISX"] | 520.0000 | 610.0000 | 31 | 31 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:05:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5cd-3136-7313-b867-1da9a6f7fd25 | META | 2026-09-15 12:01 | iron_butterfly | 4 | 1 | 4 | 160140.00 | short | ask | 668.8600 | 8.6000 | ["600","650","700"] | ["0.4197","0.4218","0.4234"] | ["604.95","695.05"] | ["C2OX"] | 600.0000 | 700.0000 | 367 | 367 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:02:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5cb-ba36-73d3-8b68-b3ed65488e9d | META | 2026-09-15 11:59 | iron_butterfly | 4 | 1 | 21 | 840525.00 | unknown | — | 668.6150 | 11.0500 | ["600","650","700"] | ["0.4198","0.4219","0.4234"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 367 | 367 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:00:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5cb-b266-74e3-9a8c-6759acb5cd56 | META | 2026-09-15 11:59 | iron_butterfly | 4 | 1 | 4 | 160100.00 | unknown | — | 668.6475 | 11.0500 | ["600","650","700"] | ["0.4198","0.4218","0.4233"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 367 | 367 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:00:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c7-3dc6-7481-a61d-3b623c7e30b1 | META | 2026-09-15 11:54 | iron_butterfly | 4 | 1 | 21 | 840105.00 | unknown | — | 667.8200 | 9.6500 | ["600","650","700"] | ["0.4203","0.4221","0.4235"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 367 | 367 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:55:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c7-2e26-7882-990c-9ee6b74fcfe2 | META | 2026-09-15 11:54 | iron_butterfly | 4 | 1 | 4 | 160020.00 | unknown | — | 667.6850 | 7.5000 | ["600","650","700"] | ["0.4201","0.4222","0.4238"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 367 | 367 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:55:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56e-cd27-7862-9cc7-14bdb873e6ac | SPY | 2026-09-15 10:18 | iron_butterfly | 4 | 3 | 92 | 25392.00 | unknown | — | 758.3500 | 0.0400 | ["756","759","762"] | ["0.1576","0.1412","0.1477"] | [] | ["XISX"] | 756.0000 | 762.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:18:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0ed-50f9-7bc2-83c9-97bc28a87207 | SPY | 2026-09-14 13:18 | iron_butterfly | 4 | 2 | 29 | 29029.00 | short | ask | 761.9800 | 0.0500 | ["760","763","770"] | ["0.1597","0.1504","0.1330"] | ["766.61"] | ["XISX"] | 760.0000 | 770.0000 | 2 | 2 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-62b0-7210-865e-788b1b961114 | META | 2026-09-14 13:17 | iron_butterfly | 4 | 1 | 21 | 831495.00 | short | ask | 663.8331 | 8.2000 | ["600","650","700"] | ["0.4178","0.4198","0.4213"] | ["604.95","695.05"] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-4f28-7863-84f5-995a84da965b | META | 2026-09-14 13:17 | iron_butterfly | 4 | 1 | 4 | 158380.00 | short | ask | 663.8331 | 8.2000 | ["600","650","700"] | ["0.4178","0.4198","0.4213"] | ["604.95","695.05"] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:17:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0aa-8f20-7142-8e93-95ef12d155c9 | META | 2026-09-14 12:05 | iron_butterfly | 4 | 1 | 9 | 354645.00 | unknown | — | 659.2300 | 8.9500 | ["600","650","700"] | ["0.4184","0.4205","0.4221"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:05:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a9-c400-76f1-9569-74ad8a986bc6 | META | 2026-09-14 12:04 | iron_butterfly | 4 | 1 | 8 | 315800.00 | short | ask | 660.2464 | 4.1500 | ["600","650","700"] | ["0.4188","0.4206","0.4219"] | ["604.95","695.05"] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:04:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a8-4918-74b0-94fa-872d704fbca1 | META | 2026-09-14 12:02 | iron_butterfly | 4 | 1 | 4 | 157860.00 | unknown | — | 660.0150 | 8.2000 | ["600","650","700"] | ["0.4185","0.4206","0.4223"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:03:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a7-a120-7523-8a23-96c8ae3cbef9 | META | 2026-09-14 12:02 | iron_butterfly | 4 | 1 | 5 | 197375.00 | unknown | — | 660.0525 | 5.6000 | ["600","650","700"] | ["0.4183","0.4207","0.4226"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:02:18Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a099-7c08-7ff0-ba06-1e854b9cee51 | META | 2026-09-14 11:46 | iron_butterfly | 4 | 1 | 21 | 828345.00 | unknown | — | 658.9600 | 9.5500 | ["600","650","700"] | ["0.4189","0.4210","0.4227"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:47:08Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a099-6880-7812-b664-9e67e76de78e | META | 2026-09-14 11:46 | iron_butterfly | 4 | 1 | 4 | 157780.00 | unknown | — | 658.7450 | 9.6000 | ["600","650","700"] | ["0.4188","0.4211","0.4229"] | [] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:47:08Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a091-2b20-73f3-8b9c-296b45ff94ce | META | 2026-09-14 11:37 | iron_butterfly | 4 | 1 | 7 | 275905.00 | short | ask | 658.2550 | 5.8500 | ["600","650","700"] | ["0.4184","0.4211","0.4232"] | ["604.95","695.05"] | ["C2OX"] | 600.0000 | 700.0000 | 368 | 368 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:37:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03d-c391-7832-8dc3-5af84f11baad | SPY | 2026-09-14 10:06 | iron_butterfly | 4 | 1 | 98 | 28812.00 | unknown | — | 760.6600 | 0.0400 | ["757","760","763"] | ["0.1772","0.1482","0.1363"] | [] | ["XISX"] | 757.0000 | 763.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:06:52Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09165-0360-7e50-b8d4-4065d06c5a70 | SPX | 2026-09-11 12:55 | iron_butterfly | 4 | 1 | 10 | 53700.00 | unknown | — | 7668.3500 | 0.7000 | ["7620","7670","7720"] | ["0.0930","0.0764","0.0662"] | [] | ["XCBO"] | 7620.0000 | 7720.0000 | 3 | 3 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:55:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce3-d488-7051-9275-3896dfc49bff | SPY | 2026-09-10 15:55 | iron_butterfly | 4 | 1 | 46 | 32568.00 | short | ask | 757.9100 | 0.0400 | ["748","758","768"] | ["0.2265","0.1984","0.1699"] | ["752.52","763.48"] | ["XBOX"] | 748.0000 | 768.0000 | 1 | 1 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:55:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ce3-c8d0-7801-9455-9ab52bce96ed | SPY | 2026-09-10 15:55 | iron_butterfly | 4 | 3 | 72 | 50953.00 | short | ask | 757.9400 | 0.0400 | ["748","758","768"] | ["0.2270","0.1983","0.1695"] | ["752.52","763.48"] | ["ARCO","BATO"] | 748.0000 | 768.0000 | 1 | 1 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:55:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7d-a460-7fe2-b543-1e58933e34e9 | QQQ | 2026-09-10 14:03 | iron_butterfly | 4 | 2 | 140 | 39060.00 | short | ask | 709.4400 | 0.0400 | ["709","710","711"] | ["0.2154","0.2073","0.2020"] | ["709.19","710.81"] | ["ARCO"] | 709.0000 | 711.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:04:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0821c-dba8-7bc2-ac9e-6d6edf67a097 | AVGO | 2026-09-08 13:42 | iron_butterfly | 4 | 1 | 3 | 67140.00 | unknown | — | 367.1050 | 5.7500 | ["290","350","520"] | ["0.4647","0.4594","0.4609"] | [] | ["XISX"] | 290.0000 | 520.0000 | 500 | 500 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:42:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ae-1c18-7471-8c64-768425c65a56 | QQQ | 2026-09-08 11:41 | iron_butterfly | 4 | 2 | 90 | 47160.00 | unknown | — | 720.2200 | 0.0500 | ["719","720","721"] | ["0.1665","0.1585","0.1551"] | [] | ["ARCO"] | 719.0000 | 721.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:41:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d42-d4e5-7ed0-a6ed-4c7c5853ab89 | MU | 2026-09-04 12:31 | iron_butterfly | 4 | 1 | 3 | 35910.00 | long | bid | 1006.6400 | 1.0000 | ["1020","1065","1110"] | ["0.5357","0.5458","0.5698"] | ["1027.50","1102.50"] | ["XISX"] | 1020.0000 | 1110.0000 | 7 | 7 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:31:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |