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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |