Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0ca87-2d1e-7670-9eee-89517e5191b0 | TECL | 2026-09-22 15:10 | call_diagonal_spread | 2 | 1 | 25 | 333625.00 | short | ask | 234.4400 | 4.9000 | ["140","270"] | ["0.7522","0.6815"] | [] | ["XMIO"] | 140.0000 | 270.0000 | 115 | 178 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:11:30Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca78-e8c6-73a0-9c6a-1d9d448e0a4c | TECL | 2026-09-22 14:55 | call_diagonal_spread | 2 | 1 | 8 | 213920.00 | short | bid | 233.5700 | 6.0000 | ["124.96","145"] | ["0.7431","0.6962"] | [] | ["XMIO"] | 124.9600 | 145.0000 | 486 | 850 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:55:34Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca00-c2f7-7f92-a2d6-8690f1e07e9d | TECL | 2026-09-22 12:43 | call_diagonal_spread | 2 | 1 | 10 | 168140.00 | long | ask | 231.7100 | 8.3000 | ["295","310"] | ["0.7099","0.7135"] | [] | ["XMIO"] | 295.0000 | 310.0000 | 815 | 850 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:44:16Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c977-3fd7-7ef1-9781-0a5686f09b1b | TECL | 2026-09-22 10:13 | call_diagonal_spread | 2 | 1 | 16 | 156032.00 | short | bid | 232.2900 | 5.5000 | ["260","340"] | ["0.6600","0.6888"] | [] | ["XCBO"] | 260.0000 | 340.0000 | 115 | 815 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:13:52Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c586-9516-7f73-b61c-e765d7f8473c | TECL | 2026-09-21 15:52 | call_diagonal_spread | 2 | 1 | 25 | 163850.00 | long | bid | 229.7544 | 5.3000 | ["230","275"] | ["0.6798","0.6753"] | [] | ["XCBO"] | 230.0000 | 275.0000 | 116 | 179 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:52:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c586-8577-78c2-8f7c-973c9149f7e7 | TECL | 2026-09-21 15:52 | call_diagonal_spread | 2 | 1 | 25 | 330750.00 | short | ask | 229.5700 | 5.8000 | ["125","280"] | ["1.3189","0.6709"] | [] | ["XPHO"] | 125.0000 | 280.0000 | 25 | 179 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:52:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c545-5dc6-7692-ae76-aabc903cf6fc | TECL | 2026-09-21 14:40 | call_diagonal_spread | 2 | 1 | 40 | 187040.00 | short | ask | 228.2500 | 4.3000 | ["230","260"] | ["0.6627","0.6423"] | [] | ["XCBO"] | 230.0000 | 260.0000 | 60 | 116 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:41:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c449-563f-76c2-b8a3-8ce4e9782844 | TECL | 2026-09-21 10:05 | call_diagonal_spread | 2 | 1 | 40 | 145360.00 | long | ask | 220.8100 | 4.9000 | ["220","230"] | ["0.6494","0.6724"] | [] | ["XCBO"] | 220.0000 | 230.0000 | 25 | 60 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:05:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b572-0810-7b01-ae52-0b93cac4dd01 | TECL | 2026-09-18 12:55 | call_diagonal_spread | 2 | 1 | 15 | 134925.00 | long | bid | 205.6900 | 2.3000 | ["160","185"] | ["6.5018","0.7096"] | [] | ["XMIO"] | 160.0000 | 185.0000 | 0 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:56:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d3-9d1b-7213-8323-8130786bc425 | TECL | 2026-09-17 15:24 | call_vertical_spread | 2 | 1 | 10 | 135160.00 | long | ask | 206.9601 | 6.3000 | ["290","295"] | ["0.6940","0.6950"] | ["290.90"] | ["XCBO"] | 290.0000 | 295.0000 | 820 | 820 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:24:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab03-ab0b-7391-99f0-ea091fae24e9 | TECL | 2026-09-16 12:18 | call_diagonal_spread | 2 | 1 | 7 | 104755.00 | unknown | — | 198.8450 | 3.1000 | ["124.96","125"] | ["3.3231","1.0173"] | [] | ["XMIO"] | 124.9600 | 125.0000 | 2 | 30 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:19:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a579-a296-7912-9661-b1bf39742c35 | TECL | 2026-09-15 10:30 | call_diagonal_spread | 2 | 1 | 15 | 197940.00 | short | bid | 194.8500 | 3.5000 | ["130","140"] | ["2.1115","0.8073"] | [] | ["XCBO"] | 130.0000 | 140.0000 | 3 | 122 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:30:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a04b-c968-7bb1-be34-9a5424f85880 | TECL | 2026-09-14 10:21 | call_vertical_spread | 2 | 1 | 10 | 120760.00 | long | ask | 193.5350 | 6.5000 | ["300","315"] | ["0.7359","0.7369"] | ["302.44"] | ["EDGO"] | 300.0000 | 315.0000 | 823 | 823 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:21:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c1f-bd50-7000-bff9-c7bc1f61b568 | TECL | 2026-09-10 12:21 | call_vertical_spread | 2 | 1 | 200 | 2036600.00 | long | ask | 199.4050 | 2.6000 | ["165","176.96"] | ["0.7836","0.7667"] | ["172.21"] | ["XCBO"] | 165.0000 | 176.9600 | 127 | 127 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:21:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bad-0a08-7782-bcb0-e37d3e0b8114 | TECL | 2026-09-10 10:16 | call_vertical_spread | 2 | 1 | 10 | 122750.00 | long | ask | 198.0300 | 7.5000 | ["305","310"] | ["0.7119","0.7114"] | ["305.95"] | ["XMIO"] | 305.0000 | 310.0000 | 827 | 827 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:16:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a081e6-b848-7e82-a07e-f2b2e670655f | TECL | 2026-09-08 12:42 | call_diagonal_spread | 2 | 1 | 8 | 155252.00 | long | ask | 207.7100 | 4.5000 | ["114","115"] | ["1.0546","0.8792"] | [] | ["XCBO"] | 114.0000 | 115.0000 | 38 | 129 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:43:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0817d-ffb0-7e90-9cd9-2cfc1ea39880 | TECL | 2026-09-08 10:48 | put_vertical_spread | 2 | 1 | 10 | 121080.00 | short | bid | 207.0600 | 6.2000 | ["165","170"] | ["0.8550","0.8520"] | ["167.28"] | ["XCBO"] | 165.0000 | 170.0000 | 829 | 829 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:49:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |