core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d4df-6e3e-7a23-8311-c366a4813606 | JNJ | 2026-09-24 15:23 | put_calendar | 2 | 1 | 100 | 133400.00 | unknown | bid | 271.7900 | 0.7000 | ["260"] | ["0.2672"] | [] | ["XISX"] | 260.0000 | 260.0000 | 57 | 85 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:23:52Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d40e-faf6-7f10-9c82-f0db516d1fec | JNJ | 2026-09-24 11:35 | risk_reversal | 2 | 1 | 40 | 132800.00 | short | bid | 270.2550 | 3.4000 | ["240","310"] | ["0.2886","0.2305"] | ["314.80"] | ["XMIO"] | 240.0000 | 310.0000 | 449 | 449 | false | true | false | ||||||||||
| 01a0cf71-d00e-78f1-b821-0ee52a1fe1a8 | JNJ | 2026-09-23 14:05 | call_diagonal_spread | 2 | 1 | 8 | 128584.00 | unknown | ask | 266.6150 | 4.3000 | ["200","210"] | ["0.1783","0.1761"] | [] | ["XISX"] | 200.0000 | 210.0000 | 485 | 849 | false | false | true | ||||||||||
| 01a0cf2b-e987-7c41-acb7-682789814683 | JNJ | 2026-09-23 12:49 | call_diagonal_spread | 2 | 1 | 8 | 171634.00 | unknown | ask | 267.0400 | 6.7000 | ["145","175"] | ["1.2020","0.3654"] | [] | ["XISX"] | 145.0000 | 175.0000 | 23 | 849 | false | false | true | ||||||||||
| 01a0cea4-4ac6-79b0-8571-ebf8a0b427b1 | JNJ | 2026-09-23 10:21 | call_diagonal_spread | 2 | 10 | 58 | 148326.00 | long | ask | 271.9500 | 1.1500 | ["280","290"] | ["0.2395","0.2392"] | [] | ["AMXO","ARCO","EDGO","EMLD","MCRY","SPHR","XBOX","XISX","XMIO","XPHO"] | 280.0000 | 290.0000 | 114 | 177 | false | true | true | ||||||||||
| 01a0cea4-42f7-7650-982a-0576d4451ebf | JNJ | 2026-09-23 10:21 | call_diagonal_spread | 2 | 2 | 66 | 168894.00 | long | ask | 272.0000 | 1.3000 | ["280","290"] | ["0.2392","0.2390"] | [] | ["BATO","C2OX"] | 280.0000 | 290.0000 | 114 | 177 | false | true | true | ||||||||||
| 01a0cea4-42f7-7650-982a-056fcef80db7 | JNJ | 2026-09-23 10:21 | call_diagonal_spread | 2 | 2 | 100 | 255900.00 | long | ask | 272.0000 | 1.3000 | ["280","290"] | ["0.2392","0.2390"] | [] | ["BATO","C2OX"] | 280.0000 | 290.0000 | 114 | 177 | false | true | true | ||||||||||
| 01a0cea4-42f7-7650-982a-0551c8f04df3 | JNJ | 2026-09-23 10:21 | call_diagonal_spread | 2 | 3 | 150 | 383850.00 | long | ask | 272.0000 | 1.3000 | ["280","290"] | ["0.2392","0.2390"] | [] | ["BATO","C2OX","XCBO"] | 280.0000 | 290.0000 | 114 | 177 | false | true | true | ||||||||||
| 01a0cea4-42f7-7650-982a-0521fb18e8f5 | JNJ | 2026-09-23 10:21 | call_diagonal_spread | 2 | 4 | 102 | 260620.00 | long | ask | 272.0000 | 1.4975 | ["280","290"] | ["0.2389","0.2388"] | [] | ["ARCO","EMLD","SPHR"] | 280.0000 | 290.0000 | 114 | 177 | false | true | true | ||||||||||
| 01a0b5e3-7338-7531-9399-6cdec5e35441 | JNJ | 2026-09-18 14:59 | call_calendar | 2 | 1 | 200 | 444000.00 | short | ask | 271.5500 | 0.7500 | ["270"] | ["0.2580"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5e2-1b78-78b0-b9a2-2319a3240f36 | JNJ | 2026-09-18 14:58 | call_calendar | 2 | 1 | 200 | 444000.00 | short | ask | 271.6300 | 0.7500 | ["270"] | ["0.2568"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5e0-b418-7ec3-8b2b-93d7cb7f119b | JNJ | 2026-09-18 14:56 | call_calendar | 2 | 2 | 200 | 444000.00 | unknown | — | 271.6700 | 0.8000 | ["270"] | ["0.2561"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | false | mlet | |||||||
| 01a0b5e0-2b5f-7711-9f1c-7ef5b6701312 | JNJ | 2026-09-18 14:55 | call_calendar | 2 | 1 | 200 | 444800.00 | unknown | bid | 271.6050 | 0.9000 | ["270"] | ["0.2577"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5df-73c8-7da1-866b-b5635a4ee5e1 | JNJ | 2026-09-18 14:55 | call_calendar | 2 | 1 | 100 | 222400.00 | unknown | bid | 271.6200 | 0.9000 | ["270"] | ["0.2575"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5de-3f2f-73f1-a5c8-9eb6938be05b | JNJ | 2026-09-18 14:53 | call_calendar | 2 | 1 | 100 | 222400.00 | unknown | bid | 271.6700 | 0.9000 | ["270"] | ["0.2567"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5dc-1c4f-7b31-9344-6a4145b2f229 | JNJ | 2026-09-18 14:51 | call_calendar | 2 | 1 | 50 | 111200.00 | unknown | bid | 271.7300 | 1.4500 | ["270"] | ["0.2557"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5db-b6bf-75d2-9924-0f1d9a948b27 | JNJ | 2026-09-18 14:51 | call_calendar | 2 | 1 | 50 | 111500.00 | unknown | — | 271.6200 | 1.0000 | ["270"] | ["0.2583"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | false | mlet | |||||||
| 01a0b579-d80f-7732-8ae3-64307bcbff4c | JNJ | 2026-09-18 13:04 | call_calendar | 2 | 1 | 100 | 206400.00 | unknown | bid | 269.9650 | 0.8500 | ["270"] | ["0.2604"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | true | true | false | |||||||||
| 01a0b52b-75a8-7933-b236-cf2fa8d8b259 | JNJ | 2026-09-18 11:38 | call_calendar | 2 | 1 | 50 | 157500.00 | short | bid | 269.3585 | 0.6000 | ["260"] | ["0.2607"] | [] | ["XISX"] | 260.0000 | 260.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b091-9aab-78d2-8d8d-cdac154f061e | JNJ | 2026-09-17 14:12 | call_diagonal_spread | 2 | 1 | 18 | 138438.00 | long | ask | 268.7500 | 5.1500 | ["260","290"] | ["0.2162","0.2103"] | [] | ["XISX"] | 260.0000 | 290.0000 | 456 | 855 | false | false | true | ||||||||||
| 01a0b060-70bb-77f0-8cb6-4319f70ddd61 | JNJ | 2026-09-17 13:18 | call_vertical_spread | 2 | 1 | 4 | 120400.00 | long | ask | 267.8451 | 4.2000 | ["115","120"] | ["6.5517","6.3460"] | ["119.98"] | ["XISX"] | 115.0000 | 120.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0afc8-861b-7782-9eee-9ce5d24327d1 | JNJ | 2026-09-17 10:32 | call_diagonal_spread | 2 | 2 | 156 | 110910.00 | unknown | — | 269.0151 | 0.7400 | ["270","310"] | ["0.3093","0.2367"] | [] | ["MCRY","SPHR"] | 270.0000 | 310.0000 | 1 | 183 | false | true | true | true | false | ||||||||
| 01a0aad9-8213-7631-a7a8-780f08c557f9 | JNJ | 2026-09-16 11:32 | call_vertical_spread | 2 | 1 | 4 | 143864.00 | unknown | — | 267.8500 | 5.2000 | ["85","90"] | ["7.3068","7.1600"] | [] | ["AMXO"] | 85.0000 | 90.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a0aad6-6d03-7b33-8400-c603d0d8abc7 | JNJ | 2026-09-16 11:29 | strangle | 2 | 7 | 41 | 161950.00 | short | bid | 267.6950 | 0.8671 | ["250","360"] | ["0.2865","0.2115"] | ["210.5","399.50"] | ["MCRY","XCBO","XISX","XPHO"] | 250.0000 | 360.0000 | 821 | 821 | false | true | false | ||||||||||
| 01a0a670-240e-7e93-9330-acb56bc4082d | JNJ | 2026-09-15 14:59 | call_calendar | 2 | 1 | 15 | 225600.00 | short | bid | 265.5800 | 2.0000 | ["210"] | ["0.1907"] | [] | ["XISX"] | 210.0000 | 210.0000 | 493 | 822 | false | false | true | false | |||||||||
| 01a0a5d2-365e-7c90-a6a6-fe4e703020ba | JNJ | 2026-09-15 12:06 | call_vertical_spread | 2 | 1 | 7 | 254450.00 | long | ask | 264.1250 | 4.2000 | ["80","85"] | ["5.0301","4.8837"] | ["84.98"] | ["XISX"] | 80.0000 | 85.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a091b6-3c58-7b83-ac3e-a7ffbaaea01d | JNJ | 2026-09-11 14:23 | other | 2 | 2 | 120 | 100950.00 | unknown | — | 265.5400 | 0.4200 | ["260","265"] | ["0.2542","0.4023"] | [] | ["ARCO","C2OX"] | 260.0000 | 265.0000 | 0 | 70 | false | true | true | true | false | mlet | |||||||
| 01a09196-b9f0-7a91-b659-48fc81394e92 | JNJ | 2026-09-11 13:49 | other | 2 | 2 | 120 | 100650.00 | unknown | — | 265.8400 | 0.4500 | ["260","265"] | ["0.2571","0.3555"] | [] | ["ARCO","C2OX"] | 260.0000 | 265.0000 | 0 | 70 | false | true | true | true | false | mlet | |||||||
| 01a09196-b608-7771-8e23-3d5e63817c09 | JNJ | 2026-09-11 13:49 | other | 2 | 2 | 120 | 100680.00 | unknown | — | 265.8400 | 0.4500 | ["260","265"] | ["0.2571","0.3555"] | [] | ["ARCO","C2OX"] | 260.0000 | 265.0000 | 0 | 70 | false | true | true | true | false | mlet | |||||||
| 01a09196-b220-7f60-b717-ac6e2496976b | JNJ | 2026-09-11 13:49 | other | 2 | 2 | 120 | 100680.00 | unknown | — | 265.8400 | 0.4500 | ["260","265"] | ["0.2571","0.3555"] | [] | ["ARCO","C2OX"] | 260.0000 | 265.0000 | 0 | 70 | false | true | true | true | false | mlet | |||||||
| 01a08243-5f08-7f60-8c25-704168efb6a6 | JNJ | 2026-09-08 14:24 | call_calendar | 2 | 1 | 13 | 165620.00 | short | ask | 270.6550 | 4.9500 | ["210"] | ["0.3021"] | [] | ["XISX"] | 210.0000 | 210.0000 | 38 | 192 | false | false | true | false | |||||||||
| 01a081cc-3ef0-7b63-8267-1b429f13bc93 | JNJ | 2026-09-08 12:13 | call_vertical_spread | 2 | 1 | 3 | 111573.00 | long | ask | 268.6000 | 2.4000 | ["80","85"] | ["3.3098","3.1459"] | ["84.97"] | ["XPHO"] | 80.0000 | 85.0000 | 10 | 10 | false | false | false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:36:06Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:05:39Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:49:45Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:21:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:21:05Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:21:05Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:21:05Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:21:05Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:59:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:58:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:57:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:56:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:55:34Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:54:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:51:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:51:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:04:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:39:06Z"} |
| 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-17T18:12:38Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:18:35Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:32:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:33:01Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:29:34Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:00:00Z"} |
| 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-15T16:07:21Z"} |
| 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-11T18:24:15Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:49:38Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:49:38Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:49:38Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:24:11Z"} |
| 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-08T16:14:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |