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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a081b6-78b9-76c0-a016-f12e7ddafd18 | IWM | 2026-09-08 11:50 | straddle | 2 | 1 | 500 | 347500.00 | short | bid | 295.5200 | 0.1000 | ["295"] | ["0.1775"] | ["288.05","301.95"] | ["XBOX"] | 295.0000 | 295.0000 | 10 | 10 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:50:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d91-1fdd-7243-8319-2e404b7e5d53 | IWM | 2026-09-04 13:57 | put_ladder | 3 | 2 | 225 | 66600.00 | short | ask | 295.1700 | 0.0500 | ["288","291","294"] | ["0.1627","0.1516","0.1412"] | ["291.90"] | ["AMXO"] | 288.0000 | 294.0000 | 7 | 7 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:57:53Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8d-3bc5-7033-8674-f26e8e64899f | IWM | 2026-09-04 13:52 | put_vertical_spread | 2 | 2 | 1800 | 140400.00 | unknown | — | 295.1200 | 0.0400 | ["280","290"] | ["0.2067","0.1540"] | [] | ["AMXO"] | 280.0000 | 290.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:53:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8d-3bc5-7033-8674-f25820d0c587 | IWM | 2026-09-04 13:52 | call_vertical_spread | 2 | 2 | 900 | 90000.00 | long | ask | 295.1200 | 0.0200 | ["296","297"] | ["0.0804","0.0790"] | ["296.32"] | ["AMXO"] | 296.0000 | 297.0000 | 4 | 4 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:53:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8c-8bfe-7dc2-9bdc-ced1d68b03eb | IWM | 2026-09-04 13:52 | other | 2 | 1 | 500 | 134450.00 | unknown | — | 295.1000 | 0.0800 | ["280","295"] | ["0.2064","0.1365"] | [] | ["XPHO"] | 280.0000 | 295.0000 | 7 | 28 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:52:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d35-f01d-7600-a47d-40e84698fad2 | IWM | 2026-09-04 12:17 | other | 4 | 1 | 1735 | 1030590.00 | unknown | — | 295.9950 | 0.0800 | ["250","270","280","290"] | ["0.3757","0.2257","0.2138","0.1872"] | [] | ["XBOX"] | 250.0000 | 290.0000 | 14 | 42 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:17:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d2f-50cd-7a50-a826-b456aa71a799 | IWM | 2026-09-04 12:10 | straddle | 2 | 1 | 500 | 365000.00 | short | bid | 295.7250 | 0.1500 | ["295"] | ["0.1570"] | ["287.70","302.30"] | ["XPHO"] | 295.0000 | 295.0000 | 14 | 14 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:10:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |