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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c491-28f7-71d0-b0a3-6b0dc0994bee | IWM | 2026-09-21 11:23 | straddle | 2 | 1 | 158 | 832660.00 | short | bid | 286.0600 | 2.0600 | ["300"] | ["0.2089"] | ["247.30","352.70"] | ["AMXO"] | 300.0000 | 300.0000 | 452 | 452 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:24:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43f-8a6f-7351-8231-ed3ce90bbc05 | IWM | 2026-09-21 09:54 | put_vertical_spread | 2 | 1 | 1027 | 768196.00 | short | bid | 285.3300 | 0.1000 | ["255","270"] | ["0.2450","0.2174"] | ["267.72"] | ["AMXO"] | 255.0000 | 270.0000 | 88 | 88 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:55:00Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b60e-4427-7420-88fc-0f5b9061c2aa | IWM | 2026-09-18 15:46 | synthetic | 2 | 2 | 478 | 55926.00 | short | ask | 283.8250 | 0.0800 | ["285"] | ["0.4754"] | ["283.85"] | ["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-18T19:46:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5cf-81c0-71b3-92a7-55073b061d68 | IWM | 2026-09-18 14:37 | synthetic | 2 | 2 | 478 | 76002.00 | short | ask | 283.4550 | 0.1200 | ["285"] | ["0.2735"] | ["283.45"] | ["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-18T18:38:05Z"} | 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 |
| 01a0b555-3910-7ac3-b163-035e05010eb5 | IWM | 2026-09-18 12:24 | synthetic | 2 | 1 | 250 | 61000.00 | short | ask | 282.5900 | 0.1200 | ["285"] | ["0.2281"] | ["282.60"] | ["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:24:25Z"} | 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 |
| 01a0b4e8-e2af-7b93-a20d-7b823154b4ba | IWM | 2026-09-18 10:25 | risk_reversal | 2 | 1 | 300 | 156900.00 | short | ask | 283.0900 | 0.0700 | ["275","290"] | ["0.1979","0.1595"] | ["274.95"] | ["XBOX"] | 275.0000 | 290.0000 | 28 | 28 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:26:11Z"} | 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 |
| 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 |
| 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 |
| 01a090ce-9f60-73d2-82c2-13c08aa3a31f | IWM | 2026-09-11 10:10 | synthetic | 2 | 1 | 500 | 2745000.00 | short | ask | 289.3800 | 2.8600 | ["300"] | ["0.2061"] | ["299.32"] | ["XBOX"] | 300.0000 | 300.0000 | 462 | 462 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:10:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 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 |
| 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 |
| 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 |