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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |