Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a086a2-fc21-7401-8c41-1926b22b3023 | CSCO | 2026-09-09 10:47 | call_diagonal_spread | 2 | 4 | 228 | 306509.00 | long | ask | 109.8400 | 0.8500 | ["103","105"] | ["0.3024","0.5351"] | [] | ["AMXO","EDGO","XCBO","XISX"] | 103.0000 | 105.0000 | 2 | 30 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:47:31Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b0-aff0-72a1-beb3-440b0d9ef315 | CSCO | 2026-09-09 11:01 | call_diagonal_spread | 2 | 1 | 250 | 276500.00 | long | ask | 109.9000 | 0.4000 | ["115","120"] | ["0.3721","0.3431"] | [] | ["C2OX"] | 115.0000 | 120.0000 | 72 | 128 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:02:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086be-5fd8-74f2-a58e-da935fdae5dc | CSCO | 2026-09-09 11:16 | call_diagonal_spread | 2 | 1 | 190 | 202540.00 | long | ask | 109.6200 | 0.3500 | ["115","120"] | ["0.3675","0.3399"] | [] | ["XPHO"] | 115.0000 | 120.0000 | 72 | 128 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:17:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e9-bd68-7b23-b58d-bbb1222b23c8 | CSCO | 2026-09-09 12:04 | call_diagonal_spread | 2 | 1 | 72 | 129528.00 | short | bid | 109.4700 | 1.1500 | ["100","105"] | ["0.3819","0.4705"] | [] | ["BATO"] | 100.0000 | 105.0000 | 2 | 72 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:04:25Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08b9b-9931-7e80-8fc1-5dd0dafbdc1e | CSCO | 2026-09-10 09:57 | call_diagonal_spread | 2 | 1 | 28 | 220192.00 | long | ask | 109.2600 | 3.1000 | ["70","72.5"] | ["1.8965","0.3040"] | [] | ["XISX"] | 70.0000 | 72.5000 | 8 | 280 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:57:06Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a09157-efb8-7833-a6b8-ffedda6e98d7 | CSCO | 2026-09-11 12:40 | call_diagonal_spread | 2 | 1 | 49 | 364266.00 | short | ask | 111.5150 | 4.5500 | ["72.5","80"] | ["0.5459","0.3091"] | [] | ["XCBO"] | 72.5000 | 80.0000 | 98 | 279 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:41:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09157-efb8-7833-a6b8-ffdd17fd08bf | CSCO | 2026-09-11 12:40 | call_diagonal_spread | 2 | 1 | 13 | 105586.00 | short | ask | 111.5150 | 5.6500 | ["70","75"] | ["0.6761","0.2496"] | [] | ["ARCO"] | 70.0000 | 75.0000 | 98 | 279 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:41:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a0de-d9d8-74c3-a942-ea4c6181f9d5 | CSCO | 2026-09-14 13:02 | call_diagonal_spread | 2 | 1 | 17 | 170476.00 | short | bid | 111.5950 | 5.2500 | ["65","70"] | ["0.2852","0.3286"] | [] | ["XMIO"] | 65.0000 | 70.0000 | 494 | 858 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:02:42Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a5d2-5d6e-7473-bf49-83949af83538 | CSCO | 2026-09-15 12:06 | call_diagonal_spread | 2 | 1 | 15 | 150465.00 | unknown | — | 110.6799 | 2.7500 | ["65","70"] | ["0.2883","0.3155"] | [] | ["XISX"] | 65.0000 | 70.0000 | 493 | 857 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:07:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a612-dd26-7bd0-a297-b6c823431ae6 | CSCO | 2026-09-15 13:17 | call_diagonal_spread | 2 | 1 | 39 | 210210.00 | unknown | — | 109.9500 | 3.2000 | ["85","87.5"] | ["0.4283","0.3848"] | [] | ["MCRY"] | 85.0000 | 87.5000 | 94 | 185 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:18:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a622-65b6-7781-89ac-f217312f801d | CSCO | 2026-09-15 13:34 | call_diagonal_spread | 2 | 12 | 100 | 129750.00 | long | ask | 110.2600 | 0.4000 | ["105","110"] | ["0.4182","0.3733"] | [] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 105.0000 | 110.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:34:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa7b-2da3-79e0-98e3-d45c4b1df500 | CSCO | 2026-09-16 09:49 | call_diagonal_spread | 2 | 1 | 12 | 102444.00 | long | ask | 110.7400 | 2.1500 | ["75","80"] | ["0.3121","0.3200"] | [] | ["MCRY"] | 75.0000 | 80.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:50:06Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab74-3f5b-7812-956a-bb155db28e36 | CSCO | 2026-09-16 14:21 | call_diagonal_spread | 2 | 1 | 10 | 106200.00 | unknown | — | 110.2500 | 4.5000 | ["60","65"] | ["0.3314","0.2742"] | [] | ["MCRY"] | 60.0000 | 65.0000 | 492 | 821 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:22:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abc7-d9b3-7471-9b88-56738037bb8c | CSCO | 2026-09-16 15:53 | call_diagonal_spread | 2 | 1 | 120 | 313460.00 | long | bid | 107.7900 | 2.1000 | ["95","100"] | ["1.1883","0.3755"] | [] | ["XCBO"] | 95.0000 | 100.0000 | 2 | 93 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:53:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afa9-1353-7ed1-8b98-c4b1bcd67757 | CSCO | 2026-09-17 09:58 | call_diagonal_spread | 2 | 1 | 30 | 141300.00 | unknown | — | 109.6650 | 3.9000 | ["82.5","90"] | ["2.5565","0.5791"] | [] | ["XCBO"] | 82.5000 | 90.0000 | 1 | 29 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:58:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b5a9-e8bf-7621-8dce-36a8060e83b9 | CSCO | 2026-09-18 13:56 | call_diagonal_spread | 2 | 1 | 69 | 143520.00 | unknown | bid | 108.8400 | 2.1000 | ["97.5","98"] | ["4.9676","0.5205"] | [] | ["XBOX"] | 97.5000 | 98.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:56:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5bf-9787-70a0-bb80-5f977ae1f864 | CSCO | 2026-09-18 14:20 | call_diagonal_spread | 2 | 1 | 10 | 104000.00 | long | bid | 108.9985 | 1.1000 | ["57.5","60"] | ["0.6334","0.4898"] | [] | ["XCBO"] | 57.5000 | 60.0000 | 119 | 455 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:20:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ff-05cf-7053-8db0-6568ce0a8fca | CSCO | 2026-09-18 15:29 | call_diagonal_spread | 2 | 1 | 203 | 246645.00 | unknown | bid | 108.8500 | 0.2500 | ["105","110"] | ["0.2677","0.3691"] | [] | ["XCBO"] | 105.0000 | 110.0000 | 28 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:30:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ff-05cf-7053-8db0-6551c30c55cb | CSCO | 2026-09-18 15:29 | call_diagonal_spread | 2 | 1 | 205 | 249075.00 | unknown | bid | 108.8500 | 0.2500 | ["105","110"] | ["0.2677","0.3691"] | [] | ["XCBO"] | 105.0000 | 110.0000 | 28 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:30:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ff-05cf-7053-8db0-654fc6adb650 | CSCO | 2026-09-18 15:29 | call_diagonal_spread | 2 | 1 | 187 | 227579.00 | short | bid | 108.8500 | 0.2500 | ["105","110"] | ["0.2687","0.3696"] | [] | ["AMXO"] | 105.0000 | 110.0000 | 28 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:30:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ff-05cf-7053-8db0-652bb398fdaf | CSCO | 2026-09-18 15:29 | call_diagonal_spread | 2 | 2 | 410 | 499790.00 | short | bid | 108.8500 | 0.2500 | ["105","110"] | ["0.2721","0.3688"] | [] | ["AMXO","XISX"] | 105.0000 | 110.0000 | 28 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:30:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c98c-796f-75e3-ae41-b1a2214984d5 | CSCO | 2026-09-22 10:36 | call_diagonal_spread | 2 | 1 | 85 | 380970.00 | long | bid | 107.1200 | 2.6500 | ["80","110"] | ["0.4235","0.3504"] | [] | ["SPHR"] | 80.0000 | 110.0000 | 115 | 360 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:37:19Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca6b-7377-7d73-957f-7505ba5beb3f | CSCO | 2026-09-22 14:40 | call_diagonal_spread | 2 | 1 | 55 | 313326.00 | unknown | ask | 105.4700 | 3.2000 | ["65","100"] | ["2.6450","0.3323"] | [] | ["XMIO"] | 65.0000 | 100.0000 | 3 | 850 | true | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:41:03Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca86-d347-7a61-a8b0-88f49905d1f7 | CSCO | 2026-09-22 15:10 | call_diagonal_spread | 2 | 1 | 20 | 200140.00 | long | ask | 105.7750 | 4.4500 | ["57.5","60"] | ["0.6639","0.2692"] | [] | ["XMIO"] | 57.5000 | 60.0000 | 115 | 850 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:10:38Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |