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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | false | 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 |
| 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 | false | 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 |
| 01a0b5d0-c20f-7a81-958b-675b54095faf | JNJ | 2026-09-18 14:39 | put_frontspread | 2 | 1 | 6783 | 542220.00 | long | ask | 271.3800 | 0.4500 | ["260","265"] | ["0.2413","0.2460"] | ["257.68"] | ["SPHR"] | 260.0000 | 265.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:39:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 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 | true | 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 |
| 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 | true | 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 |
| 01a0b030-583b-7f92-9b23-18c96b6d5f7d | JNJ | 2026-09-17 12:25 | call_diagonal_spread | 2 | 1 | 175 | 243250.00 | short | ask | 268.2000 | 1.9000 | ["260","300"] | ["0.5097","0.2368"] | [] | ["SPHR"] | 260.0000 | 300.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:26:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afed-1d4b-7c10-8520-ceb3488dc140 | JNJ | 2026-09-17 11:12 | put_frontspread | 2 | 1 | 6300 | 441000.00 | long | ask | 269.2150 | 0.3800 | ["255","260"] | ["0.2610","0.2652"] | ["252.41","260"] | ["SPHR"] | 255.0000 | 260.0000 | 8 | 8 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:12:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 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 | true | 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 |
| 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 | false | 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 |
| 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 | 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 |
| 01a06d40-63e6-7240-a173-f7948484a001 | JNJ | 2026-09-04 12:28 | call_vertical_spread | 2 | 1 | 4 | 107064.00 | long | ask | 276.4400 | 2.7000 | ["140","145"] | ["2.3411","2.3048"] | ["144.98"] | ["XCBO"] | 140.0000 | 145.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:29:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d3e-836d-7982-ac3e-6f7a8cc0198e | JNJ | 2026-09-04 12:26 | call_vertical_spread | 2 | 1 | 4 | 107048.00 | long | ask | 276.4950 | 2.8000 | ["140","145"] | ["2.2928","2.2649"] | ["144.98"] | ["XCBO"] | 140.0000 | 145.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:27:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |