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 | direction |
|---|
| 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 |
|---|
| 01a0ca52-423f-7193-a5c6-b1bbdc9e650b | JPM | 2026-09-22 14:13 | call_diagonal_spread | 2 | 1 | 5 | 149220.00 | short | ask | 340.4500 | 5.4500 | ["195","210"] | ["0.4154","0.3695"] | [] | ["XCBO"] | 195.0000 | 210.0000 | 451 | 815 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:13:21Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9cc-b2d7-7af0-af54-f5435b5b3ea0 | JPM | 2026-09-22 11:47 | call_diagonal_spread | 2 | 1 | 10 | 119340.00 | long | ask | 338.7300 | 3.1000 | ["340","350"] | ["0.2228","0.2248"] | [] | ["XMIO"] | 340.0000 | 350.0000 | 815 | 850 | false | true | true | ||||||||||
| 01a0c9cb-e3cf-79c1-a271-02e5341f4c71 | JPM | 2026-09-22 11:46 | call_diagonal_spread | 2 | 1 | 10 | 119370.00 | long | ask | 338.9900 | 3.1000 | ["340","350"] | ["0.2219","0.2240"] | [] | ["XPHO"] | 340.0000 | 350.0000 | 815 | 850 | false | true | true | ||||||||||
| 01a0c98c-98af-7c83-98a1-8796d4f86de3 | JPM | 2026-09-22 10:37 | call_diagonal_spread | 2 | 1 | 18 | 294228.00 | unknown | ask | 340.6250 | 4.7500 | ["260","265"] | ["0.3186","0.2353"] | [] | ["XISX"] | 260.0000 | 265.0000 | 59 | 178 | false | false | true | ||||||||||
| 01a0c98a-8187-7980-9eea-7cbc8ce1dde6 | JPM | 2026-09-22 10:34 | call_diagonal_spread | 2 | 1 | 15 | 232365.00 | short | ask | 340.1700 | 5.9000 | ["260","275"] | ["0.4187","0.2601"] | [] | ["XPHO"] | 260.0000 | 275.0000 | 59 | 178 | false | false | true | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0a5d9-0876-73e0-abef-40c429b31bc4 | JPM | 2026-09-15 12:14 | call_diagonal_spread | 2 | 2 | 33 | 126256.00 | long | ask | 343.9604 | 2.3500 | ["330","340"] | ["0.3744","0.2419"] | [] | ["MCRY","XMIO"] | 330.0000 | 340.0000 | 3 | 122 | false | false | true | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a08692-94e9-72b0-8f6a-b48eb49bbea2 | JPM | 2026-09-09 10:29 | call_diagonal_spread | 2 | 1 | 10 | 198440.00 | long | ask | 354.8300 | 5.9000 | ["260","290"] | ["0.3292","0.2150"] | [] | ["AMXO"] | 260.0000 | 290.0000 | 100 | 828 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:47:30Z"} |
| 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-22T15:46:47Z"} |
| 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-22T14:37:19Z"} |
| 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-22T14:35:10Z"} |
| 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-18T19:37:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| 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 |
| 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 |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:14:55Z"} |
| 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-15T14:59:33Z"} |
| 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-15T14:59:33Z"} |
| 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-14T19:41:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| 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 |
| 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 |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:29:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |