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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b603-cc77-7a12-b262-20ef03280a16 | IWM | 2026-09-18 15:34 | other | 5 | 1 | 150 | 677100.00 | unknown | ask | 283.5600 | 2.8400 | ["284","286","290","297","305"] | ["0.1564","0.1380","0.1967","0.1327","0.1926"] | [] | ["XBOX"] | 284.0000 | 305.0000 | 7 | 154 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:34:57Z"} | 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 |
| 01a0b562-e128-78a3-a7d7-6d70a9db2e24 | IWM | 2026-09-18 12:39 | straddle | 2 | 2 | 672 | 145152.00 | long | ask | 282.8964 | 0.1300 | ["285"] | ["0.2362"] | ["282.84","287.16"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:39:40Z"} | 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 |
| 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 |
| 01a0b4dc-3880-7040-8f3a-cb312e8bc3d7 | IWM | 2026-09-18 10:12 | put_vertical_spread | 2 | 2 | 4000 | 2904000.00 | long | ask | 283.1700 | 0.1000 | ["255","275"] | ["0.2486","0.2065"] | ["271.66"] | ["AMXO"] | 255.0000 | 275.0000 | 63 | 63 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:12:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b08b-5d03-7080-9c18-6704c8ccc814 | IWM | 2026-09-17 14:05 | straddle | 2 | 1 | 600 | 646800.00 | long | ask | 286.5800 | 0.0800 | ["288"] | ["0.1670"] | ["277.22","298.78"] | ["AMXO"] | 288.0000 | 288.0000 | 29 | 29 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:05:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b042-1733-7b52-93e7-1d05abcc14d2 | IWM | 2026-09-17 12:45 | put_diagonal_spread | 2 | 2 | 5000 | 3380000.00 | long | ask | 287.1000 | 0.6100 | ["200","220"] | ["0.2952","0.2803"] | [] | ["AMXO"] | 200.0000 | 220.0000 | 273 | 456 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abad-6443-70e1-8182-b32bb78cfc17 | IWM | 2026-09-16 15:24 | put_vertical_spread | 2 | 1 | 50 | 93150.00 | long | ask | 281.2450 | 0.3700 | ["285","290"] | ["0.1921","0.1909"] | ["286.83"] | ["SPHR"] | 285.0000 | 290.0000 | 30 | 30 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:24:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba7-7c8b-7053-a56f-a00c85dbc7d3 | IWM | 2026-09-16 15:17 | put_vertical_spread | 2 | 1 | 49 | 84966.00 | long | ask | 282.1600 | 0.3500 | ["285","290"] | ["0.1900","0.1873"] | ["286.98"] | ["SPHR"] | 285.0000 | 290.0000 | 30 | 30 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba4-53f3-7c43-9f5e-55ca96909dc0 | IWM | 2026-09-16 15:14 | put_vertical_spread | 2 | 1 | 49 | 83741.00 | long | ask | 282.2400 | 0.2000 | ["285","290"] | ["0.1889","0.1833"] | ["287.07"] | ["SPHR"] | 285.0000 | 290.0000 | 30 | 30 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:14:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aacc-187b-7b02-b645-6b8a16ddf654 | IWM | 2026-09-16 11:18 | put_frontspread | 2 | 1 | 1500 | 161500.00 | long | ask | 286.3000 | 0.0200 | ["283","285"] | ["0.5914","0.5819"] | ["279.65","284.68"] | ["AMXO"] | 283.0000 | 285.0000 | 0 | 0 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:18:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a628-3dcd-7541-a78c-4ccfa4607047 | IWM | 2026-09-15 13:40 | put_butterfly_spread | 3 | 2 | 1000 | 259000.00 | long | ask | 285.2100 | 0.0800 | ["260","270","280"] | ["0.3068","0.2574","0.2175"] | ["261.06","278.94"] | ["AMXO"] | 260.0000 | 280.0000 | 15 | 15 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d3-094d-76b3-8755-0759baf1ed32 | IWM | 2026-09-15 12:07 | put_diagonal_spread | 2 | 2 | 500 | 772000.00 | long | ask | 284.4950 | 0.4000 | ["260","270"] | ["0.2400","0.2290"] | [] | ["AMXO"] | 260.0000 | 270.0000 | 94 | 275 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:08:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58b-4a1e-7ec1-a1aa-c4f334c0192e | IWM | 2026-09-15 10:49 | put_vertical_spread | 2 | 1 | 200 | 84200.00 | long | ask | 284.5100 | 0.0200 | ["280","285"] | ["0.2958","0.2667"] | ["283.31"] | ["SPHR"] | 280.0000 | 285.0000 | 3 | 3 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:49:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58a-e0a5-7191-8704-7ba34fcc719f | IWM | 2026-09-15 10:48 | put_vertical_spread | 2 | 1 | 200 | 100800.00 | long | ask | 284.5100 | 0.0300 | ["283","285"] | ["0.2757","0.2658"] | ["284.16"] | ["SPHR"] | 283.0000 | 285.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:49:17Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a17d-cd40-76f3-8a85-36b07a967889 | IWM | 2026-09-14 15:56 | call_vertical_spread | 2 | 1 | 2400 | 14731200.00 | long | ask | 287.9706 | 3.1000 | ["255","260"] | ["0.5643","0.4851"] | ["260"] | ["XPHO"] | 255.0000 | 260.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:56:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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 |
| 01a08c73-bd38-7f40-a14b-9310814ce0ae | IWM | 2026-09-10 13:53 | strangle | 2 | 2 | 750 | 501750.00 | long | ask | 287.7500 | 0.1800 | ["280","285"] | ["0.2639","0.2048"] | ["273.31","291.69"] | ["ARCO"] | 280.0000 | 285.0000 | 8 | 8 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:53:24Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08765-36c8-7282-bc65-9d7d0c255c16 | IWM | 2026-09-09 14:19 | call_vertical_spread | 2 | 1 | 60 | 259020.00 | long | ask | 291.0700 | 1.3500 | ["260","280"] | ["0.3118","0.2046"] | ["279.55"] | ["SPHR"] | 260.0000 | 280.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:19:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866e-f3d0-73f3-a775-2586b2f1a5d7 | IWM | 2026-09-09 09:50 | call_vertical_spread | 2 | 1 | 20000 | 980000.00 | long | ask | 292.9401 | 0.0600 | ["299","302"] | ["0.1565","0.1546"] | ["299.27"] | ["AMXO"] | 299.0000 | 302.0000 | 5 | 5 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0829e-6f88-7850-a665-0aca90ea3858 | IWM | 2026-09-08 16:03 | call_ratio_spread | 2 | 2 | 2000 | 607000.00 | long | ask | 294.6700 | 0.1200 | ["294","300"] | ["0.1647","0.1557"] | ["295.35","304.65"] | ["AMXO"] | 294.0000 | 300.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T20:05:18Z"} | 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-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 |