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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5fc-0fff-7863-a89a-ee976b12ab66 | RDDT | 2026-09-18 15:26 | other | 4 | 1 | 1326 | 637806.00 | unknown | bid | 153.3000 | 0.7000 | ["130","141","152.5","157.5"] | ["8.7376","0.5353","1.5905","0.5333"] | [] | ["XPHO"] | 130.0000 | 157.5000 | 0 | 7 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5cf-bc57-78e3-9d95-b9c2bd0aad78 | RDDT | 2026-09-18 14:38 | put_calendar | 2 | 1 | 200 | 105600.00 | unknown | bid | 151.2500 | 0.5800 | ["145"] | ["0.5273"] | [] | ["EDGO"] | 145.0000 | 145.0000 | 7 | 14 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:38:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b534-91af-7510-980a-c31aa7f9b4b2 | RDDT | 2026-09-18 11:48 | other | 4 | 1 | 559 | 241488.00 | unknown | bid | 151.8150 | 0.6600 | ["155","157.5","162.5"] | ["0.5200","1.1616","0.8996"] | [] | ["XBOX"] | 155.0000 | 162.5000 | 0 | 7 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:48:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4df-64ff-72a2-b978-2fc6ea75bbcc | RDDT | 2026-09-18 10:15 | other | 4 | 1 | 425 | 213350.00 | unknown | ask | 152.2300 | 0.5600 | ["155","160","162.5","167.5"] | ["0.5539","1.1054","0.5690","1.5835"] | [] | ["XPHO"] | 155.0000 | 167.5000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:15:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d0-596f-7a50-997f-a013bb52ec86 | RDDT | 2026-09-18 09:59 | other | 4 | 1 | 300 | 133500.00 | unknown | ask | 151.7210 | 1.0000 | ["155","162.5","165","172.5"] | ["0.5370","0.5552","1.3819","2.1834"] | [] | ["SPHR"] | 155.0000 | 172.5000 | 0 | 7 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b1-403b-7723-806c-f1a43537b60d | RDDT | 2026-09-17 14:46 | other | 5 | 1 | 1053 | 20470746.00 | unknown | — | 151.3300 | 14.3500 | ["180","185","190","200","310"] | ["1.7312","2.8658","3.1726","1.1568","0.9509"] | [] | ["XBOX"] | 180.0000 | 310.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:47:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0af-928b-7ae3-8ed1-36c8e6434084 | RDDT | 2026-09-17 14:44 | put_vertical_spread | 2 | 1 | 180 | 1495800.00 | unknown | — | 151.4900 | 5.8500 | ["190","200"] | ["3.2730","3.3272"] | [] | ["XBOX"] | 190.0000 | 200.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:44:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0af-1973-7862-a28d-2fd5614fe4f8 | RDDT | 2026-09-17 14:44 | put_vertical_spread | 2 | 1 | 22 | 193820.00 | unknown | — | 151.5750 | 5.8000 | ["195","200"] | ["3.5557","3.4028"] | [] | ["XBOX"] | 195.0000 | 200.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:44:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc8-0533-7200-aebd-85420efc756c | RDDT | 2026-09-17 10:31 | put_vertical_spread | 2 | 1 | 140 | 101500.00 | unknown | — | 150.3450 | 0.5204 | ["144","150"] | ["0.5761","0.5714"] | [] | ["XMIO"] | 144.0000 | 150.0000 | 8 | 8 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:32:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afbb-5eeb-7cc3-9874-e3d6b12c7bcd | RDDT | 2026-09-17 10:18 | other | 4 | 1 | 310 | 178250.00 | unknown | — | 151.5500 | 0.6700 | ["155","162.5","165","172.5"] | ["0.5840","0.6077","0.9615","0.9343"] | [] | ["SPHR"] | 155.0000 | 172.5000 | 1 | 8 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:18:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb5-99d3-7770-8bfb-a1c7d6888ac9 | RDDT | 2026-09-16 15:33 | put_vertical_spread | 2 | 1 | 27 | 213030.00 | unknown | — | 157.1000 | 4.7000 | ["195","200"] | ["2.2976","2.3154"] | [] | ["XBOX"] | 195.0000 | 200.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:33:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abaa-6a8b-7d52-b99b-7fa6fa8f82de | RDDT | 2026-09-16 15:21 | put_vertical_spread | 2 | 1 | 23 | 178480.00 | unknown | — | 156.5600 | 5.3000 | ["195","200"] | ["1.8134","2.0126"] | [] | ["XBOX"] | 195.0000 | 200.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:21:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba8-e003-7d60-a3f7-473acc5afe6c | RDDT | 2026-09-16 15:19 | call_diagonal_spread | 2 | 2 | 220 | 127600.00 | unknown | — | 156.6500 | 0.9900 | ["157.5","165"] | ["0.7098","0.6108"] | [] | ["XMIO"] | 157.5000 | 165.0000 | 2 | 9 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:19:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a7-02ee-7b10-a4a3-3f82a52139fc | RDDT | 2026-09-15 15:59 | call_vertical_spread | 2 | 1 | 610 | 162870.00 | unknown | — | 159.5550 | 0.2600 | ["165","172.5"] | ["0.7094","0.7335"] | [] | ["XPHO"] | 165.0000 | 172.5000 | 3 | 3 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:59:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a66b-5596-7f72-bf45-4efbc6872d1f | RDDT | 2026-09-15 14:54 | put_vertical_spread | 2 | 1 | 240 | 1791360.00 | unknown | — | 159.7150 | 5.2000 | ["195","200"] | ["1.5944","1.6967"] | [] | ["XPHO"] | 195.0000 | 200.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:54:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0920d-68c1-71c0-b6c2-814f6eaa575c | RDDT | 2026-09-11 15:59 | other | 3 | 1 | 178 | 115344.00 | unknown | — | 157.7950 | 0.9300 | ["170","190","210"] | ["0.5768","0.5864","0.6074"] | [] | ["XCBO"] | 170.0000 | 210.0000 | 35 | 35 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:59:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091fa-2af8-7aa1-9ff2-edf86615629a | RDDT | 2026-09-11 15:38 | other | 4 | 1 | 250 | 205500.00 | unknown | — | 157.7800 | 0.8400 | ["157.5","162.5","165"] | ["0.8268","0.5311","3.6157"] | [] | ["XPHO"] | 157.5000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:38:09Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ee-d888-7e63-a296-26f5ac1aff05 | RDDT | 2026-09-11 15:25 | other | 4 | 1 | 250 | 153750.00 | unknown | — | 157.9400 | 0.4700 | ["157.5","160","165","167.5"] | ["1.0028","0.5385","2.7063","0.5424"] | [] | ["XPHO"] | 157.5000 | 167.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:25:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091de-2b01-7450-9f7e-c7e61c17b6d1 | RDDT | 2026-09-11 15:07 | other | 4 | 1 | 309 | 229896.00 | unknown | — | 156.9100 | 1.2300 | ["157.5","162.5"] | ["0.7676","1.1245"] | [] | ["XPHO"] | 157.5000 | 162.5000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:07:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c17-e198-7510-a4e1-2a8b7ce9bc80 | RDDT | 2026-09-10 12:12 | put_vertical_spread | 2 | 1 | 230 | 162380.00 | unknown | — | 156.3600 | 0.8000 | ["100","105"] | ["0.6829","0.6787"] | [] | ["XISX"] | 100.0000 | 105.0000 | 127 | 127 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:13:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08736-1c31-7af2-88b1-6aafdcf8a2dd | RDDT | 2026-09-09 13:27 | call_diagonal_spread | 2 | 1 | 20 | 114140.00 | unknown | — | 147.5400 | 3.2500 | ["140","145"] | ["0.6467","0.6625"] | [] | ["AMXO"] | 140.0000 | 145.0000 | 128 | 191 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:27:59Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ef-8db1-7813-811c-052454d0437c | RDDT | 2026-09-09 12:10 | other | 4 | 1 | 1537 | 1048234.00 | unknown | — | 145.6800 | 1.0800 | ["130","145","152.5","165"] | ["0.6437","0.6791","0.6415","0.9067"] | [] | ["AMXO"] | 130.0000 | 165.0000 | 2 | 9 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:11:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e3-6080-7323-b88c-4db78d680917 | RDDT | 2026-09-09 11:57 | other | 3 | 1 | 30 | 105480.00 | unknown | — | 145.8800 | 3.7500 | ["130","162.5"] | ["0.6382","0.7100"] | [] | ["AMXO"] | 130.0000 | 162.5000 | 2 | 9 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:57:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06d93-2f35-7633-beff-7c580eab9743 | RDDT | 2026-09-04 13:59 | call_vertical_spread | 2 | 1 | 175 | 114625.00 | unknown | — | 154.9900 | 1.2400 | ["149","155"] | ["1.3256","0.5701"] | [] | ["XPHO"] | 149.0000 | 155.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:59:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d51-6375-7fc0-ba38-d9dfdeae4e7c | RDDT | 2026-09-04 12:47 | other | 4 | 1 | 309 | 173658.00 | unknown | — | 155.4600 | 0.6400 | ["157.5","162.5","165"] | ["0.5744","0.5222","1.4858"] | [] | ["XPHO"] | 157.5000 | 165.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:47:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |