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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08149-c0b1-7291-adea-3dc18e65cc3a | QCOM | 2026-09-08 09:51 | call_diagonal_spread | 2 | 1 | 75 | 148575.00 | short | bid | 177.4600 | 1.2000 | ["170","180"] | ["0.7772","0.4867"] | [] | ["XMIO"] | 170.0000 | 180.0000 | 3 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:51:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08670-bcd8-7192-b0bd-ce2f8117569c | QCOM | 2026-09-09 09:52 | call_diagonal_spread | 2 | 2 | 80 | 153200.00 | long | ask | 175.8300 | 1.6000 | ["170","180"] | ["0.5205","0.4739"] | [] | ["XISX"] | 170.0000 | 180.0000 | 9 | 44 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:52:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08bd9-dab0-7990-920b-8b5ff495f080 | QCOM | 2026-09-10 11:05 | call_diagonal_spread | 2 | 1 | 300 | 147000.00 | short | bid | 176.5200 | 0.5200 | ["177.5","182.5"] | ["0.6768","0.4963"] | [] | ["BATO"] | 177.5000 | 182.5000 | 1 | 8 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:05:15Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bde-4f50-77e2-acd4-a368f07295f4 | QCOM | 2026-09-10 11:09 | call_diagonal_spread | 2 | 1 | 277 | 147087.00 | short | bid | 177.0400 | 0.2900 | ["177.5","182.5"] | ["0.6740","0.4961"] | [] | ["XISX"] | 177.5000 | 182.5000 | 1 | 8 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:09:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0912a-f418-7692-b547-9f2b39f3045e | QCOM | 2026-09-11 11:51 | call_diagonal_spread | 2 | 1 | 60 | 163920.00 | short | bid | 183.8750 | 1.0000 | ["175","185"] | ["0.4941","0.5156"] | [] | ["BATO"] | 175.0000 | 185.0000 | 7 | 70 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:51:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a575-c64e-7333-904b-37df10248b2b | QCOM | 2026-09-15 10:25 | call_diagonal_spread | 2 | 3 | 138 | 245906.00 | short | bid | 187.5700 | 0.9000 | ["190","210"] | ["0.4927","0.5313"] | [] | ["ARCO","EDGO","XISX"] | 190.0000 | 210.0000 | 24 | 66 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60e-ce16-71a0-b92b-c11a6a1317d3 | QCOM | 2026-09-15 13:13 | call_diagonal_spread | 2 | 1 | 300 | 441000.00 | unknown | — | 188.1150 | 0.8500 | ["182.5","190"] | ["0.5863","0.4949"] | [] | ["XBOX"] | 182.5000 | 190.0000 | 3 | 17 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:13:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a624-4dfe-7833-b120-0061e852b99c | QCOM | 2026-09-15 13:36 | call_diagonal_spread | 2 | 1 | 59 | 228684.00 | short | bid | 188.8500 | 1.0500 | ["170","185"] | ["0.7437","0.5333"] | [] | ["EDGO"] | 170.0000 | 185.0000 | 3 | 66 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:36:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-1105-7562-b4e9-94eab3d1e4a5 | QCOM | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 79 | 155156.00 | long | bid | 187.6950 | 1.4000 | ["175","200"] | ["0.6150","0.5010"] | [] | ["XMIO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:56:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-14ee-7c92-8661-cd06c811028a | QCOM | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 79 | 155314.00 | long | bid | 187.7490 | 1.1500 | ["175","200"] | ["0.6121","0.4990"] | [] | ["EDGO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:56:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-e7dd-76c1-b26b-5a80af92bae0 | QCOM | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 158 | 315210.00 | short | ask | 187.8250 | 0.8000 | ["175","200"] | ["0.6488","0.5030"] | [] | ["EDGO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a5-97a6-73a0-8dd1-384902e5f3a1 | QCOM | 2026-09-15 15:57 | call_diagonal_spread | 2 | 2 | 158 | 314578.00 | unknown | — | 187.7700 | 0.6250 | ["175","200"] | ["0.6484","0.5045"] | [] | ["EDGO","XMIO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a6-4b56-7c61-b4e4-4f8fce2d10af | QCOM | 2026-09-15 15:58 | call_diagonal_spread | 2 | 1 | 78 | 154206.00 | short | ask | 187.6600 | 0.5000 | ["175","200"] | ["0.6479","0.5045"] | [] | ["EDGO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:58:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a6-4b56-7c61-b4e4-4f7002ea021f | QCOM | 2026-09-15 15:58 | call_diagonal_spread | 2 | 1 | 79 | 156025.00 | long | bid | 187.6600 | 0.6000 | ["175","200"] | ["0.6478","0.5036"] | [] | ["XMIO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:58:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a7-1676-7cf2-a922-3a5e7dc1ed01 | QCOM | 2026-09-15 15:59 | call_diagonal_spread | 2 | 1 | 157 | 310389.00 | short | ask | 187.7900 | 0.7000 | ["175","200"] | ["0.6198","0.5008"] | [] | ["EDGO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:59:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0afcb-4d0b-7533-a8db-742c6ce57eb2 | QCOM | 2026-09-17 10:35 | call_diagonal_spread | 2 | 1 | 79 | 121660.00 | short | bid | 191.1000 | 0.7000 | ["185","195"] | ["0.7088","0.4667"] | [] | ["ARCO"] | 185.0000 | 195.0000 | 1 | 29 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:35:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4ce-368f-7a90-b32d-f2e33d85edbe | QCOM | 2026-09-18 09:56 | call_diagonal_spread | 2 | 1 | 40 | 106280.00 | long | bid | 184.5400 | 0.8500 | ["170","180"] | ["1.2899","0.4600"] | [] | ["AMXO"] | 170.0000 | 180.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:57:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cf-8297-7b53-9ac3-763369d391be | QCOM | 2026-09-18 09:58 | call_diagonal_spread | 2 | 1 | 75 | 189825.00 | short | bid | 184.4700 | 1.0000 | ["180","190"] | ["0.4581","0.4983"] | [] | ["XISX"] | 180.0000 | 190.0000 | 28 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:58:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d0-690f-7d52-854a-49f1a661645b | QCOM | 2026-09-18 09:59 | call_diagonal_spread | 2 | 1 | 35 | 140000.00 | short | bid | 183.8550 | 5.7500 | ["165","170"] | ["3.1526","0.4926"] | [] | ["AMXO"] | 165.0000 | 170.0000 | 0 | 42 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |