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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0a6-3beb-7180-a3c6-fc76753820e9 | PDD | 2026-09-17 14:34 | other | 4 | 1 | 1498 | 5738300.00 | unknown | — | 77.9700 | 4.8500 | ["84","85","135"] | ["0.8700","0.9781","3.3684"] | [] | ["XBOX"] | 84.0000 | 135.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a6-247b-72b0-9345-03a32f495de1 | PDD | 2026-09-17 14:34 | other | 7 | 1 | 1870 | 7426000.00 | unknown | — | 77.9700 | 13.5000 | ["85","90","100","105","110","125","135"] | ["0.9781","2.0520","3.0866","3.5365","3.7282","0.7618","0.9118"] | [] | ["XBOX"] | 85.0000 | 135.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a6-0d0b-7da0-9d82-ac090c263a8f | PDD | 2026-09-17 14:34 | other | 8 | 1 | 1746 | 10564350.00 | unknown | — | 77.9650 | 13.9000 | ["85","90","115","120","130","150","155"] | ["0.9664","2.0457","3.7905","4.1263","4.7402","0.9648","0.9839"] | [] | ["XBOX"] | 85.0000 | 155.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a4-8a53-7a60-9340-e4ea32d3d5a7 | PDD | 2026-09-17 14:32 | put_vertical_spread | 2 | 1 | 51 | 235110.00 | unknown | — | 78.0000 | 3.5500 | ["95","110"] | ["2.4740","3.7962"] | [] | ["XBOX"] | 95.0000 | 110.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:33:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a1-bf7b-7a03-abec-4a5d7817580f | PDD | 2026-09-17 14:29 | put_ladder | 5 | 1 | 2230 | 11291200.00 | unknown | — | 78.0500 | 7.4500 | ["90","100","110","115","125"] | ["1.5529","3.2114","3.9012","4.0403","4.3726"] | [] | ["XBOX"] | 90.0000 | 125.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb7-0903-7d11-9c86-562eef7b8fd6 | PDD | 2026-09-16 15:34 | put_ladder | 5 | 1 | 1266 | 12287400.00 | unknown | — | 78.6800 | 13.1500 | ["100","110","115","130","135"] | ["2.1425","2.1475","4.5073","5.4110","5.6779"] | [] | ["XBOX"] | 100.0000 | 135.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb6-97bb-7600-853b-c24c0e2f24ce | PDD | 2026-09-16 15:34 | other | 4 | 1 | 348 | 3464730.00 | unknown | — | 78.7000 | 12.5500 | ["110","120","125","135"] | ["4.1696","4.3098","5.1408","0.8506"] | [] | ["XBOX"] | 110.0000 | 135.0000 | 2 | 121 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba5-c323-7cb1-ae67-7d96c8960f69 | PDD | 2026-09-16 15:15 | put_ladder | 5 | 1 | 1310 | 8306460.00 | unknown | — | 78.6250 | 12.5500 | ["90","100","115","120","135"] | ["2.0731","1.9376","4.4755","4.7949","5.6414"] | [] | ["XBOX"] | 90.0000 | 135.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:16:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08c9e-a980-73a1-98e0-9cfc3092737c | PDD | 2026-09-10 14:40 | other | 3 | 1 | 12 | 102300.00 | unknown | — | 77.5500 | 6.0000 | ["90","115","140"] | ["2.3438","2.0662","2.6472"] | [] | ["XBOX"] | 90.0000 | 140.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:40:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c9b-c738-71f1-aab6-da6fa80102a8 | PDD | 2026-09-10 14:36 | other | 7 | 1 | 1632 | 13849400.00 | unknown | — | 77.5550 | 12.9500 | ["100","110","115","125","130","135"] | ["0.9791","1.3455","2.0680","2.1460","2.2180","2.3386"] | [] | ["XBOX"] | 100.0000 | 135.0000 | 8 | 36 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:37:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c91-91f0-7360-9984-a66b53ca7181 | PDD | 2026-09-10 14:25 | strangle | 2 | 2 | 585 | 407745.00 | long | ask | 77.6100 | 0.6600 | ["65","110"] | ["0.3998","0.3861"] | ["58.03","116.97"] | ["AMXO"] | 65.0000 | 110.0000 | 280 | 280 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:26:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0826d-3210-7152-bf50-c187900135a9 | PDD | 2026-09-08 15:09 | other | 7 | 1 | 990 | 10546900.00 | unknown | — | 79.9200 | 14.4000 | ["100","110","115","120","125","130","135"] | ["1.1036","1.4388","1.6788","1.6905","1.9430","1.9307","2.0655"] | [] | ["XBOX"] | 100.0000 | 135.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08234-76a1-7990-9c2a-8c9c22ca9596 | PDD | 2026-09-08 14:07 | strangle | 2 | 1 | 250 | 316250.00 | short | bid | 79.9200 | 0.5500 | ["70","125"] | ["0.4035","0.3944"] | ["57.35","137.65"] | ["SPHR"] | 70.0000 | 125.0000 | 500 | 500 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:08:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |