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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 01a0aa94-570c-77a1-8b22-70e590ee3bbe | CSCO | 2026-09-16 10:17 | risk_reversal | 2 | 1 | 46 | 101798.00 | long | bid | 110.7200 | 1.0500 | ["100","140"] | ["0.3946","0.3505"] | ["99.55"] | ["XMIO"] | 100.0000 | 140.0000 | 492 | 492 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:17:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 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 |
| 01a0a046-eb51-70e2-ac35-82ec13c84559 | CSCO | 2026-09-14 10:16 | call_vertical_spread | 2 | 1 | 20 | 216540.00 | short | bid | 110.8300 | 2.7500 | ["55","57.5"] | ["3.4903","2.9454"] | ["57.49"] | ["AMXO"] | 55.0000 | 57.5000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:16:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09113-0b00-7bf1-b22d-f9fbf08069ba | CSCO | 2026-09-11 11:25 | call_vertical_spread | 2 | 1 | 10 | 144010.00 | short | bid | 111.2800 | 3.6500 | ["37.5","40"] | ["4.3718","3.4808"] | ["39.99"] | ["XCBO"] | 37.5000 | 40.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:25:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c76-0728-73c2-a475-0db19ce87c4e | CSCO | 2026-09-10 13:55 | call_vertical_spread | 2 | 1 | 14 | 113274.00 | short | bid | 108.0100 | 1.2000 | ["65","70"] | ["4.8677","4.5625"] | ["69.99"] | ["XCBO"] | 65.0000 | 70.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:56:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0e-7b58-76d2-978e-c46a9cfada9b | CSCO | 2026-09-10 12:02 | put_calendar | 2 | 1 | 100 | 143300.00 | short | bid | 108.7700 | 0.6500 | ["115"] | ["0.3270"] | [] | ["SPHR"] | 115.0000 | 115.0000 | 8 | 36 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:02:36Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 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 |
| 01a08237-0ac8-70d1-a560-a3f715358ad4 | CSCO | 2026-09-08 14:10 | call_vertical_spread | 2 | 1 | 15 | 221835.00 | short | bid | 108.7650 | 1.2500 | ["32.5","37.5"] | ["3.2785","2.9229"] | ["37.49"] | ["AMXO"] | 32.5000 | 37.5000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:11:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |