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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c432-b15f-75f1-8355-3b5687ecfb4c | EWZ | 2026-09-21 09:40 | call_vertical_spread | 2 | 2 | 727 | 105780.00 | long | ask | 37.9050 | 0.0500 | ["44","50"] | ["0.4063","0.3862"] | ["44.87"] | ["AMXO","XPHO"] | 44.0000 | 50.0000 | 88 | 88 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:40:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c432-b15f-75f1-8355-3b4c1257eecf | EWZ | 2026-09-21 09:40 | call_vertical_spread | 2 | 1 | 1182 | 171390.00 | long | ask | 37.9050 | 0.0500 | ["44","50"] | ["0.4047","0.3877"] | ["44.85"] | ["EDGO"] | 44.0000 | 50.0000 | 88 | 88 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:40:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c429-52f3-7b10-a935-c6c6ed06b6e0 | EWZ | 2026-09-21 09:30 | call_vertical_spread | 2 | 3 | 239 | 176382.00 | short | bid | 37.9600 | 0.4500 | ["34","40"] | ["0.4634","0.4623"] | ["37.18"] | ["EDGO"] | 34.0000 | 40.0000 | 60 | 60 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:30:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b552-1847-7021-8a7b-edaf27a8c570 | EWZ | 2026-09-18 12:20 | put_calendar | 2 | 1 | 26 | 117806.00 | unknown | bid | 37.4200 | 7.7750 | ["60"] | ["0.7136"] | [] | ["XISX"] | 60.0000 | 60.0000 | 63 | 91 | true | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:21:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ee-781b-7520-9e32-7d46eaed8d1d | EWZ | 2026-09-17 15:53 | call_calendar | 2 | 1 | 1210 | 235345.00 | unknown | — | 37.7000 | 0.0500 | ["40"] | ["0.4305"] | [] | ["C2OX"] | 40.0000 | 40.0000 | 29 | 64 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:53:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ee-7433-7403-ba28-2a6389b8fc0d | EWZ | 2026-09-17 15:53 | call_calendar | 2 | 1 | 1054 | 205003.00 | unknown | — | 37.7000 | 0.0500 | ["40"] | ["0.4305"] | [] | ["C2OX"] | 40.0000 | 40.0000 | 29 | 64 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:53:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e7-6b6b-7521-8ab4-7fecb36b4604 | EWZ | 2026-09-17 15:45 | strangle | 2 | 1 | 500 | 143500.00 | long | ask | 37.7350 | 0.0500 | ["35","42"] | ["0.4533","0.4434"] | ["32.13","44.87"] | ["XISX"] | 35.0000 | 42.0000 | 64 | 64 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:45:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a08c66-8a50-7033-8f21-3b580fc86f5a | EWZ | 2026-09-10 13:38 | other | 2 | 8 | 1000 | 283188.00 | unknown | — | 38.6600 | 0.0500 | ["40"] | ["0.4005"] | [] | ["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 40.0000 | 40.0000 | 36 | 99 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:39:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c62-5c00-7b61-b8a0-08ed20eedf4d | EWZ | 2026-09-10 13:34 | other | 2 | 2 | 438 | 114756.00 | unknown | — | 38.6800 | 0.0957 | ["38","40"] | ["0.3319","0.4045"] | [] | ["XPHO"] | 38.0000 | 40.0000 | 8 | 36 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:34:35Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08780-5431-79d0-ba9e-0868919ed1c3 | EWZ | 2026-09-09 14:48 | other | 2 | 8 | 938 | 211673.00 | unknown | — | 37.9850 | 0.0600 | ["40"] | ["0.4074"] | [] | ["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 40.0000 | 40.0000 | 37 | 72 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:48:48Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08292-7520-7393-baf9-d66c2abc26f2 | EWZ | 2026-09-08 15:50 | call_diagonal_spread | 2 | 2 | 438 | 114756.00 | long | ask | 38.5900 | 0.0986 | ["38","40"] | ["0.3191","0.4011"] | [] | ["XPHO"] | 38.0000 | 40.0000 | 10 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:50:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0815f-f060-7e03-8000-aedfe4f31f74 | EWZ | 2026-09-08 10:15 | call_vertical_spread | 2 | 4 | 608 | 126921.00 | unknown | — | 38.9200 | 0.0600 | ["44","50"] | ["0.3904","0.3884"] | [] | ["ARCO","EDGO","XCBO","XISX"] | 44.0000 | 50.0000 | 101 | 101 | false | true | false | true | false | mlet | 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 |
| 01a0815f-f060-7e03-8000-aeabc7524584 | EWZ | 2026-09-08 10:15 | call_vertical_spread | 2 | 3 | 504 | 104640.00 | unknown | — | 38.9200 | 0.0600 | ["44","50"] | ["0.3899","0.3868"] | [] | ["XBOX","XPHO"] | 44.0000 | 50.0000 | 101 | 101 | false | true | false | true | false | mlet | 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 |
| 01a06da4-6d45-71d2-b811-a3c14ee9e2b3 | EWZ | 2026-09-04 14:18 | call_vertical_spread | 2 | 1 | 500 | 110000.00 | long | ask | 37.9500 | 0.0400 | ["42","46"] | ["0.4132","0.4124"] | ["42.82"] | ["EDGO"] | 42.0000 | 46.0000 | 77 | 77 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:18:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |