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
active:ticker = BLK×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5a9-8ee7-7af2-955a-fd902cd201c9 | BLK | 2026-09-18 13:56 | other | 3 | 1 | 7 | 135942.00 | unknown | ask | 1058.9700 | 15.2000 | ["1055","1140","1150"] | ["0.2841","0.2927","0.3067"] | [] | ["XISX"] | 1055.0000 | 1150.0000 | 7 | 28 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:56:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b585-1ec7-7070-a63e-629b701e95b2 | BLK | 2026-09-18 13:16 | put_diagonal_spread | 2 | 1 | 6 | 103950.00 | unknown | ask | 1057.0800 | 9.1000 | ["1060","1100"] | ["0.2964","0.3058"] | [] | ["XBOX"] | 1060.0000 | 1100.0000 | 91 | 272 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:16:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57d-bc27-7c42-b37d-b114db26a22e | BLK | 2026-09-18 13:08 | call_calendar | 2 | 2 | 20 | 226680.00 | long | bid | 1057.9800 | 6.7000 | ["1060"] | ["0.2763"] | [] | ["EDGO","XISX"] | 1060.0000 | 1060.0000 | 63 | 91 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:08:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b532-e017-7be1-90d7-46057f5ab0bb | BLK | 2026-09-18 11:46 | call_calendar | 2 | 1 | 14 | 121338.00 | long | ask | 1051.3500 | 5.1000 | ["1080"] | ["0.2713"] | [] | ["XCBO"] | 1080.0000 | 1080.0000 | 63 | 91 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:46:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b531-ab80-7562-8d0a-d832b02d710c | BLK | 2026-09-18 11:45 | call_calendar | 2 | 1 | 21 | 181860.00 | long | ask | 1051.3250 | 5.9000 | ["1080"] | ["0.2712"] | [] | ["MCRY"] | 1080.0000 | 1080.0000 | 63 | 91 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:45:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b4-de03-7a83-baf1-d04d1e3ec3bb | BLK | 2026-09-17 14:50 | put_ladder | 3 | 1 | 110 | 1452000.00 | unknown | — | 1058.7350 | 23.0000 | ["1120","1130","1160"] | ["0.9542","1.1313","1.4379"] | [] | ["XBOX"] | 1120.0000 | 1160.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:50:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba1-1bbb-7fd2-9651-7b18c2c54cb4 | BLK | 2026-09-16 15:10 | call_vertical_spread | 2 | 1 | 10 | 156440.00 | long | ask | 1026.7400 | 15.2000 | ["1400","1460"] | ["0.2605","0.2620"] | ["1411"] | ["C2OX"] | 1400.0000 | 1460.0000 | 821 | 821 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:11:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8d-16bb-7992-b8a2-8fc92cddaba5 | BLK | 2026-09-16 14:49 | put_diagonal_spread | 2 | 1 | 5 | 102255.00 | short | bid | 1045.5450 | 7.6000 | ["1080","1120"] | ["0.2875","0.3027"] | [] | ["XISX"] | 1080.0000 | 1120.0000 | 93 | 274 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:49:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8c-9da3-7f00-aa71-871e120053f2 | BLK | 2026-09-16 14:48 | call_vertical_spread | 2 | 4 | 4 | 100614.00 | long | ask | 1047.4550 | 15.4000 | ["1050","1200"] | ["0.2619","0.2621"] | ["1110.51"] | ["ARCO","BATO","C2OX","SPHR"] | 1050.0000 | 1200.0000 | 492 | 492 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:48:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab82-cdeb-7e71-aa61-ab04c1091894 | BLK | 2026-09-16 14:37 | put_diagonal_spread | 2 | 3 | 6 | 124120.00 | short | bid | 1045.1100 | 9.8000 | ["1080","1120"] | ["0.2925","0.3051"] | [] | ["ARCO","BATO","SPHR"] | 1080.0000 | 1120.0000 | 93 | 274 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:38:03Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a64e-730d-7832-874b-6f4f439eff8a | BLK | 2026-09-15 14:22 | put_calendar | 2 | 1 | 15 | 112350.00 | short | bid | 1056.5400 | 4.6000 | ["1060"] | ["0.2913"] | [] | ["AMXO"] | 1060.0000 | 1060.0000 | 31 | 38 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:22:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a62a-222d-7023-b51c-73bd6c374f07 | BLK | 2026-09-15 13:42 | put_calendar | 2 | 1 | 8 | 103192.00 | long | bid | 1055.1750 | 4.1000 | ["1060"] | ["0.2882"] | [] | ["XISX"] | 1060.0000 | 1060.0000 | 66 | 185 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:43:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a628-e9ad-7ec1-bb38-85670238f7a5 | BLK | 2026-09-15 13:41 | put_calendar | 2 | 1 | 15 | 192090.00 | long | bid | 1054.5300 | 4.7000 | ["1060"] | ["0.2849"] | [] | ["XPHO"] | 1060.0000 | 1060.0000 | 66 | 185 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:42:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a622-32ee-7350-b22a-923733d03dda | BLK | 2026-09-15 13:34 | call_calendar | 2 | 1 | 15 | 259050.00 | unknown | — | 1054.3350 | 6.8000 | ["1030"] | ["0.2836"] | [] | ["AMXO"] | 1030.0000 | 1030.0000 | 66 | 185 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:34:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a622-07f6-7411-963c-1211dc9e69e2 | BLK | 2026-09-15 13:34 | call_calendar | 2 | 1 | 15 | 258975.00 | long | bid | 1054.7000 | 6.9000 | ["1030"] | ["0.2827"] | [] | ["XMIO"] | 1030.0000 | 1030.0000 | 66 | 185 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:34:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a61a-4796-7400-95b9-6a1a7713c8a0 | BLK | 2026-09-15 13:25 | call_calendar | 2 | 1 | 10 | 144760.00 | long | ask | 1052.6700 | 11.7000 | ["1040"] | ["0.2905"] | [] | ["AMXO"] | 1040.0000 | 1040.0000 | 66 | 122 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:26:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a618-b156-7bd3-b4ef-32792bed3f6d | BLK | 2026-09-15 13:23 | call_calendar | 2 | 1 | 15 | 217440.00 | long | bid | 1053.5080 | 11.3000 | ["1040"] | ["0.2886"] | [] | ["XMIO"] | 1040.0000 | 1040.0000 | 66 | 122 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:24:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0919d-6110-7d10-a481-12a99aff5f22 | BLK | 2026-09-11 13:56 | call_calendar | 2 | 1 | 10 | 146970.00 | short | ask | 1086.4198 | 7.0000 | ["1080"] | ["0.2670"] | [] | ["BATO"] | 1080.0000 | 1080.0000 | 98 | 126 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:57:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0919d-41d0-7910-97b7-512884367cf9 | BLK | 2026-09-11 13:56 | call_calendar | 2 | 1 | 10 | 146850.00 | short | bid | 1086.4198 | 6.9000 | ["1080"] | ["0.2669"] | [] | ["AMXO"] | 1080.0000 | 1080.0000 | 98 | 126 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:57:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b88-8278-7662-97ac-204f309c2a09 | BLK | 2026-09-10 09:36 | other | 2 | 1 | 8 | 108200.00 | unknown | — | 1067.3150 | 14.2000 | ["1060","1100"] | ["0.2848","0.2858"] | [] | ["XMIO"] | 1060.0000 | 1100.0000 | 127 | 190 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:36:21Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0825d-7aa0-7332-9f8f-64bad1588248 | BLK | 2026-09-08 14:52 | call_vertical_spread | 2 | 2 | 20 | 285610.00 | unknown | — | 1098.8200 | 3.6000 | ["1120","1180"] | ["0.2601","0.2577"] | [] | ["ARCO"] | 1120.0000 | 1180.0000 | 192 | 192 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:52:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0814a-68a8-7a82-b603-cf8686f437a9 | BLK | 2026-09-08 09:52 | call_diagonal_spread | 2 | 1 | 5 | 157200.00 | long | ask | 1109.2750 | 9.2000 | ["800","1200"] | ["0.5043","0.4779"] | [] | ["XMIO"] | 800.0000 | 1200.0000 | 3 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:52:25Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06de1-0ccd-7c52-8cfe-a82989c24ef9 | BLK | 2026-09-04 15:24 | other | 8 | 1 | 20 | 2776200.00 | unknown | — | 1121.4200 | 62.6000 | ["640","680","700","760","800","960","970","980"] | ["0.7720","0.6816","0.6383","0.5144","0.4358","0.5140","0.4693","0.4422"] | [] | ["XPHO"] | 640.0000 | 980.0000 | 14 | 42 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:24:53Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db6-4f65-72d2-8cc1-4c6278aaa416 | BLK | 2026-09-04 14:37 | other | 4 | 1 | 5 | 262440.00 | unknown | — | 1124.1200 | 30.4000 | ["830","1020","1030","1090"] | ["0.8924","0.5385","0.4977","0.1697"] | [] | ["XPHO"] | 830.0000 | 1090.0000 | 7 | 14 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:38:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d97-c315-7262-93a4-bc3f0894b2e0 | BLK | 2026-09-04 14:04 | call_condor | 4 | 1 | 25 | 1998250.00 | unknown | — | 1119.8800 | 26.9000 | ["800","930","970","980"] | ["0.9233","0.5516","0.4446","0.4182"] | [] | ["XPHO"] | 800.0000 | 980.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:05:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d62-092d-7f90-abeb-7b51c25fcdab | BLK | 2026-09-04 13:05 | call_calendar | 2 | 1 | 8 | 603040.00 | short | bid | 1120.3000 | 8.2000 | ["750"] | ["0.4112"] | [] | ["XISX"] | 750.0000 | 750.0000 | 105 | 196 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:05:54Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |