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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0a170-2cf8-74b3-9758-c5dd30d32ad5 | IWM | 2026-09-14 15:41 | call_vertical_spread | 2 | 1 | 3000 | 9402000.00 | unknown | — | 288.2200 | 1.4600 | ["270","275"] | ["0.4802","0.2259"] | [] | ["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-14T19:41:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a132-aae0-7c03-8026-ebb4acf24604 | IWM | 2026-09-14 14:34 | call_vertical_spread | 2 | 1 | 160 | 2272000.00 | unknown | — | 288.6000 | 3.2800 | ["215","220"] | ["1.7013","1.4411"] | [] | ["XPHO"] | 215.0000 | 220.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:34:22Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a131-7648-7c90-8f93-e4190dc7fbba | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5700 | 1.3300 | ["270","275"] | ["0.4762","0.2761"] | [] | ["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:33:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a131-5af0-7ee3-b357-0dc8411eea54 | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5650 | 1.3300 | ["270","275"] | ["0.4772","0.2778"] | [] | ["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 |
| 01a0a131-3bb0-78c0-9ed8-af9bb50e98ae | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5687 | 1.3300 | ["270","275"] | ["0.4765","0.2766"] | [] | ["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 |
| 01a0a131-2828-7d03-9f48-b77891490ea0 | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.6010 | 1.3300 | ["270","275"] | ["0.4702","0.2651"] | [] | ["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 |
| 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 |
| 01a0a130-f178-77e2-86ae-dc87f53d5b3a | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5700 | 1.3300 | ["270","275"] | ["0.4762","0.2761"] | [] | ["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 |
| 01a0a130-ddf0-7b81-bd4c-21140c0ef5a2 | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5750 | 1.3300 | ["270","275"] | ["0.4753","0.2745"] | [] | ["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 |
| 01a0a130-c680-7910-9eac-cf99d25c9b18 | IWM | 2026-09-14 14:32 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5500 | 1.3300 | ["270","275"] | ["0.4801","0.2826"] | [] | ["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 |
| 01a0a130-b2f8-7801-8eec-ac284e712f68 | IWM | 2026-09-14 14:31 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5250 | 1.3400 | ["270","275"] | ["0.4848","0.2900"] | [] | ["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 |
| 01a0a130-9f70-79f0-947d-0f1274bbeceb | IWM | 2026-09-14 14:31 | call_vertical_spread | 2 | 1 | 2400 | 7732800.00 | unknown | — | 288.5400 | 1.3400 | ["270","275"] | ["0.4820","0.2856"] | [] | ["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 |
| 01a08bb7-4ef0-7250-9056-043e9ba8e54b | IWM | 2026-09-10 10:27 | call_vertical_spread | 2 | 1 | 6000 | 684000.00 | unknown | — | 289.5700 | 0.0200 | ["292","295"] | ["0.3004","0.3000"] | [] | ["AMXO"] | 292.0000 | 295.0000 | 1 | 1 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:27:46Z"} | 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 |
| 01a0825c-bb38-76f0-a1b5-ba14c0806ced | IWM | 2026-09-08 14:51 | call_vertical_spread | 2 | 1 | 4934 | 2501538.00 | unknown | — | 295.3699 | 0.1800 | ["304","312"] | ["0.1562","0.1513"] | [] | ["XPHO"] | 304.0000 | 312.0000 | 45 | 45 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:52:27Z"} | 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 |