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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b613-688f-73e3-a0b5-e816750b4ac4 | JPM | 2026-09-18 15:51 | call_vertical_spread | 2 | 5 | 590 | 710950.00 | long | ask | 348.4450 | 2.3000 | ["400","430"] | ["0.2313","0.2267"] | ["404.85"] | ["ARCO","EMLD","SPHR","XISX"] | 400.0000 | 430.0000 | 182 | 182 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:52:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a686-2cae-7951-8607-6f37019de36f | JPM | 2026-09-15 15:23 | call_vertical_spread | 2 | 1 | 600 | 267600.00 | short | bid | 353.1750 | 0.6100 | ["375","385"] | ["0.2390","0.2395"] | ["376.50"] | ["XMIO"] | 375.0000 | 385.0000 | 31 | 31 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:23:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a625-1d06-7bf3-9d98-104a1277ddd3 | JPM | 2026-09-15 13:37 | call_vertical_spread | 2 | 1 | 68 | 555084.00 | unknown | — | 345.2100 | 3.8500 | ["310","320"] | ["0.2467","0.2442"] | [] | ["XISX"] | 310.0000 | 320.0000 | 122 | 122 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:37:56Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a546-f205-7a43-9b31-6a2c3535d5d0 | JPM | 2026-09-15 09:34 | call_vertical_spread | 2 | 1 | 307 | 104073.00 | unknown | — | 348.8350 | 0.8200 | ["375","385"] | ["0.2437","0.2463"] | [] | ["XMIO"] | 375.0000 | 385.0000 | 31 | 31 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:34:48Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a103-a7b8-7410-a258-3de92143d74b | JPM | 2026-09-14 13:42 | call_vertical_spread | 2 | 2 | 32 | 131152.00 | long | ask | 348.5300 | 5.2000 | ["450","540"] | ["0.2422","0.2424"] | ["465.02"] | ["ARCO","C2OX"] | 450.0000 | 540.0000 | 823 | 823 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:42:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0915d-b060-71f2-8bb3-d3670a237980 | JPM | 2026-09-11 12:47 | call_vertical_spread | 2 | 1 | 50 | 248000.00 | long | ask | 357.2400 | 5.3500 | ["330","335"] | ["0.4120","0.4769"] | ["334.90"] | ["XISX"] | 330.0000 | 335.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:47:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c5-3538-7ca0-a008-e0c0a4adf393 | JPM | 2026-09-11 10:00 | call_vertical_spread | 2 | 1 | 367 | 248092.00 | unknown | — | 358.7850 | 1.3600 | ["375","385"] | ["0.2245","0.2248"] | [] | ["XISX"] | 375.0000 | 385.0000 | 35 | 35 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:00:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c24-5ce9-7721-a873-6fba6079ce96 | JPM | 2026-09-10 12:26 | call_vertical_spread | 2 | 1 | 27 | 101466.00 | short | bid | 352.5200 | 0.9500 | ["370","375"] | ["0.2410","0.2398"] | ["372"] | ["XMIO"] | 370.0000 | 375.0000 | 190 | 190 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:27:11Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08137-4e08-7fe1-a221-2ce3ea395bd9 | JPM | 2026-09-08 09:31 | call_vertical_spread | 2 | 3 | 160 | 114240.00 | unknown | — | 355.3700 | 2.1900 | ["375","385"] | ["0.2434","0.2436"] | [] | ["XCBO","XPHO"] | 375.0000 | 385.0000 | 38 | 38 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:31:20Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06da7-b51d-7253-8e04-1b0907331a8d | JPM | 2026-09-04 14:21 | call_vertical_spread | 2 | 2 | 159 | 128154.00 | unknown | — | 359.2250 | 0.4400 | ["375","385"] | ["0.2188","0.2169"] | [] | ["XISX"] | 375.0000 | 385.0000 | 42 | 42 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:21:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d55-c48d-7340-b87c-01c63548d705 | JPM | 2026-09-04 12:52 | call_vertical_spread | 2 | 2 | 50 | 128198.00 | long | ask | 358.4550 | 4.0260 | ["342.5","347.5"] | ["1.6926","1.2244"] | ["347.49"] | ["C2OX","XPHO"] | 342.5000 | 347.5000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:52:22Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |