Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |