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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4ba-c54f-7432-8d6a-fec0fc9763cc | COST | 2026-09-21 12:09 | put_diagonal_spread | 2 | 1 | 10 | 139530.00 | short | ask | 896.1300 | 8.6500 | ["960","965"] | ["0.2541","0.5014"] | [] | ["XISX"] | 960.0000 | 965.0000 | 4 | 39 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:09:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c45d-91ef-7b11-8600-3683eec7648d | COST | 2026-09-21 10:27 | put_diagonal_spread | 2 | 1 | 7 | 115430.00 | short | bid | 893.9900 | 7.7000 | ["905","960"] | ["0.2442","0.2579"] | [] | ["XPHO"] | 905.0000 | 960.0000 | 207 | 361 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:27:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c45d-8a1e-7e80-84d7-6f1105eec3a9 | COST | 2026-09-21 10:27 | put_diagonal_spread | 2 | 1 | 7 | 116718.00 | short | bid | 893.9900 | 6.7500 | ["905","960"] | ["0.2482","0.2601"] | [] | ["ARCO"] | 905.0000 | 960.0000 | 207 | 361 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:27:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5ab-d107-7473-bf68-6536fdc0d7fc | COST | 2026-09-18 13:58 | put_diagonal_spread | 2 | 1 | 34 | 500344.00 | short | ask | 895.1500 | 9.4000 | ["965","970"] | ["0.2458","0.2576"] | [] | ["XISX"] | 965.0000 | 970.0000 | 21 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:59:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a6-27d0-7281-ae92-5a922dc7a368 | COST | 2026-09-18 13:52 | put_diagonal_spread | 2 | 6 | 12 | 166818.00 | short | ask | 895.2900 | 3.4500 | ["960","965"] | ["0.2517","0.2673"] | [] | ["AMXO","ARCO","EMLD","MCRY","XMIO","XPHO"] | 960.0000 | 965.0000 | 21 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a5-9b30-7891-b4cf-99f911aaa8f0 | COST | 2026-09-18 13:52 | put_diagonal_spread | 2 | 8 | 12 | 167324.00 | short | ask | 894.9550 | 5.5750 | ["960","965"] | ["0.2506","0.2655"] | [] | ["AMXO","ARCO","EMLD","MCRY","SPHR","XBOX","XMIO","XPHO"] | 960.0000 | 965.0000 | 21 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a1-0f1f-7020-a2b9-27179bd17d0d | COST | 2026-09-18 13:47 | put_diagonal_spread | 2 | 3 | 26 | 362442.00 | short | ask | 894.8500 | 6.9000 | ["960","965"] | ["0.2485","0.2639"] | [] | ["BATO","C2OX","EDGO"] | 960.0000 | 965.0000 | 21 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:47:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b532-6ae8-7300-9dde-b73fa7499509 | COST | 2026-09-18 11:46 | put_diagonal_spread | 2 | 1 | 10 | 102390.00 | short | ask | 894.1000 | 7.9500 | ["915","955"] | ["0.2268","2.3021"] | [] | ["XMIO"] | 915.0000 | 955.0000 | 0 | 63 | false | false | true | true | 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 |
| 01a0b0aa-bc43-7a72-bea7-a9a81db0ceb7 | COST | 2026-09-17 14:39 | put_diagonal_spread | 2 | 1 | 28 | 122668.00 | short | bid | 891.5550 | 6.3000 | ["610","660"] | ["0.2812","0.2740"] | [] | ["XISX"] | 610.0000 | 660.0000 | 820 | 855 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:39:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b095-0d7b-77b0-83fb-913154f835d3 | COST | 2026-09-17 14:15 | put_diagonal_spread | 2 | 1 | 18 | 141822.00 | unknown | — | 892.3746 | 3.1000 | ["900","920"] | ["0.2378","0.3797"] | [] | ["XPHO"] | 900.0000 | 920.0000 | 1 | 155 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:16:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b011-04b3-7242-8017-70b095467968 | COST | 2026-09-17 11:51 | put_diagonal_spread | 2 | 1 | 34 | 568072.00 | short | ask | 890.8000 | 10.9500 | ["970","975"] | ["0.3017","0.3406"] | [] | ["BATO"] | 970.0000 | 975.0000 | 15 | 22 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:51:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00f-d01b-7f12-9d45-7374520d98ef | COST | 2026-09-17 11:50 | put_diagonal_spread | 2 | 1 | 9 | 141129.00 | short | ask | 890.5000 | 8.3000 | ["965","970"] | ["0.2821","0.3114"] | [] | ["C2OX"] | 965.0000 | 970.0000 | 15 | 22 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:50:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00f-c463-7422-94d0-531f9a70362b | COST | 2026-09-17 11:50 | put_diagonal_spread | 2 | 3 | 17 | 266575.00 | short | ask | 890.5000 | 8.3000 | ["965","970"] | ["0.2821","0.3114"] | [] | ["BATO","C2OX","EDGO"] | 965.0000 | 970.0000 | 15 | 22 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:50:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00f-c463-7422-94d0-530559453591 | COST | 2026-09-17 11:50 | put_diagonal_spread | 2 | 3 | 34 | 533138.00 | short | ask | 890.5000 | 8.3000 | ["965","970"] | ["0.2821","0.3113"] | [] | ["ARCO","EMLD","SPHR"] | 965.0000 | 970.0000 | 15 | 22 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:50:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab11-2c13-7b53-8839-d9bd4bbba027 | COST | 2026-09-16 12:33 | put_diagonal_spread | 2 | 4 | 70 | 108332.00 | unknown | — | 900.9500 | 1.5500 | ["870","910"] | ["0.2429","0.2176"] | [] | ["C2OX","EDGO","XCBO"] | 870.0000 | 910.0000 | 2 | 30 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:33:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab11-2c13-7b53-8839-d9af4445b355 | COST | 2026-09-16 12:33 | put_diagonal_spread | 2 | 11 | 145 | 275804.00 | unknown | — | 900.9500 | 1.7203 | ["870","910"] | ["0.2423","0.2135"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","MCRY","XBOX","XISX","XMIO","XPHO"] | 870.0000 | 910.0000 | 2 | 30 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:33:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf0-ceeb-7163-b2ef-70b8093a4ef1 | COST | 2026-09-16 11:58 | put_diagonal_spread | 2 | 1 | 47 | 432353.00 | unknown | — | 901.2600 | 9.0000 | ["860","875"] | ["0.2550","0.2510"] | [] | ["BATO"] | 860.0000 | 875.0000 | 212 | 274 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:58:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae0-b5d3-7120-888a-f11af0070c87 | COST | 2026-09-16 11:40 | put_diagonal_spread | 2 | 1 | 8 | 156820.00 | short | ask | 901.6600 | 11.6500 | ["902.5","1080"] | ["0.3089","1.1411"] | [] | ["XISX"] | 902.5000 | 1080.0000 | 2 | 9 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:41:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08bc6-3b40-7382-8cb0-acd8a8d76075 | COST | 2026-09-10 10:43 | put_diagonal_spread | 2 | 1 | 5 | 121850.00 | short | ask | 903.0500 | 11.0000 | ["980","1000"] | ["0.2604","0.2659"] | [] | ["XMIO"] | 980.0000 | 1000.0000 | 280 | 498 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:43:54Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bbe-4818-7d13-90c1-756338322c58 | COST | 2026-09-10 10:34 | put_diagonal_spread | 2 | 2 | 10 | 150630.00 | long | ask | 903.8750 | 12.2500 | ["970","975"] | ["0.2389","0.2531"] | [] | ["XMIO"] | 970.0000 | 975.0000 | 36 | 71 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:35:06Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08703-a250-7ea3-acad-abc32528f383 | COST | 2026-09-09 12:32 | put_diagonal_spread | 2 | 1 | 12 | 185808.00 | short | ask | 900.2400 | 5.6500 | ["975","980"] | ["0.2824","0.2816"] | [] | ["EMLD"] | 975.0000 | 980.0000 | 9 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:33:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08703-9a80-73b0-bb56-9ecefcd43f22 | COST | 2026-09-09 12:32 | put_diagonal_spread | 2 | 4 | 17 | 264552.00 | short | ask | 900.2400 | 7.5000 | ["975","980"] | ["0.2937","0.3131"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 975.0000 | 980.0000 | 9 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:32:33Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d9-1b98-77b0-a204-2e40744c79a6 | COST | 2026-09-09 11:46 | put_diagonal_spread | 2 | 3 | 7 | 118350.00 | long | bid | 900.7800 | 3.7500 | ["980","990"] | ["0.2973","0.3298"] | [] | ["EDGO","XMIO"] | 980.0000 | 990.0000 | 9 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:46:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d4-29f8-76d3-88a2-cd297cead884 | COST | 2026-09-09 11:40 | put_diagonal_spread | 2 | 6 | 20 | 327338.00 | unknown | — | 901.0600 | 5.3125 | ["980","985"] | ["0.2996","0.3249"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 980.0000 | 985.0000 | 9 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:40:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0869b-0ce0-76b2-90aa-db5ff2a1c6f7 | COST | 2026-09-09 10:38 | put_diagonal_spread | 2 | 3 | 34 | 139036.00 | short | bid | 903.7500 | 4.0971 | ["850","860"] | ["0.2417","0.2390"] | [] | ["BATO","EMLD","XPHO"] | 850.0000 | 860.0000 | 72 | 128 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:38:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |