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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a561-b596-7ab3-9ef0-ac6d49d50d57 | QCOM | 2026-09-15 10:03 | put_diagonal_spread | 2 | 1 | 26 | 158158.00 | long | ask | 189.1400 | 2.9500 | ["180","190"] | ["0.5140","0.5161"] | [] | ["XCBO"] | 180.0000 | 190.0000 | 275 | 367 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:04:15Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0b567-c328-71a1-8f96-02a8b3df35ff | QCOM | 2026-09-18 12:44 | put_diagonal_spread | 2 | 1 | 251 | 170680.00 | short | bid | 176.9300 | 0.2500 | ["175","180"] | ["0.4638","0.7985"] | [] | ["XISX"] | 175.0000 | 180.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:44:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59e-405f-7f43-9462-d0906a1220c1 | QCOM | 2026-09-18 13:44 | put_diagonal_spread | 2 | 1 | 26 | 133692.00 | long | ask | 178.2200 | 5.2500 | ["160","170"] | ["0.5332","0.5064"] | [] | ["BATO"] | 160.0000 | 170.0000 | 210 | 637 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:44:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a1-e20f-7fe0-8403-098a16a40bae | QCOM | 2026-09-18 13:47 | put_diagonal_spread | 2 | 1 | 21 | 124719.00 | unknown | bid | 178.0800 | 2.4000 | ["175","180"] | ["0.5182","0.5165"] | [] | ["ARCO"] | 175.0000 | 180.0000 | 272 | 364 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:48:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a2-6eaf-7252-9ceb-1c49634d73cf | QCOM | 2026-09-18 13:48 | put_diagonal_spread | 2 | 1 | 21 | 130410.00 | unknown | — | 177.9900 | 2.4000 | ["170","175"] | ["0.5242","0.5197"] | [] | ["AMXO"] | 170.0000 | 175.0000 | 364 | 490 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:49:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c51f-f3a7-7972-8453-1b6958492700 | QCOM | 2026-09-21 13:59 | put_diagonal_spread | 2 | 1 | 24 | 130800.00 | short | bid | 192.1900 | 1.5000 | ["180","190"] | ["0.5316","0.5386"] | [] | ["XISX"] | 180.0000 | 190.0000 | 179 | 361 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:00:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |