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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b090-8553-7e03-881c-26a6d44407cb | CLS | 2026-09-17 14:10 | call_vertical_spread | 2 | 1 | 14 | 439124.00 | unknown | — | 331.0200 | 9.5000 | ["170","180"] | ["2.2417","2.0846"] | [] | ["XCBO"] | 170.0000 | 180.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:11:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a150-9ed8-7581-87ec-bdd57f09184f | CLS | 2026-09-14 15:06 | other | 2 | 1 | 200 | 239025.00 | unknown | — | 320.1250 | 1.8000 | ["380","400"] | ["0.7091","0.6630"] | [] | ["XPHO"] | 380.0000 | 400.0000 | 32 | 67 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:07:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0912e-91e0-7b40-ada2-acf600f993e9 | CLS | 2026-09-11 11:55 | other | 2 | 1 | 5 | 115650.00 | unknown | — | 343.8800 | 12.8000 | ["280","330"] | ["0.7163","0.7179"] | [] | ["XMIO"] | 280.0000 | 330.0000 | 279 | 434 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:55:55Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08788-b4b8-7100-b000-c37e32112006 | CLS | 2026-09-09 14:57 | call_vertical_spread | 2 | 1 | 135 | 355050.00 | unknown | — | 334.7050 | 2.0000 | ["360","400"] | ["0.6380","0.6560"] | [] | ["XMIO"] | 360.0000 | 400.0000 | 37 | 37 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:58:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08248-b638-7870-b9ab-22559e0cf195 | CLS | 2026-09-08 14:29 | other | 3 | 1 | 64 | 175712.00 | unknown | — | 333.8650 | 6.2000 | ["322.5","332.5","350"] | ["0.7066","0.6538","0.6891"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:30:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08248-9ec8-7692-8e57-fa34c837fa32 | CLS | 2026-09-08 14:29 | other | 3 | 1 | 40 | 110720.00 | unknown | — | 333.8750 | 5.8000 | ["322.5","332.5","350"] | ["0.7034","0.6667","0.6942"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:29:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08248-8f28-70e1-94cc-63c8fa008f7e | CLS | 2026-09-08 14:29 | other | 3 | 1 | 40 | 110720.00 | unknown | — | 333.8750 | 5.8000 | ["322.5","332.5","350"] | ["0.7034","0.6667","0.6942"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:29:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08248-73d1-7932-8720-45e342eb1f0c | CLS | 2026-09-08 14:29 | other | 3 | 1 | 40 | 110512.00 | unknown | — | 333.8750 | 6.0000 | ["322.5","332.5","350"] | ["0.7053","0.6642","0.6921"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:29:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08248-4108-70e1-8030-c8114b0d6d68 | CLS | 2026-09-08 14:29 | other | 3 | 1 | 42 | 116235.00 | unknown | — | 333.9395 | 5.8000 | ["322.5","332.5","350"] | ["0.7023","0.6665","0.6916"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:29:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08248-21c8-7192-9e8c-516ffbaaeb37 | CLS | 2026-09-08 14:29 | other | 3 | 1 | 42 | 116256.00 | unknown | — | 333.9395 | 5.8000 | ["322.5","332.5","350"] | ["0.7028","0.6665","0.6916"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:29:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08247-ef00-7310-b1d9-82daf7fece0b | CLS | 2026-09-08 14:29 | other | 3 | 1 | 42 | 117222.00 | unknown | — | 333.9395 | 6.4000 | ["322.5","332.5","350"] | ["0.7062","0.6761","0.6960"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:29:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08247-8d59-75b0-a796-a67bf5d458d8 | CLS | 2026-09-08 14:28 | other | 3 | 1 | 42 | 117075.00 | unknown | — | 333.7100 | 6.5000 | ["322.5","332.5","350"] | ["0.7148","0.6818","0.6976"] | [] | ["XMIO"] | 322.5000 | 350.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:29:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dfd-ef55-7fc3-96b7-48c198d29f63 | CLS | 2026-09-04 15:55 | call_vertical_spread | 2 | 1 | 313 | 144293.00 | unknown | — | 312.5600 | 1.5000 | ["330","360"] | ["0.5944","0.5978"] | [] | ["AMXO"] | 330.0000 | 360.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |