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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c460-510f-77d1-b513-ed031a4dcede | DOW | 2026-09-21 10:30 | put_ratio_spread | 2 | 1 | 3350 | 250100.00 | unknown | bid | 28.1600 | 0.1600 | ["27","27.5"] | ["0.4059","0.3928"] | ["27.33"] | ["SPHR"] | 27.0000 | 27.5000 | 11 | 11 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:30:48Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b572-c38f-7f93-b614-3a92e55c0c3d | DOW | 2026-09-18 12:56 | strangle | 2 | 1 | 1500 | 1335000.00 | short | bid | 28.5200 | 0.9000 | ["30","35"] | ["0.4571","0.3576"] | ["21.10","43.90"] | ["AMXO"] | 30.0000 | 35.0000 | 490 | 490 | false | false | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:56:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ae-717b-7751-b9d6-8494b2eb8466 | DOW | 2026-09-17 14:43 | put_vertical_spread | 2 | 1 | 3366 | 4577760.00 | unknown | — | 29.6350 | 1.1000 | ["35","37.5"] | ["2.4490","3.1487"] | [] | ["XBOX"] | 35.0000 | 37.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:44:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0aa-3b5a-76d3-b1c3-cc9a6321a263 | DOW | 2026-09-17 14:38 | other | 4 | 1 | 354 | 425140.00 | unknown | — | 29.6550 | 4.1900 | ["32","32.5","37.5","42.5"] | ["2.4219","1.6753","4.0970","7.4322"] | [] | ["XBOX"] | 32.0000 | 42.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:39:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-74fa-7f43-a6a5-bf3dd59589f7 | DOW | 2026-09-17 14:31 | other | 4 | 1 | 4300 | 6153200.00 | unknown | — | 29.7200 | 4.7500 | ["35","37.5","40","42.5"] | ["2.6848","3.6266","6.3905","7.5360"] | [] | ["XBOX"] | 35.0000 | 42.5000 | 1 | 1 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a5a7-7126-7bb2-a993-e57c9c3007f7 | DOW | 2026-09-15 11:20 | put_diagonal_spread | 2 | 1 | 6700 | 275000.00 | unknown | — | 29.7050 | 0.1500 | ["27.5","28.5"] | ["0.4079","0.6109"] | [] | ["XPHO"] | 27.5000 | 28.5000 | 3 | 17 | true | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:20:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091fe-5560-7750-8d72-f47408c581be | DOW | 2026-09-11 15:42 | other | 2 | 1 | 10000 | 1060000.00 | unknown | — | 28.9650 | 0.0600 | ["32","32.5"] | ["0.4382","0.4310"] | [] | ["XPHO"] | 32.0000 | 32.5000 | 7 | 70 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:42:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c9a-e4a8-7d71-a8b6-4548eb648ee8 | DOW | 2026-09-10 14:35 | other | 3 | 1 | 290 | 272152.00 | unknown | — | 29.7450 | 2.0200 | ["31.5","32","37.5"] | ["1.6622","1.5426","1.2079"] | [] | ["XBOX"] | 31.5000 | 37.5000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:36:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06def-d9dd-77c0-9f4c-4abe7d026907 | DOW | 2026-09-04 15:40 | put_diagonal_spread_bullish | 2 | 1 | 10000 | 655000.00 | long | bid | 29.3518 | 0.1400 | ["27.5","29"] | ["0.4037","0.3552"] | [] | ["XPHO"] | 27.5000 | 29.0000 | 7 | 14 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:40:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |