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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c463-7d8f-7690-b257-35fda730c10b | EWZ | 2026-09-21 10:34 | other | 3 | 1 | 10000 | 1975000.00 | unknown | — | 37.8450 | 0.0900 | ["31","34"] | ["0.4665","0.4587"] | [] | ["XPHO"] | 31.0000 | 34.0000 | 25 | 60 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:34:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b61a-80f8-73c0-989d-ae1c3be8c8e0 | EWZ | 2026-09-18 15:59 | other | 3 | 1 | 6000 | 1855200.00 | unknown | ask | 37.5200 | 0.2100 | ["40","41","45"] | ["0.4006","0.4497","0.4373"] | [] | ["SPHR"] | 40.0000 | 45.0000 | 63 | 91 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59c-ec88-7db2-ab3d-df4d7e240ba9 | EWZ | 2026-09-18 13:42 | call_vertical_spread | 2 | 1 | 1000 | 163000.00 | unknown | ask | 37.4150 | 0.0600 | ["39","42"] | ["0.4401","0.4249"] | ["40.63"] | ["ARCO"] | 39.0000 | 42.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:43:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f5-274f-7c21-994a-262f803bb407 | EWZ | 2026-09-18 10:39 | call_vertical_spread | 2 | 2 | 4400 | 902000.00 | unknown | bid | 37.2600 | 0.0500 | ["41","45"] | ["0.4450","0.4319"] | ["43.05"] | ["ARCO"] | 41.0000 | 45.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:39:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ce-5d9f-76f1-bd5b-6e562f89c34f | EWZ | 2026-09-18 09:56 | call_vertical_spread | 2 | 1 | 4400 | 948200.00 | unknown | ask | 37.3400 | 0.0600 | ["41","45"] | ["0.4497","0.4406"] | ["43.16"] | ["XBOX"] | 41.0000 | 45.0000 | 63 | 63 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:57:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afe9-7b9c-7eb3-9a0f-b38d2c9409fc | EWZ | 2026-09-17 11:08 | call_ladder | 3 | 4 | 35000 | 5950332.00 | unknown | — | 37.5350 | 0.0700 | ["42","47","51"] | ["0.3958","0.3930","0.3853"] | [] | ["AMXO"] | 42.0000 | 51.0000 | 92 | 92 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:08:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afde-d123-7f13-ac6f-a9fc0dc2c801 | EWZ | 2026-09-17 10:56 | call_diagonal_spread | 2 | 2 | 10000 | 850000.00 | unknown | — | 37.5450 | 0.1700 | ["40","42"] | ["0.4565","0.4188"] | [] | ["ARCO"] | 40.0000 | 42.0000 | 22 | 29 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:57:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb5-cc9b-7471-9643-9c3a10a48824 | EWZ | 2026-09-16 15:33 | call_vertical_spread | 2 | 1 | 1700 | 382500.00 | unknown | — | 37.4000 | 0.0400 | ["41","45"] | ["0.4465","0.4390"] | [] | ["XPHO"] | 41.0000 | 45.0000 | 65 | 65 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:33:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab71-515b-7f51-a9ed-7816f432e18c | EWZ | 2026-09-16 14:18 | call_vertical_spread | 2 | 1 | 2401 | 470596.00 | unknown | — | 37.6500 | 0.0600 | ["42","46"] | ["0.4465","0.4367"] | [] | ["XPHO"] | 42.0000 | 46.0000 | 65 | 65 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:18:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa90-47fa-7f23-8922-3807686ddfb8 | EWZ | 2026-09-16 10:12 | call_ladder | 3 | 1 | 3150 | 822150.00 | unknown | — | 37.5050 | 0.0900 | ["41","45","49"] | ["0.4502","0.4412","0.4326"] | [] | ["SPHR"] | 41.0000 | 49.0000 | 65 | 65 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:13:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5bd-db6e-7302-a194-20fafcf4b9c3 | EWZ | 2026-09-15 11:44 | other | 4 | 1 | 65020 | 6369660.00 | unknown | — | 37.9800 | 0.4000 | ["41","42"] | ["0.3701","0.3888"] | [] | ["XPHO"] | 41.0000 | 42.0000 | 17 | 24 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:44:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5aa-3046-7c60-b318-a442028baa9d | EWZ | 2026-09-15 11:23 | other | 4 | 1 | 2000 | 1334000.00 | unknown | — | 37.9080 | 0.3000 | ["33","43"] | ["0.4212","0.3630"] | [] | ["XPHO"] | 33.0000 | 43.0000 | 66 | 275 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:23:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a8-6f0e-7bc3-9607-8a5b5bd24e4a | EWZ | 2026-09-15 11:21 | other | 4 | 4 | 12000 | 2763000.00 | unknown | — | 37.8700 | 0.0800 | ["41","45","46","50"] | ["0.4484","0.4080","0.4919","0.4895"] | [] | ["AMXO"] | 41.0000 | 50.0000 | 66 | 66 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:21:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a12d-e438-70a3-a519-b5d7cd53ec54 | EWZ | 2026-09-14 14:28 | other | 2 | 1 | 6000 | 860000.00 | unknown | — | 37.6950 | 0.0300 | ["42","50"] | ["0.4451","0.4362"] | [] | ["AMXO"] | 42.0000 | 50.0000 | 67 | 67 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:29:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0cd-9fb1-7f62-8966-9e75316366c0 | EWZ | 2026-09-14 12:43 | call_vertical_spread | 2 | 1 | 9000 | 760500.00 | unknown | — | 37.8450 | 0.0600 | ["42","44"] | ["0.4148","0.4147"] | [] | ["XPHO"] | 42.0000 | 44.0000 | 32 | 32 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:43:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c7-f291-7962-a265-17fbe0139709 | EWZ | 2026-09-14 12:37 | other | 4 | 1 | 20000 | 1698080.00 | unknown | — | 37.8001 | 0.1900 | ["41","42"] | ["0.3704","0.3707"] | [] | ["XPHO"] | 41.0000 | 42.0000 | 18 | 25 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:37:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ae-53f8-7260-bc65-18d92b6eb011 | EWZ | 2026-09-14 12:09 | other | 4 | 2 | 4200 | 1205400.00 | unknown | — | 37.6900 | 0.0900 | ["41","42","46"] | ["0.4102","0.4436","0.4316"] | [] | ["AMXO"] | 41.0000 | 46.0000 | 32 | 67 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:10:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091c8-68b0-7993-88b3-0e3b396653ec | EWZ | 2026-09-11 14:43 | other | 3 | 2 | 600 | 159300.00 | unknown | — | 37.9450 | 0.1100 | ["32","42","49"] | ["0.4394","0.3933","0.3818"] | [] | ["AMXO"] | 32.0000 | 49.0000 | 98 | 98 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:44:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c6b-2600-7e71-be20-ff87f74cdab3 | EWZ | 2026-09-10 13:43 | other | 2 | 1 | 4000 | 1008000.00 | unknown | — | 38.5850 | 2.1000 | ["42"] | ["0.4444"] | [] | ["XPHO"] | 42.0000 | 42.0000 | 43 | 50 | true | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:44:14Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd6-8338-74d2-a3c6-a87a91ef110c | EWZ | 2026-09-10 11:01 | call_vertical_spread | 2 | 2 | 2760 | 400200.00 | unknown | — | 38.7800 | 0.1900 | ["41","45"] | ["0.4000","0.3990"] | [] | ["AMXO"] | 41.0000 | 45.0000 | 36 | 36 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:01:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0873d-9a28-7713-9cdf-e3847b78a065 | EWZ | 2026-09-09 13:35 | other | 4 | 3 | 10000 | 5205000.00 | unknown | — | 38.1450 | 0.2700 | ["34","44"] | ["0.4150","0.3630"] | [] | ["AMXO"] | 34.0000 | 44.0000 | 100 | 281 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:36:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08220-f288-7c92-ba99-97c95dc30163 | EWZ | 2026-09-08 13:46 | other | 3 | 2 | 6000 | 2529000.00 | unknown | — | 38.5950 | 0.1200 | ["34","40","45"] | ["0.4381","0.3911","0.3911"] | [] | ["AMXO"] | 34.0000 | 45.0000 | 101 | 101 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:46:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c9-25f8-7fe2-a3f2-16b1062f9fa2 | EWZ | 2026-09-08 12:10 | other | 2 | 1 | 7500 | 768000.00 | unknown | — | 38.5800 | 0.0800 | ["45","50"] | ["0.3961","0.3966"] | [] | ["XPHO"] | 45.0000 | 50.0000 | 101 | 101 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:10:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0817d-0998-7bf2-b808-5abbbda23dd7 | EWZ | 2026-09-08 10:47 | call_condor | 4 | 2 | 25000 | 15225000.00 | unknown | — | 39.0300 | 0.1300 | ["40","42","46","50"] | ["0.4333","0.4305","0.4356","0.4330"] | [] | ["ARCO"] | 40.0000 | 50.0000 | 73 | 73 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:47:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0816d-61c8-70d1-b0ed-3bf27d4745a2 | EWZ | 2026-09-08 10:30 | call_vertical_spread | 2 | 1 | 12000 | 2604000.00 | unknown | — | 39.0000 | 0.0600 | ["44","50"] | ["0.3940","0.3922"] | [] | ["XPHO"] | 44.0000 | 50.0000 | 101 | 101 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:30:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |