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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d76-065d-7522-b228-41a890ed9245 | VRTX | 2026-09-04 13:27 | strangle | 2 | 1 | 50 | 413750.00 | long | ask | 548.8400 | 16.7000 | ["480","700"] | ["0.3367","0.3133"] | ["397.25","782.75"] | ["ARCO"] | 480.0000 | 700.0000 | 504 | 504 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:27:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08139-5978-76a2-97a5-771a7d3108bd | VRTX | 2026-09-08 09:33 | put_vertical_spread | 2 | 1 | 15 | 104025.00 | long | ask | 523.2050 | 16.5000 | ["550","565"] | ["0.4003","0.4717"] | ["550.43"] | ["XMIO"] | 550.0000 | 565.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:33:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08244-f160-7500-88db-78aa4eb857b5 | VRTX | 2026-09-08 14:25 | call_vertical_spread | 2 | 1 | 10 | 379600.00 | long | ask | 529.4000 | 14.0000 | ["340","350"] | ["0.4769","0.4649"] | ["349.62"] | ["XMIO"] | 340.0000 | 350.0000 | 101 | 101 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:26:06Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0a0c6-6421-76f3-8266-fcfd35ca5270 | VRTX | 2026-09-14 12:35 | put_diagonal_spread | 2 | 1 | 20 | 232300.00 | long | ask | 518.7500 | 11.9000 | ["540","560"] | ["0.3117","0.3280"] | [] | ["AMXO"] | 540.0000 | 560.0000 | 95 | 276 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:36:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c6-73c0-7bb0-a1fe-a05b4e97dfda | VRTX | 2026-09-14 12:35 | other | 2 | 2 | 20 | 233920.00 | unknown | — | 518.7500 | 11.8000 | ["540","560"] | ["0.3159","0.3300"] | [] | ["XPHO"] | 540.0000 | 560.0000 | 95 | 276 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:36:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0ab30-1a0b-7831-9ab1-4e0ffa2a663f | VRTX | 2026-09-16 13:07 | put_calendar | 2 | 2 | 22 | 109802.00 | short | bid | 513.5400 | 9.3000 | ["525"] | ["0.2920"] | [] | ["C2OX","EDGO"] | 525.0000 | 525.0000 | 37 | 44 | true | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:07:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab70-5373-7e42-82d6-3389ba78310f | VRTX | 2026-09-16 14:17 | call_vertical_spread | 2 | 1 | 20 | 152300.00 | long | ask | 514.7500 | 12.3000 | ["500","520"] | ["0.3230","0.3113"] | ["511.43"] | ["XMIO"] | 500.0000 | 520.0000 | 93 | 93 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:18:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0b4f4-3908-70f2-a71b-844e2f6053c5 | VRTX | 2026-09-18 10:38 | call_vertical_spread | 2 | 1 | 2 | 126788.00 | short | bid | 508.1351 | 12.3000 | ["190","195"] | ["20.0356","19.5455"] | ["195"] | ["XCBO"] | 190.0000 | 195.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:38:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c53b-304f-7bf1-9c14-46192cb8014b | VRTX | 2026-09-21 14:29 | strangle | 2 | 1 | 200 | 724000.00 | short | bid | 513.4200 | 10.1000 | ["510","540"] | ["0.2950","0.2943"] | ["473.80","576.20"] | ["AMXO"] | 510.0000 | 540.0000 | 60 | 60 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:30:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |