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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0e7-1964-75a3-ba10-694d79681be9 | LULU | 2026-09-17 15:45 | other | 3 | 1 | 296 | 10185280.00 | unknown | — | 98.6000 | 7.5000 | ["220","280","300"] | ["0.9127","1.1700","1.3794"] | [] | ["XPHO"] | 220.0000 | 300.0000 | 92 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:45:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0aa-3773-7203-a76c-300f82140664 | LULU | 2026-09-17 14:38 | put_ladder | 3 | 1 | 94 | 371826.00 | unknown | — | 98.3300 | 5.9000 | ["115","118","127"] | ["2.9156","3.1743","4.5731"] | [] | ["XBOX"] | 115.0000 | 127.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:39:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a7-9f63-7510-b3ec-75681cd9d932 | LULU | 2026-09-17 14:36 | other | 8 | 1 | 984 | 9791700.00 | unknown | — | 98.2000 | 13.2000 | ["105","106","120","125","145","150","155","300"] | ["0.9528","1.8177","3.0853","0.7615","5.2694","5.5939","5.9024","1.5487"] | [] | ["XBOX"] | 105.0000 | 300.0000 | 1 | 92 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:36:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a153-f650-78f0-b876-5ea77c443973 | LULU | 2026-09-14 15:10 | other | 7 | 1 | 480 | 4926340.00 | unknown | — | 100.5600 | 14.9500 | ["120","135","140","145","150","160","185"] | ["1.3126","2.0986","2.2540","2.3370","2.4637","2.7911","3.4281"] | [] | ["XBOX"] | 120.0000 | 185.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:11:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08784-fb99-7172-97e4-faf2cd3c224e | LULU | 2026-09-09 14:53 | other | 2 | 2 | 300 | 272700.00 | unknown | — | 100.5000 | 0.3900 | ["100"] | ["0.4214"] | [] | ["AMXO"] | 100.0000 | 100.0000 | 9 | 72 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:53:52Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08769-e218-78d0-b6bf-3de164256165 | LULU | 2026-09-09 14:24 | put_vertical_spread | 2 | 1 | 956 | 43278120.00 | unknown | — | 100.5200 | 5.2500 | ["300","350"] | ["1.5169","1.6923"] | [] | ["XBOX"] | 300.0000 | 350.0000 | 100 | 100 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:24:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0871c-71e0-7e52-bdc7-ccfb7023b326 | LULU | 2026-09-09 12:59 | other | 2 | 2 | 650 | 2767625.00 | unknown | — | 99.4700 | 2.8500 | ["110","120"] | ["0.5068","0.4994"] | [] | ["AMXO"] | 110.0000 | 120.0000 | 100 | 373 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:00:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06de1-3f95-7c52-b366-97e8a4db8dd8 | LULU | 2026-09-04 15:24 | other | 2 | 1 | 500 | 1737500.00 | unknown | — | 100.2000 | 3.2000 | ["140"] | ["0.5035"] | [] | ["XBOX"] | 140.0000 | 140.0000 | 469 | 833 | true | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:24:53Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |