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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56a-a0d7-7e40-9f7a-272f91c29ee7 | TJX | 2026-09-21 15:21 | other | 3 | 1 | 98 | 530680.00 | unknown | ask | 131.0700 | 7.9000 | ["150","155","175"] | ["0.4594","0.6879","0.3685"] | [] | ["XBOX"] | 150.0000 | 175.0000 | 25 | 179 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:21:45Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5ff-1958-7f03-9881-336927dca4a0 | TJX | 2026-09-18 15:29 | other | 3 | 1 | 60 | 332960.00 | unknown | bid | 128.1600 | 8.6000 | ["150","155","175"] | ["0.4799","0.5213","0.3920"] | [] | ["XPHO"] | 150.0000 | 175.0000 | 28 | 182 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:30:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ab-3d2b-7931-ae07-50a0984cfbe4 | TJX | 2026-09-17 14:40 | other | 6 | 1 | 694 | 2485920.00 | unknown | — | 125.7100 | 14.4000 | ["131","132","140","145","165"] | ["1.1447","0.7199","2.4078","2.1516","0.8703"] | [] | ["XBOX"] | 131.0000 | 165.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:40:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba5-e64b-7010-ae8f-d77a234e3126 | TJX | 2026-09-16 15:16 | other | 6 | 1 | 683 | 2875720.00 | unknown | — | 123.6000 | 13.5000 | ["140","145","150","155"] | ["1.0433","1.3656","0.9298","1.5031"] | [] | ["XBOX"] | 140.0000 | 155.0000 | 2 | 30 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:16:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a158-c0e0-75e3-9110-8413ebb42bd3 | TJX | 2026-09-14 15:15 | other | 6 | 1 | 1167 | 4492704.00 | unknown | — | 126.2600 | 10.0000 | ["140","145","150","155"] | ["0.7730","0.9567","0.8680","1.3384"] | [] | ["XBOX"] | 140.0000 | 155.0000 | 4 | 32 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:16:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a158-a970-7041-b024-f50b1ea7c6b4 | TJX | 2026-09-14 15:15 | other | 2 | 1 | 52 | 243360.00 | unknown | — | 126.2550 | 3.4000 | ["145","155"] | ["1.0785","0.3724"] | [] | ["XBOX"] | 145.0000 | 155.0000 | 4 | 32 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:16:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a154-11a8-7641-b143-b72348d717ed | TJX | 2026-09-14 15:10 | other | 6 | 1 | 790 | 3112280.00 | unknown | — | 126.2000 | 11.1000 | ["140","145","150","155"] | ["0.7507","1.0601","0.8439","1.1698"] | [] | ["XBOX"] | 140.0000 | 155.0000 | 4 | 32 | false | false | true | 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 |
| 01a08c9e-e800-76f3-99d5-6f4232e8cca6 | TJX | 2026-09-10 14:40 | other | 4 | 1 | 960 | 2285880.00 | unknown | — | 126.3100 | 6.2000 | ["131","140","145","155"] | ["0.4935","0.5725","0.1949","1.0128"] | [] | ["XBOX"] | 131.0000 | 155.0000 | 1 | 36 | true | 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 |