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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b617-5c48-7fa0-8b5f-d7d5fa2b1cd5 | IWM | 2026-09-18 15:56 | other | 6 | 1 | 5000 | 1463000.00 | unknown | bid | 283.8950 | 0.1900 | ["260","262","270","272","280","282"] | ["0.2487","0.2496","0.2051","0.2008","0.1603","0.1631"] | [] | ["XPHO"] | 260.0000 | 282.0000 | 12 | 14 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:56:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55b-bd07-7681-9502-92adf22bd555 | IWM | 2026-09-18 12:31 | straddle | 2 | 1 | 350 | 74900.00 | short | bid | 282.8100 | 0.1200 | ["285"] | ["0.2577"] | ["282.86","287.14"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:31:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51b-7fb8-7061-bec0-46e90555051f | IWM | 2026-09-18 11:21 | put_diagonal_spread | 2 | 1 | 3300 | 1116000.00 | unknown | bid | 282.9650 | 0.1200 | ["278","285"] | ["0.1828","0.1465"] | [] | ["XBOX"] | 278.0000 | 285.0000 | 7 | 14 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:21:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b518-ad0f-7a60-8b51-3f6db93cd483 | IWM | 2026-09-18 11:18 | put_diagonal_spread | 2 | 2 | 1264 | 1319616.00 | unknown | bid | 282.8550 | 0.2600 | ["265","275"] | ["0.2242","0.1947"] | [] | ["AMXO"] | 265.0000 | 275.0000 | 28 | 182 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:18:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ed-18cf-76d1-be38-9cde49f92350 | IWM | 2026-09-18 10:30 | put_vertical_spread | 2 | 1 | 490 | 694820.00 | short | bid | 283.2200 | 0.1100 | ["270","280"] | ["0.2182","0.2043"] | ["277.02"] | ["XPHO"] | 270.0000 | 280.0000 | 91 | 91 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:30:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b053-2a4c-7f00-949e-4bc9a7d51db0 | IWM | 2026-09-17 13:03 | straddle | 2 | 2 | 200 | 430000.00 | short | bid | 286.8100 | 0.1900 | ["290"] | ["0.1872"] | ["268.50","311.50"] | ["AMXO"] | 290.0000 | 290.0000 | 92 | 92 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:04:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afef-bd2a-70a0-9dea-04d38f5193ba | IWM | 2026-09-17 11:15 | synthetic | 2 | 1 | 317 | 1689610.00 | long | bid | 286.9300 | 2.0400 | ["300"] | ["0.2099"] | ["298.54"] | ["XPHO"] | 300.0000 | 300.0000 | 456 | 456 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:15:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb9-9173-7040-b945-0842c161d08e | IWM | 2026-09-16 15:37 | put_condor | 4 | 1 | 1786 | 2465931.00 | short | bid | 282.1138 | 0.1800 | ["255","265","275","285"] | ["0.2805","0.2515","0.2199","0.1899"] | ["257.53","282.47"] | ["XBOX"] | 255.0000 | 285.0000 | 30 | 30 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:37:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a1-55ce-70e2-ba8c-330388d16d88 | IWM | 2026-09-15 15:53 | put_vertical_spread | 2 | 1 | 1400 | 991200.00 | short | bid | 284.7450 | 0.0700 | ["280","285"] | ["0.2141","0.1939"] | ["283.36"] | ["XBOX"] | 280.0000 | 285.0000 | 15 | 15 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:53:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60d-5715-78f0-ac00-68c10e66c630 | IWM | 2026-09-15 13:11 | ratio_risk_reversal | 2 | 2 | 1200 | 156000.00 | long | bid | 285.2400 | 0.0400 | ["280","290"] | ["0.2963","0.2467"] | ["279.14"] | ["AMXO"] | 280.0000 | 290.0000 | 3 | 3 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a131-14a0-78a1-a531-6f8094e8f278 | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7800000.00 | short | bid | 288.5900 | 1.3300 | ["270","275"] | ["0.2970","0.2242"] | ["275"] | ["XPHO"] | 270.0000 | 275.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:32:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a075-fe18-7c30-ab7d-1c3ce8889818 | IWM | 2026-09-14 11:07 | put_vertical_spread | 2 | 1 | 200 | 107600.00 | short | bid | 287.6000 | 0.1800 | ["287","289"] | ["0.2955","0.2894"] | ["288"] | ["SPHR"] | 287.0000 | 289.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:08:07Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090e8-3240-7d40-9780-b551c1fc289c | IWM | 2026-09-11 10:38 | put_diagonal_spread | 2 | 1 | 100 | 50200.00 | short | bid | 288.8101 | 0.2800 | ["290","291"] | ["0.1824","0.2173"] | [] | ["SPHR"] | 290.0000 | 291.0000 | 0 | 4 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:38:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c7b-b448-7923-a01b-35f4d5cb9991 | IWM | 2026-09-10 14:01 | risk_reversal | 2 | 2 | 500 | 262000.00 | long | bid | 287.7800 | 0.1000 | ["285","290"] | ["0.2458","0.1944"] | ["284.60"] | ["AMXO"] | 285.0000 | 290.0000 | 8 | 8 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:02:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c77-5b00-79c2-b47d-854db5875db6 | IWM | 2026-09-10 13:57 | put_calendar | 2 | 1 | 75 | 77325.00 | short | bid | 287.6950 | 0.2700 | ["292"] | ["0.2629"] | [] | ["SPHR"] | 292.0000 | 292.0000 | 1 | 5 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:57:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0821e-1810-7bd1-b65d-747f8b481bca | IWM | 2026-09-08 13:43 | put_diagonal_spread | 2 | 2 | 700 | 112700.00 | long | bid | 295.9350 | 0.0300 | ["283","293"] | ["0.2367","0.1978"] | [] | ["AMXO"] | 283.0000 | 293.0000 | 3 | 10 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:44:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b8-af20-7a12-bdc6-d6251adfab3b | IWM | 2026-09-08 11:52 | straddle | 2 | 1 | 800 | 692000.00 | short | bid | 295.5800 | 0.2100 | ["290"] | ["0.1848"] | ["281.35","298.65"] | ["XBOX"] | 290.0000 | 290.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:52:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 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 |