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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60f-9030-7850-a116-6f9d1fe0c4bb | JPM | 2026-09-18 15:47 | call_vertical_spread | 2 | 1 | 50 | 471000.00 | short | bid | 347.4750 | 5.7000 | ["380","390"] | ["0.2251","0.2271"] | ["383.50"] | ["SPHR"] | 380.0000 | 390.0000 | 819 | 819 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c2-4320-7a50-a347-c093829f45a7 | JPM | 2026-09-18 14:23 | call_calendar | 2 | 1 | 30 | 166170.00 | short | ask | 348.2800 | 3.4500 | ["450"] | ["0.2254"] | [] | ["XCBO"] | 450.0000 | 450.0000 | 819 | 854 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:23:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b579-6e97-7520-8d22-2d1bf578562f | JPM | 2026-09-18 13:03 | strangle | 2 | 1 | 500 | 569000.00 | short | bid | 347.1600 | 0.6500 | ["335","355"] | ["0.2839","0.2324"] | ["323.62","366.38"] | ["XPHO"] | 335.0000 | 355.0000 | 28 | 28 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:03:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56d-ba7f-7483-ae46-1a7ca2620727 | JPM | 2026-09-18 12:50 | call_diagonal_spread | 2 | 1 | 82 | 122580.00 | short | bid | 346.8650 | 1.2500 | ["340","350"] | ["0.5302","0.2354"] | [] | ["XCBO"] | 340.0000 | 350.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:51:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-d710-7b83-aae7-0c0b47632872 | JPM | 2026-09-18 11:10 | call_diagonal_spread | 2 | 1 | 9 | 204975.00 | short | ask | 346.9550 | 2.5000 | ["230","240"] | ["0.4862","0.4476"] | [] | ["XCBO"] | 230.0000 | 240.0000 | 91 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:10:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fb-41cf-7112-a4d1-df58f6f720c7 | JPM | 2026-09-18 10:45 | call_diagonal_spread | 2 | 1 | 10 | 167310.00 | short | ask | 346.6000 | 6.8000 | ["260","270"] | ["0.4224","0.2488"] | [] | ["ARCO"] | 260.0000 | 270.0000 | 63 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:46:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b081-9ceb-7393-94c9-17a23a92dced | JPM | 2026-09-17 13:54 | call_diagonal_spread | 2 | 1 | 10 | 233720.00 | short | ask | 349.5000 | 5.0500 | ["230","240"] | ["3.8394","0.2786"] | [] | ["XMIO"] | 230.0000 | 240.0000 | 1 | 183 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:55:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afbe-aaab-7cf2-936d-0592f2930a91 | JPM | 2026-09-17 10:21 | call_diagonal_spread | 2 | 1 | 25 | 152000.00 | short | bid | 346.6800 | 2.3500 | ["325","330"] | ["0.2532","0.2478"] | [] | ["XCBO"] | 325.0000 | 330.0000 | 64 | 120 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:21:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afbb-c47b-7841-9159-0623826f06eb | JPM | 2026-09-17 10:18 | put_vertical_spread | 2 | 1 | 10 | 112360.00 | short | bid | 346.0950 | 4.3000 | ["380","390"] | ["0.2945","0.2977"] | ["383.70"] | ["XMIO"] | 380.0000 | 390.0000 | 491 | 491 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:18:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aaef-e48b-74a0-9601-7be3a75dc134 | JPM | 2026-09-16 11:57 | straddle | 2 | 1 | 150 | 1615500.00 | short | bid | 351.8099 | 2.7500 | ["350"] | ["0.2614"] | ["242.30","457.70"] | ["AMXO"] | 350.0000 | 350.0000 | 821 | 821 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:57:36Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae0-5043-7ca2-aacd-4d22ecd20134 | JPM | 2026-09-16 11:40 | put_calendar | 2 | 2 | 224 | 313152.00 | short | bid | 350.3100 | 0.8500 | ["350"] | ["0.3112"] | [] | ["ARCO"] | 350.0000 | 350.0000 | 2 | 30 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:41:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa92-9da3-77d0-bb19-810c69e0c9af | JPM | 2026-09-16 10:15 | put_vertical_spread | 2 | 1 | 10 | 107280.00 | short | bid | 350.3500 | 3.9500 | ["380","390"] | ["0.2903","0.2926"] | ["383.96"] | ["BATO"] | 380.0000 | 390.0000 | 492 | 492 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:15:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa91-befb-7263-ae39-788fb1d1b45f | JPM | 2026-09-16 10:14 | put_calendar | 2 | 1 | 300 | 978000.00 | short | ask | 350.3500 | 3.5500 | ["300"] | ["0.2996"] | [] | ["XBOX"] | 300.0000 | 300.0000 | 184 | 856 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:14:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 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 |
| 01a0a5ec-bb6e-7353-ab47-c1d04fe8e755 | JPM | 2026-09-15 12:35 | call_diagonal_spread | 2 | 2 | 18 | 130601.00 | short | bid | 344.9400 | 1.7500 | ["310","340"] | ["0.6156","0.2460"] | [] | ["EDGO"] | 310.0000 | 340.0000 | 3 | 275 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:35:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e6-4ee6-74a3-a412-d245c116851e | JPM | 2026-09-15 12:28 | call_calendar | 2 | 1 | 9 | 218970.00 | short | bid | 344.7200 | 6.2000 | ["225"] | ["0.4456"] | [] | ["XPHO"] | 225.0000 | 225.0000 | 94 | 185 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:29:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a596-5256-7fe2-85f7-93d40238c44a | JPM | 2026-09-15 11:01 | synthetic | 2 | 1 | 46 | 185702.00 | short | ask | 346.3250 | 0.6000 | ["350"] | ["0.2533"] | ["348.35"] | ["ARCO"] | 350.0000 | 350.0000 | 122 | 122 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:01:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a594-5a6e-74c2-a970-a76e77dbf1ab | JPM | 2026-09-15 10:59 | call_diagonal_spread | 2 | 2 | 6 | 118500.00 | short | ask | 346.6600 | 6.1000 | ["250","270"] | ["0.2824","0.2238"] | [] | ["XCBO","XPHO"] | 250.0000 | 270.0000 | 122 | 493 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:59:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a594-5a6e-74c2-a970-a75002205be5 | JPM | 2026-09-15 10:59 | call_diagonal_spread | 2 | 2 | 20 | 395000.00 | short | ask | 346.6600 | 6.1000 | ["250","270"] | ["0.2996","0.2235"] | [] | ["XISX","XPHO"] | 250.0000 | 270.0000 | 122 | 493 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:59:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a167-b8e9-7081-b477-1976215f33c6 | JPM | 2026-09-14 15:32 | put_diagonal_spread | 2 | 5 | 96 | 207770.00 | short | bid | 349.2550 | 0.8271 | ["350","355"] | ["0.2858","0.2597"] | [] | ["ARCO","BATO","C2OX","EDGO","XBOX"] | 350.0000 | 355.0000 | 4 | 67 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:32:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a142-46f9-7431-8780-536c5a15c372 | JPM | 2026-09-14 14:51 | call_diagonal_spread | 2 | 1 | 5 | 115330.00 | short | bid | 350.2900 | 5.6000 | ["220","250"] | ["0.5384","1.7552"] | [] | ["EDGO"] | 220.0000 | 250.0000 | 4 | 67 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:52:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d2-a8c0-7142-a2c9-37a1e26dfef4 | JPM | 2026-09-14 12:49 | call_calendar | 2 | 1 | 9 | 282276.00 | short | ask | 352.8800 | 6.3500 | ["200"] | ["0.3993"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 123 | 494 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:49:32Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c3-b0b8-7d53-ab66-b5b9632d899c | JPM | 2026-09-14 12:32 | call_diagonal_spread | 2 | 1 | 15 | 179115.00 | short | ask | 352.3300 | 3.5000 | ["290","300"] | ["1.1343","0.2392"] | [] | ["XCBO"] | 290.0000 | 300.0000 | 4 | 95 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:32:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b6-6278-7bf1-baf9-ea03842f0305 | JPM | 2026-09-14 12:18 | call_calendar | 2 | 1 | 25 | 585575.00 | short | ask | 351.2800 | 5.5500 | ["235"] | ["1.2242"] | [] | ["XCBO"] | 235.0000 | 235.0000 | 4 | 67 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:18:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a07a-b909-7301-b93f-3c0d7f81776c | JPM | 2026-09-14 11:13 | call_calendar | 2 | 1 | 4 | 132740.00 | short | ask | 351.2450 | 5.6500 | ["190"] | ["0.5014"] | [] | ["MCRY"] | 190.0000 | 190.0000 | 123 | 494 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:13:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a068-4660-7fd2-b71e-7607883d4864 | JPM | 2026-09-14 10:53 | call_diagonal_spread | 2 | 1 | 16 | 135424.00 | short | bid | 350.9600 | 5.5000 | ["310","320"] | ["0.8781","0.2637"] | [] | ["ARCO"] | 310.0000 | 320.0000 | 4 | 123 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:53:20Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03a-c5f0-7993-8fb4-3dc029e25903 | JPM | 2026-09-14 10:03 | call_calendar | 2 | 1 | 36 | 180396.00 | short | ask | 352.6200 | 4.6000 | ["330"] | ["0.3757"] | [] | ["XCBO"] | 330.0000 | 330.0000 | 4 | 32 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:03:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09127-d350-7980-adb3-23ec896f59ea | JPM | 2026-09-11 11:48 | call_diagonal_spread | 2 | 1 | 8 | 105984.00 | short | bid | 357.0650 | 7.0000 | ["330","350"] | ["0.2487","0.2445"] | [] | ["EDGO"] | 330.0000 | 350.0000 | 497 | 826 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:48:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09104-12f8-7230-a3b3-bf12ea832a3a | JPM | 2026-09-11 11:09 | call_diagonal_spread | 2 | 1 | 17 | 158236.00 | short | bid | 355.9000 | 4.5500 | ["320","350"] | ["0.2459","0.2450"] | [] | ["XMIO"] | 320.0000 | 350.0000 | 98 | 462 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:09:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e8-6509-7a01-8c4c-cdcc88852763 | JPM | 2026-09-11 10:39 | call_calendar | 2 | 1 | 65 | 579800.00 | short | ask | 355.5800 | 5.1500 | ["315"] | ["0.3987"] | [] | ["XISX"] | 315.0000 | 315.0000 | 7 | 98 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:39:11Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c83-a388-7d21-8dca-dfa15833ad36 | JPM | 2026-09-10 14:10 | straddle | 2 | 2 | 250 | 546250.00 | short | bid | 352.6400 | 1.1000 | ["350"] | ["0.2461"] | ["328.15","371.85"] | ["AMXO"] | 350.0000 | 350.0000 | 36 | 36 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:11:03Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 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 |
| 01a08bce-fd70-7870-8abc-c4c163babd0c | JPM | 2026-09-10 10:53 | call_calendar | 2 | 1 | 17 | 655656.00 | short | bid | 352.7500 | 6.4500 | ["160"] | ["1.8978"] | [] | ["ARCO"] | 160.0000 | 160.0000 | 8 | 71 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:53:45Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b83-2452-7943-b4f0-fa940f317eda | JPM | 2026-09-10 09:30 | call_calendar | 2 | 1 | 10 | 325700.00 | short | ask | 353.8700 | 7.8000 | ["195"] | ["0.4829"] | [] | ["AMXO"] | 195.0000 | 195.0000 | 127 | 498 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:30:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08723-a1b8-7251-8f5b-84c2a1e0ddbb | JPM | 2026-09-09 13:07 | call_calendar | 2 | 1 | 156 | 138528.00 | short | bid | 355.0609 | 0.8000 | ["375"] | ["0.2342"] | [] | ["BATO"] | 375.0000 | 375.0000 | 37 | 44 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:08:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868c-cc70-7cc0-9997-dc6557e5b660 | JPM | 2026-09-09 10:22 | call_diagonal_spread | 2 | 1 | 10 | 173530.00 | short | bid | 353.6750 | 6.2500 | ["270","310"] | ["0.2970","0.2182"] | [] | ["XMIO"] | 270.0000 | 310.0000 | 100 | 828 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:23:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06db3-da7d-7c11-8e2c-ba3a0eb11c2f | JPM | 2026-09-04 14:34 | call_calendar | 2 | 1 | 10 | 109970.00 | short | ask | 359.3800 | 7.3500 | ["305"] | ["0.4912"] | [] | ["XISX"] | 305.0000 | 305.0000 | 21 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:35:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |