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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f4-0568-7813-ae74-4a2541a63911 | SMH | 2026-09-18 15:17 | call_calendar | 2 | 1 | 3 | 132840.00 | unknown | bid | 565.7400 | 8.8000 | ["430"] | ["0.3894"] | [] | ["XBOX"] | 430.0000 | 430.0000 | 819 | 854 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:17:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f3-1338-7522-abd9-8c5664605560 | SMH | 2026-09-18 15:16 | call_calendar | 2 | 1 | 3 | 132795.00 | unknown | bid | 565.5300 | 9.1000 | ["430"] | ["0.3899"] | [] | ["XBOX"] | 430.0000 | 430.0000 | 819 | 854 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:16:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f2-c993-7020-adf5-c0c78d92faaf | SMH | 2026-09-17 15:58 | call_calendar | 2 | 1 | 3 | 220500.00 | unknown | — | 560.9200 | 6.5000 | ["195"] | ["3.7978"] | [] | ["XPHO"] | 195.0000 | 195.0000 | 1 | 183 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe0-4053-7532-b36e-270ef5ec8ab1 | SMH | 2026-09-17 10:58 | call_calendar | 2 | 1 | 10 | 139170.00 | short | ask | 559.5100 | 5.4000 | ["490"] | ["0.6267"] | [] | ["XCBO"] | 490.0000 | 490.0000 | 6 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:58:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abca-2f5b-7232-a945-0a74dca51b36 | SMH | 2026-09-16 15:55 | call_calendar | 2 | 1 | 2 | 48544.00 | long | bid | 544.4400 | 6.5000 | ["425"] | ["0.6670"] | [] | ["XCBO"] | 425.0000 | 425.0000 | 9 | 30 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:55:53Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abc8-991b-7252-afbf-cbf845a72e87 | SMH | 2026-09-16 15:54 | call_calendar | 2 | 1 | 2 | 68358.00 | long | ask | 544.0200 | 5.1500 | ["375"] | ["0.9778"] | [] | ["EDGO"] | 375.0000 | 375.0000 | 9 | 30 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:54:14Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a0a3-e030-7590-80e5-fb9b597e981b | SMH | 2026-09-14 11:58 | call_calendar | 2 | 1 | 10 | 110200.00 | short | bid | 544.2100 | 4.6500 | ["490"] | ["0.5209"] | [] | ["XCBO"] | 490.0000 | 490.0000 | 4 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:58:32Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08a-7460-7f30-882a-891572ece4fa | SMH | 2026-09-14 11:30 | call_calendar | 2 | 1 | 6 | 86682.00 | short | bid | 542.5000 | 3.2000 | ["600"] | ["0.3554"] | [] | ["XCBO"] | 600.0000 | 600.0000 | 123 | 823 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:30:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0920a-0591-7cf3-a3d3-0be5495616d5 | SMH | 2026-09-11 15:55 | call_calendar | 2 | 1 | 8 | 31088.00 | short | bid | 568.1800 | 5.1500 | ["550"] | ["3.7184"] | [] | ["XCBO"] | 550.0000 | 550.0000 | 0 | 5 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:55:30Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0910a-b631-7b13-8f84-bf0469ac1962 | SMH | 2026-09-11 11:16 | call_calendar | 2 | 1 | 7 | 112707.00 | long | ask | 570.5700 | 4.4000 | ["490"] | ["0.6822"] | [] | ["XCBO"] | 490.0000 | 490.0000 | 5 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:16:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bab-c9b8-78b1-be65-7b95ba11b88f | SMH | 2026-09-10 10:14 | call_calendar | 2 | 2 | 69 | 226330.00 | short | ask | 559.5750 | 0.9000 | ["565"] | ["0.3547"] | [] | ["XBOX","XISX"] | 565.0000 | 565.0000 | 8 | 36 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:15:03Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba7-4190-7fc2-bfb4-c5014f7ec238 | SMH | 2026-09-10 10:09 | call_calendar | 2 | 1 | 100 | 333200.00 | short | bid | 559.6900 | 1.2500 | ["565"] | ["0.3598"] | [] | ["XISX"] | 565.0000 | 565.0000 | 8 | 36 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:09:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08694-c768-7a32-85d1-d52f6ba760b2 | SMH | 2026-09-09 10:31 | call_calendar | 2 | 1 | 500 | 390455.00 | unknown | — | 575.9200 | 0.7800 | ["600"] | ["0.3521"] | [] | ["XCBO"] | 600.0000 | 600.0000 | 7 | 9 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:31:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08260-64b8-7803-86f3-1d5764e9e250 | SMH | 2026-09-08 14:55 | call_calendar | 2 | 1 | 8 | 40392.00 | long | ask | 574.7100 | 5.9500 | ["550"] | ["1.8574"] | [] | ["XCBO"] | 550.0000 | 550.0000 | 0 | 3 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:55:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |