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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b590-55e0-7a03-8a8a-45b2bb624c6b | EWZ | 2026-09-18 13:28 | call_vertical_spread | 2 | 2 | 3000 | 489000.00 | long | ask | 37.4400 | 0.0600 | ["39","42"] | ["0.4376","0.4232"] | ["39.79"] | ["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:29:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b574-d2e7-7ba0-9c6f-ed9c0bf979e7 | EWZ | 2026-09-18 12:58 | call_vertical_spread | 2 | 3 | 5280 | 942480.00 | long | ask | 37.4650 | 0.0750 | ["42","46"] | ["0.4489","0.4319"] | ["42.78"] | ["ARCO"] | 42.0000 | 46.0000 | 63 | 63 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:59:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b546-9ec8-7961-a462-197f4c33ebc1 | EWZ | 2026-09-18 12:08 | call_vertical_spread | 2 | 4 | 4600 | 991300.00 | short | bid | 37.3800 | 0.0650 | ["41","45"] | ["0.4489","0.4364"] | ["41.90"] | ["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-18T16:08:19Z"} | 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 |
| 01a0b4dd-3a4f-7a62-8d0b-506faf7f2d44 | EWZ | 2026-09-18 10:13 | call_vertical_spread | 2 | 2 | 4400 | 932800.00 | long | ask | 37.3150 | 0.0600 | ["41","45"] | ["0.4486","0.4369"] | ["41.88"] | ["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:13:14Z"} | 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 |
| 01a0b07c-16db-70a1-b439-8600abffae95 | EWZ | 2026-09-17 13:48 | call_vertical_spread | 2 | 1 | 1000 | 108000.00 | short | bid | 37.7850 | 0.0400 | ["46","50"] | ["0.3936","0.3882"] | ["46.44"] | ["AMXO"] | 46.0000 | 50.0000 | 92 | 92 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:49:18Z"} | 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 |
| 01a0aa7b-7fab-7133-9f45-8a06665bd35c | EWZ | 2026-09-16 09:50 | call_vertical_spread | 2 | 1 | 3800 | 1352800.00 | long | ask | 37.4800 | 0.0500 | ["40","41"] | ["0.4518","0.4483"] | ["40.34"] | ["ARCO"] | 40.0000 | 41.0000 | 65 | 65 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:50:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a178-eb41-7433-97c9-17258df62775 | EWZ | 2026-09-14 15:50 | call_vertical_spread | 2 | 1 | 5000 | 365000.00 | long | ask | 37.7900 | 0.0500 | ["42","45"] | ["0.4140","0.4109"] | ["42.37"] | ["XPHO"] | 42.0000 | 45.0000 | 32 | 32 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:51:02Z"} | 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 |
| 01a0a09f-9a70-7670-be7e-214571457f4d | EWZ | 2026-09-14 11:53 | call_vertical_spread | 2 | 1 | 20000 | 640000.00 | long | ask | 37.6600 | 0.0600 | ["41","42"] | ["0.3437","0.3437"] | ["41.10"] | ["XPHO"] | 41.0000 | 42.0000 | 18 | 18 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:53:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09f-4868-7a93-bda9-18d8d0e4c87e | EWZ | 2026-09-14 11:53 | call_vertical_spread | 2 | 1 | 20000 | 640000.00 | long | ask | 37.6550 | 0.0600 | ["41","42"] | ["0.3440","0.3440"] | ["41.10"] | ["ARCO"] | 41.0000 | 42.0000 | 18 | 18 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:53:18Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091c4-2ea9-7c12-9db8-c269a0cec35f | EWZ | 2026-09-11 14:39 | call_vertical_spread | 2 | 4 | 16000 | 1512000.00 | long | ask | 37.9350 | 0.0450 | ["47","48"] | ["0.4262","0.4230"] | ["47.12"] | ["ARCO"] | 47.0000 | 48.0000 | 70 | 70 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:39:35Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0910d-b3d0-7990-bbb5-730b6d5f85b3 | EWZ | 2026-09-11 11:19 | call_vertical_spread | 2 | 2 | 2100 | 905100.00 | short | bid | 38.3400 | 0.0800 | ["40","41"] | ["0.4346","0.4367"] | ["40.35"] | ["AMXO"] | 40.0000 | 41.0000 | 70 | 70 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:19:52Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 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 |
| 01a0815f-d120-7c13-b05e-4c75265fd97f | EWZ | 2026-09-08 10:15 | call_vertical_spread | 2 | 1 | 25000 | 5225000.00 | long | ask | 38.9300 | 0.0800 | ["44","50"] | ["0.3917","0.3858"] | ["45.05"] | ["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:15:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08157-bad0-7820-b90b-c8f377bbc0b1 | EWZ | 2026-09-08 10:06 | call_vertical_spread | 2 | 2 | 26000 | 6110000.00 | long | ask | 39.0850 | 0.1100 | ["44","50"] | ["0.3558","0.3558"] | ["45.09"] | ["AMXO"] | 44.0000 | 50.0000 | 129 | 129 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:06:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08151-7558-72d3-86d3-3ca2b8e3f121 | EWZ | 2026-09-08 09:59 | call_vertical_spread | 2 | 2 | 2600 | 101400.00 | long | ask | 38.9950 | 0.1000 | ["46","50"] | ["0.4170","0.4066"] | ["46.25"] | ["AMXO"] | 46.0000 | 50.0000 | 38 | 38 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:00:06Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08143-40a0-7cf1-b67f-cf053338f20b | EWZ | 2026-09-08 09:44 | call_vertical_spread | 2 | 1 | 20000 | 3300000.00 | short | bid | 38.9550 | 0.0900 | ["46","50"] | ["0.3859","0.3936"] | ["46.53"] | ["AMXO"] | 46.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-08T13:44:28Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dda-4285-7ba2-89fc-6238c7de4c57 | EWZ | 2026-09-04 15:16 | call_vertical_spread | 2 | 2 | 1500 | 466500.00 | long | ask | 37.8450 | 0.0300 | ["40","44"] | ["0.4138","0.4118"] | ["41.11"] | ["ARCO"] | 40.0000 | 44.0000 | 77 | 77 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:17:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |