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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c594-ecf7-7800-80ce-2c1183922674 | IWM | 2026-09-21 16:07 | straddle | 2 | 2 | 1000 | 999000.00 | long | ask | 285.7300 | 0.1400 | ["287"] | ["0.1672"] | ["277.01","296.99"] | ["AMXO"] | 287.0000 | 287.0000 | 25 | 25 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T20:09:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |