core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 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 |
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||||
| 01a0a6a4-2c5e-7133-8c32-a56580491e63 | JPM | 2026-09-15 15:56 | call_vertical_spread | 2 | 1 | 450 | 130818.00 | long | ask | 353.5700 | 0.5100 | ["357.5","362.5"] | ["0.2862","0.2828"] | ["358.76"] | ["XMIO"] | 357.5000 | 362.5000 | 3 | 3 | false | true | false | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0c98a-8d3f-7bf1-b5cb-0ab48b9bac3b | JPM | 2026-09-22 10:34 | call_vertical_spread | 2 | 8 | 100 | 165736.00 | unknown | bid | 340.0400 | 0.5500 | ["345","365"] | ["0.2390","0.2324"] | ["361.57"] | ["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 345.0000 | 365.0000 | 59 | 59 | false | true | false | ||||||||||
| 01a0c9dd-1627-7ed1-8e12-f9e4ee08ea1f | JPM | 2026-09-22 12:05 | call_vertical_spread | 2 | 1 | 15 | 184860.00 | long | ask | 339.4000 | 3.9500 | ["285","320"] | ["0.2362","0.2390"] | ["308.50"] | ["EDGO"] | 285.0000 | 320.0000 | 360 | 360 | false | false | false | ||||||||||
| 01a0c9de-ac67-7b30-8999-861241384646 | JPM | 2026-09-22 12:06 | call_vertical_spread | 2 | 1 | 140 | 1727600.00 | long | ask | 339.4800 | 1.6000 | ["285","320"] | ["0.2376","0.2384"] | ["308.70"] | ["XISX"] | 285.0000 | 320.0000 | 360 | 360 | true | false | false | ||||||||||
| 01a0ca01-3c0f-76c3-8ccf-2bf5b59c24e0 | JPM | 2026-09-22 12:44 | call_vertical_spread | 2 | 1 | 155 | 1922930.00 | long | ask | 340.0900 | 4.2000 | ["285","320"] | ["0.2352","0.2375"] | ["308.70"] | ["BATO"] | 285.0000 | 320.0000 | 360 | 360 | false | false | false | ||||||||||
| 01a0ca50-90a7-7d51-acd0-2cafd8c1b024 | JPM | 2026-09-22 14:11 | call_vertical_spread | 2 | 1 | 27 | 198720.00 | unknown | ask | 340.6900 | 4.7000 | ["400","420"] | ["0.2267","0.2279"] | ["446.80"] | ["XBOX"] | 400.0000 | 420.0000 | 850 | 850 | false | true | false | ||||||||||
| 01a0ca7c-3c57-7d22-878a-b2af8156a955 | JPM | 2026-09-22 14:58 | call_vertical_spread | 2 | 1 | 50 | 467250.00 | short | bid | 340.8850 | 4.3000 | ["370","380"] | ["0.2223","0.2232"] | ["373.83"] | ["XPHO"] | 370.0000 | 380.0000 | 815 | 815 | false | true | false |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:56:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:35:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:07:15Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:45:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:59:07Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |