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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4f5-36ef-7931-949a-7813ef7ba9b7 | ASML | 2026-09-18 10:39 | call_ratio_spread | 2 | 1 | 120 | 614280.00 | long | ask | 1642.0700 | 3.8000 | ["1720","1880"] | ["0.4431","0.4601"] | ["1744.88","2150.23"] | ["EDGO"] | 1720.0000 | 1880.0000 | 28 | 28 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:39:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a8-d7e3-7ab0-8789-d0cb47331304 | ASML | 2026-09-17 14:37 | put_calendar | 2 | 1 | 20 | 501900.00 | short | ask | 1625.4850 | 5.5000 | ["1500"] | ["0.4344"] | [] | ["XMIO"] | 1500.0000 | 1500.0000 | 183 | 211 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:38:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b07e-c65b-7e61-b227-ddafdde4e169 | ASML | 2026-09-17 13:51 | call_diagonal_spread | 2 | 1 | 2 | 125546.00 | long | ask | 1622.1400 | 26.2000 | ["1320","1420"] | ["2.0996","0.4346"] | [] | ["EDGO"] | 1320.0000 | 1420.0000 | 1 | 183 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:51:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe3-788b-7711-b002-de96a6f69f1c | ASML | 2026-09-17 11:01 | put_vertical_spread | 2 | 1 | 25 | 679300.00 | long | ask | 1626.5600 | 5.2000 | ["1600","1620"] | ["0.4211","0.4213"] | ["1609.90"] | ["XCBO"] | 1600.0000 | 1620.0000 | 120 | 120 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:02:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab2d-996b-7c41-86ff-a3a0b1e2bdf7 | ASML | 2026-09-16 13:04 | call_calendar | 2 | 1 | 2 | 143942.00 | long | ask | 1603.0701 | 24.4000 | ["1620"] | ["0.4538"] | [] | ["XCBO"] | 1620.0000 | 1620.0000 | 457 | 492 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:05:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab2b-0542-7e42-a06f-1b66b8115060 | ASML | 2026-09-16 13:01 | call_calendar | 2 | 1 | 2 | 138342.00 | long | ask | 1604.1600 | 26.4000 | ["1660"] | ["0.4557"] | [] | ["XCBO"] | 1660.0000 | 1660.0000 | 457 | 492 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:02:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab11-bc9b-7961-a6a2-0232e9c994fe | ASML | 2026-09-16 12:34 | call_calendar | 2 | 1 | 2 | 138632.00 | long | ask | 1604.5000 | 27.1000 | ["1660"] | ["0.4565"] | [] | ["XCBO"] | 1660.0000 | 1660.0000 | 457 | 492 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:34:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aabc-f57b-7530-a8d7-50659b142de8 | ASML | 2026-09-16 11:01 | call_calendar | 2 | 1 | 10 | 718960.00 | long | ask | 1614.9200 | 26.7000 | ["1640"] | ["0.4541"] | [] | ["XCBO"] | 1640.0000 | 1640.0000 | 457 | 492 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:01:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aabb-18eb-7342-b14d-8a469caff616 | ASML | 2026-09-16 10:59 | call_calendar | 2 | 1 | 2 | 142922.00 | long | ask | 1613.6000 | 20.4000 | ["1640"] | ["0.4522"] | [] | ["XCBO"] | 1640.0000 | 1640.0000 | 457 | 492 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:59:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a624-d6b6-7d70-ba0f-a38d242445d5 | ASML | 2026-09-15 13:37 | call_calendar | 2 | 1 | 2 | 118366.00 | long | ask | 1591.0500 | 17.6000 | ["1780"] | ["0.4577"] | [] | ["XCBO"] | 1780.0000 | 1780.0000 | 458 | 493 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:37:56Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a621-11de-7820-a6dc-8d93ad6c4399 | ASML | 2026-09-15 13:32 | call_calendar | 2 | 1 | 2 | 108644.00 | long | ask | 1592.4850 | 19.6000 | ["1860"] | ["0.4588"] | [] | ["XCBO"] | 1860.0000 | 1860.0000 | 458 | 493 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:33:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a61f-6816-7a70-9d7a-ea504437c48c | ASML | 2026-09-15 13:31 | call_calendar | 2 | 1 | 2 | 108612.00 | long | ask | 1593.0350 | 19.9000 | ["1860"] | ["0.4583"] | [] | ["XCBO"] | 1860.0000 | 1860.0000 | 458 | 493 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:31:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a61b-a726-7c81-832d-8c3dbf956598 | ASML | 2026-09-15 13:27 | call_calendar | 2 | 1 | 2 | 103882.00 | long | ask | 1592.0000 | 17.8000 | ["1900"] | ["0.4594"] | [] | ["XCBO"] | 1900.0000 | 1900.0000 | 458 | 493 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:27:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a573-9b9e-7b92-97c8-a29c82ca9c8e | ASML | 2026-09-15 10:23 | put_vertical_spread | 2 | 1 | 5 | 103250.00 | long | ask | 1591.0000 | 13.4000 | ["980","1300"] | ["0.4799","0.4670"] | ["1207.18"] | ["XPHO"] | 980.0000 | 1300.0000 | 493 | 493 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:23:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a558-a92e-7103-9629-45f65cd9dd0b | ASML | 2026-09-15 09:54 | call_calendar | 2 | 1 | 2 | 110460.00 | short | ask | 1592.7150 | 26.6000 | ["2400"] | ["0.4616"] | [] | ["XMIO"] | 2400.0000 | 2400.0000 | 822 | 857 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:54:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a54c-dda6-7752-ac47-c7be3e2e55f7 | ASML | 2026-09-15 09:41 | put_diagonal_spread | 2 | 1 | 4 | 105040.00 | long | ask | 1587.7700 | 28.6000 | ["1695","1700"] | ["0.4160","0.4251"] | [] | ["XMIO"] | 1695.0000 | 1700.0000 | 17 | 24 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:41:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0fd-8568-7dc1-b281-0353d6f0e688 | ASML | 2026-09-14 13:36 | call_calendar | 2 | 1 | 2 | 108052.00 | long | ask | 1591.2400 | 22.9000 | ["1860"] | ["0.4573"] | [] | ["XCBO"] | 1860.0000 | 1860.0000 | 459 | 494 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:36:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a097-fd38-7520-ba2b-60eebedbbec5 | ASML | 2026-09-14 11:45 | call_calendar | 2 | 1 | 2 | 130968.00 | long | ask | 1601.4464 | 20.0000 | ["1700"] | ["0.4530"] | [] | ["XCBO"] | 1700.0000 | 1700.0000 | 459 | 494 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:45:15Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a071-4710-7e50-96a5-b4e5e8cbaa08 | ASML | 2026-09-14 11:02 | call_calendar | 2 | 1 | 4 | 248424.00 | short | ask | 1600.4400 | 31.3000 | ["1310"] | ["0.5042"] | [] | ["XCBO"] | 1310.0000 | 1310.0000 | 39 | 46 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:03:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a024-9e10-7a82-971d-8a2f4947af79 | ASML | 2026-09-14 09:39 | put_diagonal_spread | 2 | 1 | 5 | 158045.00 | long | ask | 1584.3100 | 18.2000 | ["1720","1740"] | ["0.4382","0.5818"] | [] | ["XMIO"] | 1720.0000 | 1740.0000 | 4 | 25 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:39:10Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0824a-2568-7c21-b425-817757892f97 | ASML | 2026-09-08 14:31 | call_calendar | 2 | 1 | 10 | 608880.00 | long | ask | 1768.5400 | 25.3000 | ["2100"] | ["0.4740"] | [] | ["XCBO"] | 2100.0000 | 2100.0000 | 465 | 500 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:32:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08249-b808-7712-8e97-64aa0e184c5a | ASML | 2026-09-08 14:31 | call_calendar | 2 | 1 | 2 | 121864.00 | long | ask | 1768.0150 | 26.2000 | ["2100"] | ["0.4746"] | [] | ["XCBO"] | 2100.0000 | 2100.0000 | 465 | 500 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:31:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e7-96f1-7f83-a790-f00c634d348d | ASML | 2026-09-08 12:43 | put_vertical_spread | 2 | 1 | 15 | 191670.00 | long | ask | 1764.0950 | 24.3000 | ["1650","1660"] | ["0.4734","0.4729"] | ["1656.44"] | ["XCBO"] | 1650.0000 | 1660.0000 | 45 | 45 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:44:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08181-2078-70c2-92c7-1622929e75c5 | ASML | 2026-09-08 10:51 | call_calendar | 2 | 1 | 2 | 129044.00 | long | ask | 1754.4800 | 26.0000 | ["2000"] | ["0.4675"] | [] | ["XCBO"] | 2000.0000 | 2000.0000 | 465 | 500 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:52:22Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d6b-f055-7970-9677-e012dec27488 | ASML | 2026-09-04 13:16 | call_calendar | 2 | 1 | 2 | 108684.00 | long | ask | 1709.2500 | 25.2000 | ["2060"] | ["0.4547"] | [] | ["XCBO"] | 2060.0000 | 2060.0000 | 469 | 504 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:16:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6b-d8e5-7622-855e-3820a589aa47 | ASML | 2026-09-04 13:16 | call_calendar | 2 | 1 | 2 | 109164.00 | long | ask | 1709.2500 | 16.0000 | ["2060"] | ["0.4562"] | [] | ["XCBO"] | 2060.0000 | 2060.0000 | 469 | 504 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:16:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d5b-7595-7b50-982f-b332f2b4ab15 | ASML | 2026-09-04 12:58 | call_calendar | 2 | 1 | 2 | 102816.00 | long | ask | 1712.4200 | 31.3000 | ["2120"] | ["0.4554"] | [] | ["XCBO"] | 2120.0000 | 2120.0000 | 469 | 504 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:59:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4e-b7dd-7901-98a4-e6a1a9059fdf | ASML | 2026-09-04 12:44 | call_calendar | 2 | 1 | 10 | 332540.00 | short | ask | 1710.2400 | 22.3000 | ["1900"] | ["0.4319"] | [] | ["XMIO"] | 1900.0000 | 1900.0000 | 196 | 224 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:44:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d2b-d245-7c63-b862-77696bbc447f | ASML | 2026-09-04 12:06 | call_calendar | 2 | 1 | 10 | 283190.00 | short | ask | 1710.0000 | 9.0000 | ["1980"] | ["0.4323"] | [] | ["XMIO"] | 1980.0000 | 1980.0000 | 196 | 224 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:06:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |