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-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 |
| 01a0a67d-eb66-7290-b4cf-8f2816298a7d | ASML | 2026-09-15 15:14 | call_diagonal_spread | 2 | 1 | 6 | 489960.00 | unknown | — | 1591.8800 | 27.2000 | ["1840","1860"] | ["0.4592","0.4585"] | [] | ["XPHO"] | 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 |
| 01a0a669-0ba6-74a2-bc08-63e1a8ca6868 | ASML | 2026-09-15 14:51 | call_diagonal_spread | 2 | 1 | 8 | 653760.00 | unknown | — | 1590.4600 | 27.0000 | ["1840","1860"] | ["0.4607","0.4594"] | [] | ["XPHO"] | 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-15T18:52:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c0-92be-74c3-a321-be83daab4d93 | ASML | 2026-09-15 11:47 | call_diagonal_spread | 2 | 1 | 6 | 116874.00 | unknown | — | 1592.2562 | 10.5000 | ["1640","1720"] | ["0.4197","0.4436"] | [] | ["XPHO"] | 1640.0000 | 1720.0000 | 24 | 157 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:48:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a582-2647-73b2-b6cb-a834d4bb9fc9 | ASML | 2026-09-15 10:39 | call_diagonal_spread | 2 | 1 | 10 | 160900.00 | unknown | — | 1583.2986 | 4.6100 | ["1880","1900"] | ["0.4457","0.4471"] | [] | ["XISX"] | 1880.0000 | 1900.0000 | 94 | 185 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:39:44Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a573-8bfe-7a40-91ea-a135946044d1 | ASML | 2026-09-15 10:23 | call_diagonal_spread | 2 | 2 | 16 | 133840.00 | unknown | — | 1591.1850 | 12.1875 | ["1700","1800"] | ["0.4555","0.4705"] | [] | ["XISX"] | 1700.0000 | 1800.0000 | 31 | 45 | false | true | true | true | false | mlet | 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 |
| 01a0a05a-6b80-73e0-8586-f2bcceb9aea5 | ASML | 2026-09-14 10:37 | call_diagonal_spread | 2 | 1 | 2 | 202000.00 | unknown | — | 1602.0000 | 34.0000 | ["1580","1600"] | ["0.4603","0.4589"] | [] | ["XISX"] | 1580.0000 | 1600.0000 | 823 | 858 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:38:08Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |