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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c53f-79f7-78d2-8390-ed6f1d1f33fc | EWZ | 2026-09-21 14:34 | call_vertical_spread | 2 | 1 | 3000 | 543092.00 | long | ask | 38.0350 | 0.2700 | ["39","41.5"] | ["0.4982","0.4846"] | ["39.77"] | ["XPHO"] | 39.0000 | 41.5000 | 18 | 18 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:34:29Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c50d-9c57-7e42-a952-2413ddd71b1b | EWZ | 2026-09-21 13:39 | call_vertical_spread | 2 | 1 | 3300 | 832168.00 | long | ask | 38.0550 | 0.1200 | ["41","43"] | ["0.5281","0.5156"] | ["41.58"] | ["EDGO"] | 41.0000 | 43.0000 | 39 | 39 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:40:05Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43e-2ade-7d60-8d86-f29428fbb9d1 | EWZ | 2026-09-21 09:53 | call_vertical_spread | 2 | 1 | 1500 | 264000.00 | long | ask | 37.7350 | 0.0500 | ["39","42"] | ["0.4556","0.4422"] | ["39.84"] | ["XISX"] | 39.0000 | 42.0000 | 25 | 25 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:53:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b02f-98d3-7eb3-ba80-e94532dddd71 | EWZ | 2026-09-17 12:25 | call_vertical_spread | 2 | 1 | 1400 | 158200.00 | long | ask | 37.7400 | 0.0400 | ["44","50"] | ["0.4446","0.4225"] | ["44.73"] | ["XCBO"] | 44.0000 | 50.0000 | 64 | 64 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:25:40Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00f-b8ab-7e40-9ce8-d467735bb48f | EWZ | 2026-09-17 11:50 | call_vertical_spread | 2 | 1 | 1400 | 155400.00 | long | ask | 37.6700 | 0.0400 | ["44","50"] | ["0.4440","0.4249"] | ["44.71"] | ["XMIO"] | 44.0000 | 50.0000 | 64 | 64 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:50:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af99-38bb-7f30-af5c-eb32eda5f6a6 | EWZ | 2026-09-17 09:40 | call_vertical_spread | 2 | 1 | 4000 | 536000.00 | long | ask | 37.0750 | 0.0400 | ["43","47"] | ["0.4473","0.4342"] | ["43.60"] | ["XMIO"] | 43.0000 | 47.0000 | 64 | 64 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:40:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab9f-75db-7f51-881d-adaa789918de | EWZ | 2026-09-16 15:09 | call_vertical_spread | 2 | 1 | 1100 | 113300.00 | long | ask | 37.3250 | 0.0400 | ["44","50"] | ["0.4427","0.4282"] | ["44.65"] | ["XMIO"] | 44.0000 | 50.0000 | 65 | 65 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:09:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7e-e6c3-7a90-aedf-bf2496ab0083 | EWZ | 2026-09-16 09:53 | ratio_risk_reversal | 2 | 1 | 3000 | 163199.00 | long | bid | 37.4300 | 0.0600 | ["38","43"] | ["0.4270","0.4292"] | ["43.13"] | ["XMIO"] | 38.0000 | 43.0000 | 30 | 30 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:54:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7e-cb6b-7c23-81fd-97a760bfd7d8 | EWZ | 2026-09-16 09:53 | call_vertical_spread | 2 | 1 | 2150 | 492350.00 | long | ask | 37.4300 | 0.0550 | ["41","45"] | ["0.4514","0.4377"] | ["41.93"] | ["EDGO"] | 41.0000 | 45.0000 | 65 | 65 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:54:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7a-8d7b-7a81-a0ca-fa39badae5a3 | EWZ | 2026-09-16 09:49 | call_vertical_spread | 2 | 3 | 456 | 101004.00 | long | ask | 37.5200 | 0.0500 | ["41","46"] | ["0.4522","0.4391"] | ["42.08"] | ["XBOX","XCBO","XISX"] | 41.0000 | 46.0000 | 65 | 65 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:49:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08717-5548-7f60-b5a4-98feddb6d146 | EWZ | 2026-09-09 12:54 | call_vertical_spread | 2 | 1 | 16600 | 879800.00 | long | ask | 38.1450 | 0.0400 | ["41","42"] | ["0.3210","0.3190"] | ["41.15"] | ["EDGO"] | 41.0000 | 42.0000 | 23 | 23 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:54:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e2-faf0-7c03-86d4-7ed6b872217f | EWZ | 2026-09-09 11:56 | call_vertical_spread | 2 | 1 | 6666 | 353298.00 | long | ask | 38.0550 | 0.0600 | ["41","42"] | ["0.3278","0.3248"] | ["41.15"] | ["EDGO"] | 41.0000 | 42.0000 | 23 | 23 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:56:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08685-0440-7330-a17d-bad251b2e308 | EWZ | 2026-09-09 10:14 | put_calendar | 2 | 1 | 375 | 247544.00 | long | ask | 38.2550 | 0.1700 | ["40"] | ["0.4127"] | [] | ["XPHO"] | 40.0000 | 40.0000 | 37 | 72 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:14:46Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0815b-d1b0-7b62-82bc-3826f157dff8 | EWZ | 2026-09-08 10:11 | call_diagonal_spread | 2 | 1 | 1500 | 433500.00 | long | ask | 39.0500 | 0.0800 | ["42","43"] | ["0.3880","0.3940"] | [] | ["XMIO"] | 42.0000 | 43.0000 | 38 | 101 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:11:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |