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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4b6-b63e-7a13-982c-b1e4d2c6d637 | COST | 2026-09-21 12:05 | put_calendar | 2 | 1 | 10 | 278990.00 | unknown | bid | 895.4932 | 16.0000 | ["970"] | ["0.2876"] | [] | ["XCBO"] | 970.0000 | 970.0000 | 816 | 851 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:05:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c436-a12f-73b1-b25a-673c878e7980 | COST | 2026-09-21 09:45 | put_calendar | 2 | 1 | 10 | 170140.00 | unknown | bid | 886.5996 | 11.9000 | ["970"] | ["0.4503"] | [] | ["XCBO"] | 970.0000 | 970.0000 | 4 | 60 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:45:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5d9-12f7-75f2-abe2-754778e35be9 | COST | 2026-09-18 14:48 | call_vertical_spread | 2 | 1 | 50 | 306400.00 | unknown | ask | 896.9300 | 4.7000 | ["870","875"] | ["0.3025","0.3035"] | ["903.14"] | ["XCBO"] | 870.0000 | 875.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:48:34Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b0-12e0-7ae1-a155-ad8b8cd5e8bd | COST | 2026-09-18 14:03 | other | 4 | 1 | 12 | 128904.00 | unknown | — | 895.5800 | 5.8000 | ["890","900","910"] | ["0.2353","0.4163","0.3664"] | [] | ["XPHO"] | 890.0000 | 910.0000 | 0 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:03:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a3-c287-74f2-9680-3b01f387b882 | COST | 2026-09-18 13:50 | put_vertical_spread | 2 | 1 | 24 | 209424.00 | unknown | bid | 894.9300 | 2.8000 | ["890","910"] | ["0.2313","0.2320"] | ["856.37"] | ["XBOX"] | 890.0000 | 910.0000 | 119 | 119 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a2-e85b-7182-8a35-838374a727b6 | COST | 2026-09-17 14:30 | other | 4 | 1 | 14 | 215866.00 | unknown | — | 890.7000 | 14.0500 | ["920","930"] | ["0.2662","0.2674"] | [] | ["XMIO"] | 920.0000 | 930.0000 | 8 | 15 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b04b-6603-7a23-810d-10e195636839 | COST | 2026-09-17 12:55 | call_vertical_spread | 2 | 2 | 27 | 780894.00 | unknown | — | 891.7850 | 14.8500 | ["740","760"] | ["0.3117","0.2875"] | [] | ["XCBO"] | 740.0000 | 760.0000 | 29 | 29 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:55:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa7-f243-7ad3-adf7-1de19a27b035 | COST | 2026-09-17 09:56 | other | 2 | 1 | 10 | 106010.00 | unknown | — | 890.2600 | 3.4500 | ["800","900"] | ["0.2757","0.2444"] | [] | ["XMIO"] | 800.0000 | 900.0000 | 1 | 29 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:57:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a59b-ccae-7512-a436-97c19e5062fb | COST | 2026-09-15 11:07 | call_diagonal_spread | 2 | 1 | 3 | 250656.00 | unknown | — | 908.3530 | 17.0000 | ["520","560"] | ["0.2901","0.2685"] | [] | ["XCBO"] | 520.0000 | 560.0000 | 493 | 822 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:07:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a59b-43f6-7c61-80e9-7458e7c7ce78 | COST | 2026-09-15 11:06 | call_diagonal_spread | 2 | 1 | 6 | 501306.00 | unknown | — | 908.5000 | 17.0000 | ["520","560"] | ["0.2873","0.2675"] | [] | ["XCBO"] | 520.0000 | 560.0000 | 493 | 822 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:06:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a03d-ee88-7481-8a90-d5b7cff45a3e | COST | 2026-09-14 10:06 | other | 2 | 1 | 14 | 162680.00 | unknown | — | 914.0400 | 8.0000 | ["970"] | ["0.2720"] | [] | ["XCBO"] | 970.0000 | 970.0000 | 11 | 18 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:06:52Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09174-5929-7c60-9aed-8ea848a6828b | COST | 2026-09-11 13:11 | put_vertical_spread | 2 | 1 | 58 | 476354.00 | unknown | — | 904.0901 | 3.0500 | ["865","870"] | ["0.2466","0.2463"] | [] | ["XMIO"] | 865.0000 | 870.0000 | 217 | 217 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:12:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc8-93f8-7670-a9eb-ac35141bce9e | COST | 2026-09-10 15:25 | other | 2 | 1 | 8 | 583816.00 | unknown | — | 900.2900 | 12.8500 | ["540"] | ["2.7093"] | [] | ["XCBO"] | 540.0000 | 540.0000 | 1 | 827 | true | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:26:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca6-ac48-7151-821a-21b3110cfbae | COST | 2026-09-10 14:48 | other | 4 | 1 | 27 | 256230.00 | unknown | — | 901.7300 | 2.9500 | ["910","920"] | ["0.2282","0.2299"] | [] | ["XCBO"] | 910.0000 | 920.0000 | 8 | 22 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:49:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0876f-7f98-70a3-a755-21e28d82f094 | COST | 2026-09-09 14:30 | call_vertical_spread | 2 | 1 | 33 | 209022.00 | unknown | — | 899.8100 | 2.4500 | ["895","900"] | ["0.2517","0.2511"] | [] | ["XCBO"] | 895.0000 | 900.0000 | 37 | 37 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:30:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d7-46d8-7ea0-bc6a-3123c1b98883 | COST | 2026-09-09 11:44 | call_vertical_spread | 2 | 1 | 44 | 261536.00 | unknown | — | 900.9600 | 2.8500 | ["900","905"] | ["0.2513","0.2506"] | [] | ["XCBO"] | 900.0000 | 905.0000 | 37 | 37 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:44:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c0-193f-7532-9e89-3f34312dfa94 | COST | 2026-09-09 11:18 | call_vertical_spread | 2 | 1 | 10 | 451400.00 | unknown | — | 901.3800 | 12.2000 | ["700","720"] | ["0.2739","0.2695"] | [] | ["XMIO"] | 700.0000 | 720.0000 | 281 | 281 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:18:50Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a5-3e40-7c33-bf9e-2c8a2b55c517 | COST | 2026-09-09 10:49 | call_vertical_spread | 2 | 1 | 5 | 226375.00 | unknown | — | 904.4300 | 13.5500 | ["700","720"] | ["0.2580","0.2550"] | [] | ["XCBO"] | 700.0000 | 720.0000 | 281 | 281 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:49:29Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08673-6c58-7420-823e-a26242a9bc94 | COST | 2026-09-09 09:55 | other | 4 | 1 | 10 | 162930.00 | unknown | — | 905.4400 | 16.5000 | ["895","920","940","950"] | ["0.2467","0.2437","0.2580","0.2565"] | [] | ["XMIO"] | 895.0000 | 950.0000 | 37 | 44 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:55:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866d-a3e0-77c2-9388-f0f75a8b7222 | COST | 2026-09-09 09:48 | call_vertical_spread | 2 | 1 | 10 | 129420.00 | unknown | — | 905.1900 | 6.2500 | ["850","950"] | ["0.2482","0.2406"] | [] | ["XCBO"] | 850.0000 | 950.0000 | 128 | 128 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:49:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081af-3170-7841-9b78-8a103b655f52 | COST | 2026-09-08 11:42 | call_vertical_spread | 2 | 1 | 20 | 126380.00 | unknown | — | 908.8250 | 3.2000 | ["905","910"] | ["0.2497","0.2493"] | [] | ["XCBO"] | 905.0000 | 910.0000 | 38 | 38 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:42:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08172-0930-7302-8b0f-b4f815b33299 | COST | 2026-09-08 10:35 | call_vertical_spread | 2 | 1 | 29 | 182323.00 | unknown | — | 913.3500 | 2.0500 | ["910","915"] | ["0.2490","0.2487"] | [] | ["XISX"] | 910.0000 | 915.0000 | 38 | 38 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:35:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08169-bc30-7ae0-a0b1-389a71220950 | COST | 2026-09-08 10:26 | iron_condor | 4 | 1 | 29 | 183135.00 | unknown | — | 912.6700 | 9.4500 | ["930","950","990","1010"] | ["0.2108","0.2268","0.2783","0.3364"] | [] | ["XCBO"] | 930.0000 | 1010.0000 | 10 | 10 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:26:25Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08146-80a8-71e1-9072-01f84a05a6f6 | COST | 2026-09-08 09:47 | put_vertical_spread | 2 | 1 | 20 | 134460.00 | unknown | — | 911.5800 | 5.9000 | ["940","945"] | ["0.2229","0.2260"] | [] | ["XCBO"] | 940.0000 | 945.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:48:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06df5-9e6d-7a63-9556-bc4fd1105526 | COST | 2026-09-04 15:46 | put_condor | 4 | 1 | 5 | 520115.00 | unknown | — | 916.0890 | 29.5000 | ["1000","1100","1200","1300"] | ["0.2824","0.3002","0.3287","0.3715"] | [] | ["XCBO"] | 1000.0000 | 1300.0000 | 833 | 833 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:46:52Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |