Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c54f-7f87-7a11-9fdb-3c3ae474eac8 | ASML | 2026-09-21 14:51 | call_diagonal_spread | 2 | 1 | 10 | 1095020.00 | short | ask | 1714.9700 | 29.4000 | ["1660","1700"] | ["0.4587","0.4575"] | [] | ["XCBO"] | 1660.0000 | 1700.0000 | 816 | 851 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:52:00Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c521-7e2f-7f91-a5a2-1315243e9ce5 | ASML | 2026-09-21 14:01 | call_diagonal_spread | 2 | 1 | 2 | 212664.00 | short | ask | 1710.6150 | 33.3000 | ["1700","1730"] | ["0.4595","0.4583"] | [] | ["XPHO"] | 1700.0000 | 1730.0000 | 816 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:02:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b613-7447-7a83-898f-9effaa40b211 | ASML | 2026-09-18 15:52 | call_diagonal_spread | 2 | 1 | 17 | 169728.00 | unknown | ask | 1660.1700 | 23.8000 | ["1810","1900"] | ["0.4554","0.4541"] | [] | ["XPHO"] | 1810.0000 | 1900.0000 | 42 | 63 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:52:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 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 |
| 01a0aac2-19e3-79f0-bc71-12a62fd2ea1e | ASML | 2026-09-16 11:07 | call_diagonal_spread | 2 | 1 | 14 | 100338.00 | long | ask | 1613.0200 | 11.0000 | ["1600","1620"] | ["0.5208","0.4186"] | [] | ["BATO"] | 1600.0000 | 1620.0000 | 2 | 9 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:07:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a67d-e396-7ab1-9002-98db652f788c | ASML | 2026-09-15 15:14 | call_diagonal_spread | 2 | 2 | 22 | 1796520.00 | long | ask | 1591.8800 | 28.6000 | ["1840","1860"] | ["0.4595","0.4581"] | [] | ["AMXO","ARCO"] | 1840.0000 | 1860.0000 | 822 | 857 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:14:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 |
| 01a09114-2c10-7042-83c5-9a0a44d17b8b | ASML | 2026-09-11 11:26 | call_diagonal_spread | 2 | 2 | 6 | 107031.00 | long | ask | 1715.8400 | 21.0000 | ["1620","1640"] | ["0.3874","1.7788"] | [] | ["ARCO","XPHO"] | 1620.0000 | 1640.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:27:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 01a081cd-b209-70d0-9e1c-975da3824b2d | ASML | 2026-09-08 12:15 | call_diagonal_spread | 2 | 1 | 10 | 237160.00 | long | ask | 1767.7150 | 12.3000 | ["1700","1720"] | ["0.4883","0.4931"] | [] | ["XISX"] | 1700.0000 | 1720.0000 | 10 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:15:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b1-92d0-7381-9513-a18883e3f21e | ASML | 2026-09-08 11:44 | call_diagonal_spread | 2 | 1 | 20 | 315920.00 | short | ask | 1768.3950 | 11.7000 | ["1675","1760"] | ["0.5567","0.4518"] | [] | ["BATO"] | 1675.0000 | 1760.0000 | 3 | 10 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:44:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |