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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b527-f720-7811-9fda-7327de2e2f8b | ASML | 2026-09-18 11:34 | call_vertical_spread | 2 | 2 | 9 | 129150.00 | long | ask | 1654.5100 | 5.4333 | ["1660","1700"] | ["0.4486","0.4343"] | ["1679.99"] | ["ARCO","XPHO"] | 1660.0000 | 1700.0000 | 28 | 28 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:35:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0de-5f03-7b03-adfe-9fa87b1a2d03 | ASML | 2026-09-17 15:35 | put_calendar | 2 | 1 | 20 | 643400.00 | unknown | — | 1628.6900 | 3.7000 | ["1580"] | ["0.4348"] | [] | ["XISX"] | 1580.0000 | 1580.0000 | 183 | 211 | false | true | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:36:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d4-0a7b-7030-a608-d194c59ac08e | ASML | 2026-09-17 15:24 | put_calendar | 2 | 1 | 20 | 435800.00 | unknown | — | 1625.9200 | 3.3000 | ["1460"] | ["0.4341"] | [] | ["XISX"] | 1460.0000 | 1460.0000 | 183 | 211 | false | true | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:25:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abcd-bd83-77e3-a605-dced03624a56 | ASML | 2026-09-16 15:59 | put_diagonal_spread | 2 | 1 | 4 | 127410.00 | short | bid | 1602.1000 | 13.7750 | ["1720","1735"] | ["0.4459","0.6955"] | [] | ["C2OX"] | 1720.0000 | 1735.0000 | 2 | 65 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:59:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae5-93eb-7e61-94fc-0493424431c2 | ASML | 2026-09-16 11:46 | call_calendar | 2 | 1 | 10 | 647700.00 | unknown | — | 1605.8000 | 16.8000 | ["1720"] | ["0.4555"] | [] | ["XISX"] | 1720.0000 | 1720.0000 | 457 | 492 | false | true | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:46:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a656-ac86-7c51-9b47-e4cc22889af0 | ASML | 2026-09-15 14:31 | call_diagonal_spread | 2 | 2 | 3 | 108030.00 | short | ask | 1593.3748 | 13.1000 | ["1400","1600"] | ["0.7581","0.4309"] | [] | ["XCBO"] | 1400.0000 | 1600.0000 | 3 | 122 | false | false | true | true | false | mesl | market_whale | 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 |
| 01a0a115-f351-75b2-90b8-500903a1632b | ASML | 2026-09-14 14:02 | iron_condor | 4 | 1 | 17 | 1063860.00 | unknown | — | 1592.0050 | 14.9000 | ["1660","1700","2000","2040"] | ["0.4428","0.4443","0.4440","0.4456"] | [] | ["C2OX"] | 1660.0000 | 2040.0000 | 186 | 186 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:03:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a115-eb80-75c2-8253-ea5471865081 | ASML | 2026-09-14 14:02 | iron_condor | 4 | 1 | 3 | 187740.00 | unknown | — | 1592.2000 | 15.7000 | ["1660","1700","2000","2040"] | ["0.4430","0.4445","0.4438","0.4455"] | [] | ["C2OX"] | 1660.0000 | 2040.0000 | 186 | 186 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:03:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c57-57b1-79f0-984f-c1417b4ba428 | ASML | 2026-09-10 13:22 | call_diagonal_spread | 2 | 1 | 6 | 149880.00 | long | ask | 1698.7500 | 11.1000 | ["2100","2900"] | ["0.4471","0.4821"] | [] | ["XISX"] | 2100.0000 | 2900.0000 | 127 | 645 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:22:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0825f-0529-7cd0-bbaf-d3d1b69ac414 | ASML | 2026-09-08 14:54 | other | 2 | 1 | 10 | 544000.00 | unknown | — | 1771.3300 | 25.5000 | ["2240"] | ["0.4803"] | [] | ["XISX"] | 2240.0000 | 2240.0000 | 465 | 500 | false | true | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:54:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dc4-0eed-7d31-8001-9367feca050d | ASML | 2026-09-04 14:52 | other | 2 | 1 | 5 | 237750.00 | unknown | — | 1702.9600 | 16.2000 | ["1500"] | ["0.4417"] | [] | ["C2OX"] | 1500.0000 | 1500.0000 | 42 | 49 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:52:39Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d60-fba5-7ab1-a495-e32d52a6aa20 | ASML | 2026-09-04 13:04 | other | 2 | 1 | 10 | 533200.00 | unknown | — | 1711.3000 | 20.0000 | ["2080"] | ["0.4541"] | [] | ["XCBO"] | 2080.0000 | 2080.0000 | 469 | 504 | false | true | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:04:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d60-efed-7d21-a723-77823dc2bf41 | ASML | 2026-09-04 13:04 | strangle | 2 | 1 | 4 | 275720.00 | short | bid | 1711.3000 | 13.4000 | ["1940","2100"] | ["0.4696","0.4528"] | ["1250.70","2789.30"] | ["AMXO"] | 1940.0000 | 2100.0000 | 469 | 469 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:04:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d60-efed-7d21-a723-77792335399b | ASML | 2026-09-04 13:04 | strangle | 2 | 2 | 2 | 137860.00 | short | bid | 1711.3000 | 17.1000 | ["1940","2100"] | ["0.4696","0.4528"] | ["1250.70","2789.30"] | ["XCBO","XISX"] | 1940.0000 | 2100.0000 | 469 | 469 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:04:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |