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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08139-c6d8-7681-a40d-b50e741c501f | COST | 2026-09-08 09:34 | put_calendar | 2 | 1 | 10 | 111330.00 | short | bid | 910.1000 | 11.9000 | ["965"] | ["0.2210"] | [] | ["BATO"] | 965.0000 | 965.0000 | 10 | 17 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:34:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08227-4b88-7091-82fc-ddb44b4e0b2c | COST | 2026-09-08 13:53 | put_calendar | 2 | 1 | 94 | 326462.00 | short | ask | 909.4900 | 2.5500 | ["900"] | ["0.2663"] | [] | ["XCBO"] | 900.0000 | 900.0000 | 17 | 24 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:54:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a086ed-2480-7a61-ba11-fd14d7390c9c | COST | 2026-09-09 12:08 | put_calendar | 2 | 1 | 30 | 476220.00 | unknown | — | 900.4001 | 4.9500 | ["980"] | ["0.2605"] | [] | ["XPHO"] | 980.0000 | 980.0000 | 9 | 16 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:08:33Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087a5-7fd0-7973-8d6d-edc06d8f6c80 | COST | 2026-09-09 15:29 | put_calendar | 2 | 2 | 38 | 199728.00 | short | ask | 901.7200 | 1.3000 | ["900"] | ["0.2431"] | [] | ["C2OX","EDGO"] | 900.0000 | 900.0000 | 37 | 44 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:30:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a091e1-b158-71e3-9572-7d05c1060be9 | COST | 2026-09-11 15:11 | put_calendar | 2 | 1 | 7 | 134190.00 | short | ask | 904.2600 | 8.0000 | ["1000"] | ["0.3070"] | [] | ["XPHO"] | 1000.0000 | 1000.0000 | 14 | 21 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:11:28Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a03e-2150-7ba0-a134-e94a94a8994c | COST | 2026-09-14 10:06 | put_calendar | 2 | 1 | 13 | 151398.00 | short | bid | 913.6400 | 6.6000 | ["970"] | ["0.2664"] | [] | ["XMIO"] | 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:07:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a043-e5e0-7650-8d4f-2e85332f486c | COST | 2026-09-14 10:13 | put_calendar | 2 | 1 | 16 | 188416.00 | short | bid | 913.4200 | 8.9500 | ["970"] | ["0.2783"] | [] | ["BATO"] | 970.0000 | 970.0000 | 11 | 18 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:13:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08c-0aa0-7752-b288-010e64d799a2 | COST | 2026-09-14 11:32 | put_calendar | 2 | 1 | 12 | 134856.00 | short | bid | 916.6300 | 7.4500 | ["970"] | ["0.2791"] | [] | ["XMIO"] | 970.0000 | 970.0000 | 11 | 18 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:32:18Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08f-3338-7ad0-a4de-42a03b34b11d | COST | 2026-09-14 11:35 | put_calendar | 2 | 1 | 11 | 123684.00 | short | bid | 915.9400 | 7.4500 | ["970"] | ["0.2658"] | [] | ["XPHO"] | 970.0000 | 970.0000 | 11 | 18 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:35:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a561-4836-7362-8ef9-2419e6c630ba | COST | 2026-09-15 10:03 | put_calendar | 2 | 1 | 20 | 122760.00 | unknown | — | 908.6600 | 2.7000 | ["920"] | ["0.2381"] | [] | ["ARCO"] | 920.0000 | 920.0000 | 31 | 38 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:03:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a561-4836-7362-8ef9-240b8fea44c0 | COST | 2026-09-15 10:03 | put_calendar | 2 | 3 | 144 | 877104.00 | short | ask | 908.6600 | 2.7000 | ["920"] | ["0.2360"] | [] | ["ARCO","C2OX","EDGO"] | 920.0000 | 920.0000 | 31 | 38 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:03:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0b01b-3613-7980-8b91-1e4034d70b4d | COST | 2026-09-17 12:02 | put_calendar | 2 | 1 | 98 | 738136.00 | long | bid | 892.2800 | 7.7500 | ["925"] | ["0.3022"] | [] | ["XMIO"] | 925.0000 | 925.0000 | 1 | 29 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:02:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b026-2ac3-7633-9f20-f3c03e941d4c | COST | 2026-09-17 12:14 | put_calendar | 2 | 4 | 40 | 244654.00 | long | bid | 890.4700 | 3.0000 | ["910"] | ["0.2759"] | [] | ["AMXO","XISX","XMIO","XPHO"] | 910.0000 | 910.0000 | 8 | 29 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:15:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b068-f853-7213-8ff3-f1f7e0a77261 | COST | 2026-09-17 13:27 | put_calendar | 2 | 1 | 10 | 158220.00 | short | ask | 891.6150 | 11.0500 | ["970"] | ["0.3380"] | [] | ["XMIO"] | 970.0000 | 970.0000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:27:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b069-6d83-7611-a2d5-175bea73c828 | COST | 2026-09-17 13:28 | put_calendar | 2 | 1 | 10 | 157350.00 | short | bid | 891.8704 | 6.7000 | ["970"] | ["0.3281"] | [] | ["XISX"] | 970.0000 | 970.0000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:28:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b069-90ab-7651-9cb2-d9d90024f0f3 | COST | 2026-09-17 13:28 | put_calendar | 2 | 1 | 25 | 393375.00 | short | bid | 891.7300 | 6.7000 | ["970"] | ["0.3216"] | [] | ["XPHO"] | 970.0000 | 970.0000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:28:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b069-afeb-7f83-876a-a6b1e59797eb | COST | 2026-09-17 13:28 | put_calendar | 2 | 1 | 15 | 236025.00 | short | bid | 891.7300 | 6.7000 | ["970"] | ["0.3216"] | [] | ["XPHO"] | 970.0000 | 970.0000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:28:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06a-2133-7110-af0e-0c1f7caa0c7e | COST | 2026-09-17 13:28 | put_calendar | 2 | 1 | 10 | 157350.00 | short | bid | 891.9000 | 6.7000 | ["970"] | ["0.3294"] | [] | ["AMXO"] | 970.0000 | 970.0000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:29:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06a-9663-7021-ae50-ea5de549e730 | COST | 2026-09-17 13:29 | put_calendar | 2 | 1 | 44 | 692340.00 | short | bid | 892.0200 | 6.7000 | ["970"] | ["0.3346"] | [] | ["XISX"] | 970.0000 | 970.0000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:29:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06a-c15b-7861-bfd8-b7819d1ac20c | COST | 2026-09-17 13:29 | put_calendar | 2 | 1 | 30 | 472050.00 | short | bid | 892.0200 | 6.7000 | ["970"] | ["0.3346"] | [] | ["XMIO"] | 970.0000 | 970.0000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:30:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a5-7c83-7730-83a6-75669b3bc28b | COST | 2026-09-17 14:33 | put_calendar | 2 | 1 | 10 | 139950.00 | long | ask | 891.0800 | 9.4000 | ["960"] | ["0.2731"] | [] | ["SPHR"] | 960.0000 | 960.0000 | 8 | 29 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e9-ec0b-7f72-bf7e-6476b8451c85 | COST | 2026-09-17 15:48 | put_calendar | 2 | 1 | 11 | 132927.00 | unknown | — | 892.5340 | 7.5000 | ["950"] | ["0.2915"] | [] | ["AMXO"] | 950.0000 | 950.0000 | 8 | 29 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:48:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b5c5-6000-7140-967b-24ebec2d16ca | COST | 2026-09-18 14:26 | put_calendar | 2 | 1 | 20 | 536560.00 | short | ask | 896.0850 | 13.2500 | ["960"] | ["0.2853"] | [] | ["XMIO"] | 960.0000 | 960.0000 | 819 | 854 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:26:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d8-cca7-7c02-98d3-63909f1764e0 | COST | 2026-09-18 14:47 | put_calendar | 2 | 1 | 20 | 129220.00 | short | ask | 897.2137 | 6.3000 | ["920"] | ["0.2984"] | [] | ["XISX"] | 920.0000 | 920.0000 | 7 | 21 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:48:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d9-d260-7f01-8f85-e990a0884e3b | COST | 2026-09-18 14:49 | put_calendar | 2 | 1 | 30 | 217050.00 | unknown | ask | 897.1200 | 8.7500 | ["925"] | ["0.3049"] | [] | ["AMXO"] | 925.0000 | 925.0000 | 7 | 21 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:49:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e9-62c0-7ea2-a717-bc90d0bd03b8 | COST | 2026-09-18 15:06 | put_calendar | 2 | 1 | 20 | 194600.00 | short | ask | 897.7600 | 8.1500 | ["940"] | ["0.3012"] | [] | ["XISX"] | 940.0000 | 940.0000 | 7 | 35 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:06:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b610-efc0-7030-9794-f0e48c1cfe40 | COST | 2026-09-18 15:49 | put_calendar | 2 | 1 | 10 | 150220.00 | long | bid | 897.1500 | 9.1500 | ["970"] | ["0.2957"] | [] | ["ARCO"] | 970.0000 | 970.0000 | 14 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:49:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |