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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08279-d858-74c3-b24e-a39a87147032 | JCI | 2026-09-08 15:23 | other | 2 | 1 | 12 | 191160.00 | unknown | — | 146.5000 | 8.0000 | ["65","70"] | ["0.9228","0.6924"] | [] | ["EDGO"] | 65.0000 | 70.0000 | 129 | 192 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:23:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a090ce-87f0-7e83-baf1-407e4a079750 | JCI | 2026-09-11 10:10 | call_diagonal_spread | 2 | 2 | 27 | 131922.00 | short | ask | 145.3950 | 6.3000 | ["120","130"] | ["0.5193","0.3262"] | [] | ["ARCO"] | 120.0000 | 130.0000 | 35 | 189 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:10:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09157-efb8-7833-a6b8-fe4ecdcb6113 | JCI | 2026-09-11 12:40 | call_diagonal_spread | 2 | 1 | 21 | 267393.00 | short | ask | 145.7300 | 4.5000 | ["82.5","85"] | ["0.6096","0.3512"] | [] | ["XISX"] | 82.5000 | 85.0000 | 126 | 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 |
| 01a0b4ea-a000-7b31-b4c6-2d83da82fba8 | JCI | 2026-09-18 10:27 | call_diagonal_spread | 2 | 1 | 53 | 586657.00 | short | ask | 141.4500 | 3.0000 | ["85","90"] | ["0.6031","0.2975"] | [] | ["XISX"] | 85.0000 | 90.0000 | 91 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:27:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4eb-058f-74e2-a82e-1fb5b527af30 | JCI | 2026-09-18 10:28 | call_diagonal_spread | 2 | 1 | 200 | 2213800.00 | short | ask | 141.3750 | 3.0000 | ["85","90"] | ["0.6175","0.3222"] | [] | ["XISX"] | 85.0000 | 90.0000 | 91 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:28:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ed-ff47-7f00-8b06-36b04dcb6682 | JCI | 2026-09-18 10:31 | call_diagonal_spread | 2 | 2 | 6100 | 67472100.00 | short | ask | 141.5600 | 3.0000 | ["85","90"] | ["0.5796","0.4111"] | [] | ["XCBO"] | 85.0000 | 90.0000 | 91 | 182 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:31:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-4bd7-7973-90da-18f646c0d1ab | JCI | 2026-09-18 10:59 | call_diagonal_spread | 2 | 1 | 47 | 432165.00 | short | ask | 141.6700 | 3.7000 | ["95","100"] | ["0.4882","0.3255"] | [] | ["XISX"] | 95.0000 | 100.0000 | 91 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-a1c8-7f61-8e6e-08e83849b8e7 | JCI | 2026-09-18 10:59 | call_diagonal_spread | 2 | 1 | 50 | 460050.00 | short | ask | 141.7100 | 3.2000 | ["95","100"] | ["0.4810","0.3246"] | [] | ["XISX"] | 95.0000 | 100.0000 | 91 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50b-08df-7303-b7d3-1848b1cda423 | JCI | 2026-09-18 11:03 | call_diagonal_spread | 2 | 3 | 1000 | 9163000.00 | long | bid | 141.4900 | 1.2000 | ["95","100"] | ["0.4638","0.3213"] | [] | ["XCBO"] | 95.0000 | 100.0000 | 91 | 182 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:03:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b513-a017-7be2-a7bf-66115e21187e | JCI | 2026-09-18 11:12 | call_diagonal_spread | 2 | 1 | 94 | 769860.00 | unknown | — | 141.3850 | 3.8000 | ["100","105"] | ["0.4137","0.2628"] | [] | ["ARCO"] | 100.0000 | 105.0000 | 91 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:12:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b616-e717-7552-bcf6-09e87886fdd2 | JCI | 2026-09-18 15:55 | call_diagonal_spread | 2 | 1 | 33 | 115170.00 | long | bid | 143.2800 | 5.6000 | ["125","130"] | ["0.4676","0.3314"] | [] | ["XMIO"] | 125.0000 | 130.0000 | 28 | 63 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:56:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |