Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a0f2-aff8-76f2-8bdc-e5b220a5994b | LITE | 2026-09-14 13:24 | other | 2 | 1 | 100 | 1021500.00 | unknown | — | 843.9850 | 8.3000 | ["860"] | ["0.8006"] | [] | ["XBOX"] | 860.0000 | 860.0000 | 4 | 18 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:25:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c9e-0570-7ed2-9f29-920f604476b7 | LITE | 2026-09-10 14:39 | other | 3 | 1 | 15 | 608820.00 | unknown | — | 945.2100 | 37.4000 | ["1130","1155","1180"] | ["2.8241","3.0498","3.2750"] | [] | ["XBOX"] | 1130.0000 | 1180.0000 | 1 | 1 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:39:30Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bad-5059-7421-9db2-4f0a387eb47b | LITE | 2026-09-10 10:16 | other | 3 | 2 | 120 | 420400.00 | unknown | — | 968.4200 | 13.3000 | ["250","270","280"] | ["0.8376","0.8365","0.8350"] | [] | ["AMXO"] | 250.0000 | 280.0000 | 498 | 498 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:16:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08222-84e1-7ab1-b2fc-6a287cd75e2d | LITE | 2026-09-08 13:48 | other | 4 | 1 | 360 | 7814640.00 | unknown | — | 987.1350 | 21.3000 | ["980","1240","1260","1600"] | ["0.7819","0.8460","0.8399","0.8693"] | [] | ["XBOX"] | 980.0000 | 1600.0000 | 38 | 101 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |