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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b614-9557-7e82-a0d2-83367b2971e5 | JPM | 2026-09-18 15:53 | call_diagonal_spread | 2 | 1 | 10 | 109440.00 | long | bid | 348.5124 | 5.1000 | ["300","330"] | ["0.2457","0.2323"] | [] | ["XMIO"] | 300.0000 | 330.0000 | 182 | 364 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:53:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b606-221f-75c2-95e9-05d91a37d8bc | JPM | 2026-09-18 15:37 | call_diagonal_spread | 2 | 1 | 22 | 114290.00 | long | ask | 347.2200 | 4.6500 | ["325","330"] | ["7.4977","0.2493"] | [] | ["XISX"] | 325.0000 | 330.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:37:35Z"} | 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 |
| 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 |
| 01a0b0db-1b13-7af0-b350-742e7a304e6a | JPM | 2026-09-17 15:32 | call_diagonal_spread | 2 | 1 | 4 | 180176.00 | unknown | — | 349.3850 | 7.0000 | ["105","145"] | ["1.0448","0.5383"] | [] | ["XPHO"] | 105.0000 | 145.0000 | 120 | 273 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a0a680-ecee-7bc0-9f27-24e275b6c878 | JPM | 2026-09-15 15:17 | call_diagonal_spread | 2 | 1 | 15 | 124800.00 | unknown | — | 352.4750 | 6.4000 | ["310","320"] | ["1.1088","0.2514"] | [] | ["XISX"] | 310.0000 | 320.0000 | 3 | 94 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:17:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5fd-6cde-7700-91e0-232ab3eee1e6 | JPM | 2026-09-15 12:54 | call_diagonal_spread | 2 | 1 | 14 | 196000.00 | unknown | — | 344.7000 | 3.7000 | ["300","340"] | ["0.2291","0.2207"] | [] | ["MCRY"] | 300.0000 | 340.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:54:06Z"} | 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 |
| 01a0a54f-df2e-7a53-bf9c-66202d91ef4c | JPM | 2026-09-15 09:44 | call_diagonal_spread | 2 | 1 | 10 | 246220.00 | long | bid | 349.8500 | 6.7500 | ["225","230"] | ["0.4688","0.4270"] | [] | ["XMIO"] | 225.0000 | 230.0000 | 66 | 94 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:44:44Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a170-b1c8-7192-824f-283c3d00cb94 | JPM | 2026-09-14 15:41 | call_diagonal_spread | 2 | 5 | 95 | 211602.00 | long | ask | 350.0175 | 1.7374 | ["345","350"] | ["0.2831","0.2304"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 345.0000 | 350.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:41:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a158-ff61-7902-8758-18e4a5859af6 | JPM | 2026-09-14 15:15 | call_diagonal_spread | 2 | 7 | 291 | 211058.00 | long | ask | 350.3501 | 0.6500 | ["365","370"] | ["0.2647","0.2246"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"] | 365.0000 | 370.0000 | 4 | 67 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:16: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 |
| 01a0a090-aa38-7b41-bf44-3dbc2e74574a | JPM | 2026-09-14 11:37 | call_diagonal_spread | 2 | 1 | 18 | 369630.00 | long | bid | 350.6282 | 6.7500 | ["250","270"] | ["0.3151","0.2661"] | [] | ["XISX"] | 250.0000 | 270.0000 | 123 | 494 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:37:19Z"} | 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 |
| 01a09179-9500-7632-adcb-70c66a4d6f6d | JPM | 2026-09-11 13:17 | call_diagonal_spread | 2 | 2 | 104 | 506688.00 | long | ask | 356.4650 | 4.7000 | ["335","340"] | ["0.3705","0.2409"] | [] | ["ARCO"] | 335.0000 | 340.0000 | 7 | 70 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:17:55Z"} | 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 |
| 01a08b99-4f40-7d32-a3b2-23b35ce85976 | JPM | 2026-09-10 09:54 | call_diagonal_spread | 2 | 1 | 10 | 100050.00 | unknown | — | 351.5700 | 6.0500 | ["300","350"] | ["0.6159","0.2510"] | [] | ["XISX"] | 300.0000 | 350.0000 | 8 | 463 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:54:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 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 |