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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f4-ebe0-7310-af07-6d26ad68797d | IWM | 2026-09-18 15:18 | put_diagonal_spread | 2 | 2 | 30 | 103950.00 | long | ask | 283.6800 | 2.0600 | ["282","315"] | ["0.1516","0.2388"] | [] | ["C2OX"] | 282.0000 | 315.0000 | 7 | 119 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:18:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55f-d3e8-7d03-9ede-c4001398b204 | IWM | 2026-09-18 12:35 | put_diagonal_spread | 2 | 1 | 46 | 31464.00 | long | bid | 283.0100 | 0.0900 | ["279","285"] | ["0.1815","0.1492"] | [] | ["ARCO"] | 279.0000 | 285.0000 | 12 | 21 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:35:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55f-cc18-7123-994f-e57b5ab2a7f9 | IWM | 2026-09-18 12:35 | put_diagonal_spread | 2 | 1 | 46 | 31465.00 | long | bid | 282.9800 | 0.0800 | ["279","285"] | ["0.1812","0.1483"] | [] | ["ARCO"] | 279.0000 | 285.0000 | 12 | 21 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:35:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55f-c05f-7bd2-b794-8dd00a45ef0c | IWM | 2026-09-18 12:35 | put_diagonal_spread | 2 | 2 | 50 | 34200.00 | long | bid | 283.0150 | 0.1100 | ["279","285"] | ["0.1816","0.1489"] | [] | ["ARCO"] | 279.0000 | 285.0000 | 12 | 21 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:35:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55f-b88f-7ca0-815b-21dc306c8211 | IWM | 2026-09-18 12:35 | put_diagonal_spread | 2 | 2 | 42 | 28980.00 | long | bid | 282.8700 | 0.1000 | ["279","285"] | ["0.1808","0.1466"] | [] | ["XBOX"] | 279.0000 | 285.0000 | 12 | 21 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:35:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55f-b88f-7ca0-815b-21b0ffbb23d0 | IWM | 2026-09-18 12:35 | put_diagonal_spread | 2 | 2 | 517 | 359358.00 | long | bid | 282.8700 | 0.1000 | ["279","285"] | ["0.1812","0.1486"] | [] | ["XBOX"] | 279.0000 | 285.0000 | 12 | 21 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:35:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d5-56c7-7b90-9b0d-50acd172408b | IWM | 2026-09-18 10:04 | put_diagonal_spread | 2 | 2 | 280 | 119703.00 | unknown | bid | 282.9600 | 0.0679 | ["275","284"] | ["0.1981","0.1577"] | [] | ["ARCO","XISX"] | 275.0000 | 284.0000 | 7 | 28 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cf-385f-7962-a05f-8406c5a2a44a | IWM | 2026-09-18 09:57 | put_diagonal_spread | 2 | 2 | 80 | 32599.00 | unknown | bid | 283.2300 | 0.0600 | ["275","284"] | ["0.1974","0.1540"] | [] | ["ARCO","XISX"] | 275.0000 | 284.0000 | 7 | 28 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:58:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cd-63a0-7c61-8d5b-bf5825afeb57 | IWM | 2026-09-18 09:55 | put_diagonal_spread | 2 | 1 | 300 | 121020.00 | unknown | ask | 283.3100 | 0.1000 | ["275","284"] | ["0.1971","0.1555"] | [] | ["C2OX"] | 275.0000 | 284.0000 | 7 | 28 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:56:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c5-5520-7ed0-8b75-4a51bfe228be | IWM | 2026-09-18 09:47 | put_diagonal_spread | 2 | 1 | 51 | 28152.00 | unknown | ask | 283.8700 | 0.1300 | ["284","287"] | ["0.1539","0.2335"] | [] | ["XBOX"] | 284.0000 | 287.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:47:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-34e7-7271-8885-e5639db8de2d | IWM | 2026-09-18 09:39 | put_diagonal_spread | 2 | 1 | 174 | 151206.00 | long | ask | 283.9600 | 0.1400 | ["283","288"] | ["0.1763","0.2356"] | [] | ["C2OX"] | 283.0000 | 288.0000 | 0 | 28 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abc3-da43-7d03-8b2e-77acac05d28a | IWM | 2026-09-16 15:48 | put_diagonal_spread | 2 | 1 | 32 | 56416.00 | short | bid | 283.3000 | 0.1800 | ["287.5","291"] | ["0.1892","0.1724"] | [] | ["XISX"] | 287.5000 | 291.0000 | 16 | 44 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:49:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abae-c3d3-7250-94fa-759eda2387a9 | IWM | 2026-09-16 15:25 | put_diagonal_spread | 2 | 1 | 30 | 62340.00 | short | bid | 281.1300 | 0.3900 | ["285","290"] | ["0.2016","0.1833"] | [] | ["XISX"] | 285.0000 | 290.0000 | 23 | 65 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:26:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa6d-c7f3-7ec3-95d2-2bfb270a78e5 | IWM | 2026-09-16 09:35 | put_diagonal_spread | 2 | 1 | 41 | 32226.00 | unknown | — | 286.2200 | 0.3200 | ["288","289"] | ["0.1946","0.2735"] | [] | ["XISX"] | 288.0000 | 289.0000 | 2 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:35:21Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a683-561e-75c2-962e-311580d9493e | IWM | 2026-09-15 15:20 | put_diagonal_spread | 2 | 1 | 47 | 71581.00 | short | bid | 285.1500 | 0.1900 | ["291","292"] | ["0.1812","0.1840"] | [] | ["XISX"] | 291.0000 | 292.0000 | 9 | 17 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:20:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b9-ef85-7dc1-b292-b31147a89129 | IWM | 2026-09-15 11:40 | put_diagonal_spread | 2 | 1 | 20 | 25300.00 | unknown | — | 284.7700 | 0.3400 | ["287","292"] | ["0.1832","0.1874"] | [] | ["XISX"] | 287.0000 | 292.0000 | 6 | 14 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:40:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08cce-f8b0-7400-94e4-7361f4b47fad | IWM | 2026-09-10 15:32 | put_diagonal_spread | 2 | 4 | 86 | 82646.00 | long | bid | 287.5100 | 0.1500 | ["283","290"] | ["0.2321","0.2446"] | [] | ["XCBO"] | 283.0000 | 290.0000 | 8 | 22 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:32:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cce-f4c8-7682-b443-7de7b27619b9 | IWM | 2026-09-10 15:32 | put_diagonal_spread | 2 | 3 | 86 | 82646.00 | long | bid | 287.5100 | 0.1500 | ["283","290"] | ["0.2321","0.2446"] | [] | ["XCBO"] | 283.0000 | 290.0000 | 8 | 22 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:32:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cce-f4c8-7682-b443-7da0910c84cc | IWM | 2026-09-10 15:32 | put_diagonal_spread | 2 | 1 | 29 | 27869.00 | long | bid | 287.5050 | 0.1600 | ["283","290"] | ["0.2320","0.2445"] | [] | ["XISX"] | 283.0000 | 290.0000 | 8 | 22 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:32:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cce-f4c8-7682-b443-7d6828d3510a | IWM | 2026-09-10 15:32 | put_diagonal_spread | 2 | 3 | 58 | 55738.00 | long | bid | 287.5050 | 0.1269 | ["283","290"] | ["0.2320","0.2445"] | [] | ["XISX"] | 283.0000 | 290.0000 | 8 | 22 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:32:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c73-b180-71e2-b475-cdca61ddcb12 | IWM | 2026-09-10 13:53 | put_diagonal_spread | 2 | 1 | 33 | 27588.00 | long | bid | 287.7600 | 0.1100 | ["285","289"] | ["0.2258","0.2385"] | [] | ["XBOX"] | 285.0000 | 289.0000 | 8 | 15 | false | false | true | true | false | mesl | tracked | 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 |
| 01a08c73-b180-71e2-b475-cda2c062259b | IWM | 2026-09-10 13:53 | put_diagonal_spread | 2 | 8 | 160 | 133760.00 | long | bid | 287.7600 | 0.1100 | ["285","289"] | ["0.2258","0.2385"] | [] | ["AMXO","BATO","XCBO","XISX","XPHO"] | 285.0000 | 289.0000 | 8 | 15 | false | false | true | true | false | mesl | 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 |
| 01a08c73-b180-71e2-b475-cd4e8397e2cb | IWM | 2026-09-10 13:53 | put_diagonal_spread | 2 | 7 | 50 | 41800.00 | long | bid | 287.7650 | 0.1100 | ["285","289"] | ["0.2259","0.2387"] | [] | ["AMXO","BATO","EMLD","XCBO","XISX"] | 285.0000 | 289.0000 | 8 | 15 | false | false | true | true | false | mesl | tracked | 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 |
| 01a08bb4-4d68-7e83-95b2-4ab923f77343 | IWM | 2026-09-10 10:24 | put_diagonal_spread | 2 | 3 | 116 | 38744.00 | long | bid | 288.9300 | 0.0450 | ["270","284"] | ["0.2688","0.2515"] | [] | ["EDGO","XCBO","XISX"] | 270.0000 | 284.0000 | 8 | 20 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:24:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb4-1e88-7f40-8e6b-a615eba430ef | IWM | 2026-09-10 10:23 | put_diagonal_spread | 2 | 4 | 272 | 91664.00 | long | bid | 288.9000 | 0.0300 | ["270","284"] | ["0.2692","0.2522"] | [] | ["EDGO","XBOX","XCBO","XISX"] | 270.0000 | 284.0000 | 8 | 20 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:24:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087b0-5928-77a1-b7c5-d9c96d676016 | IWM | 2026-09-09 15:41 | put_diagonal_spread | 2 | 5 | 175 | 57050.00 | long | bid | 290.5250 | 0.0500 | ["287","291"] | ["0.1872","0.2266"] | [] | ["AMXO","BATO","EMLD","XISX"] | 287.0000 | 291.0000 | 2 | 5 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:41:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087b0-5928-77a1-b7c5-d9bec72cb024 | IWM | 2026-09-09 15:41 | put_diagonal_spread | 2 | 1 | 100 | 32600.00 | long | bid | 290.5250 | 0.0400 | ["287","291"] | ["0.1872","0.2266"] | [] | ["XISX"] | 287.0000 | 291.0000 | 2 | 5 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:41:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866c-1958-72d2-91c4-bd625a7f5d21 | IWM | 2026-09-09 09:47 | put_diagonal_spread | 2 | 3 | 363 | 56628.00 | long | bid | 292.9900 | 0.0300 | ["289","292"] | ["0.2525","0.2106"] | [] | ["ARCO","C2OX"] | 289.0000 | 292.0000 | 1 | 2 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:47:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |