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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d97-c315-7262-93a4-bc3f0894b2e0 | BLK | 2026-09-04 14:04 | call_condor | 4 | 1 | 25 | 1998250.00 | unknown | — | 1119.8800 | 26.9000 | ["800","930","970","980"] | ["0.9233","0.5516","0.4446","0.4182"] | [] | ["XPHO"] | 800.0000 | 980.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:05:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 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 |
| 01a081da-d168-77a2-8a9e-234e045f0b9c | GLD | 2026-09-08 12:29 | call_condor | 4 | 1 | 100 | 455900.00 | long | ask | 402.9200 | 0.9500 | ["397","399","402","405"] | ["0.2487","0.2435","0.2442","0.2510"] | ["397.15","403.85"] | ["SPHR"] | 397.0000 | 405.0000 | 22 | 22 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:30:01Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08cba-a1a8-7ca2-9219-4e8d2b03dc8c | BNO | 2026-09-10 15:10 | call_condor | 4 | 1 | 50 | 128500.00 | unknown | — | 62.6550 | 1.2000 | ["60","65","70","75"] | ["0.5054","0.5209","0.5337","0.5509"] | [] | ["SPHR"] | 60.0000 | 75.0000 | 127 | 127 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:10:54Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091f9-38c8-7cb3-9877-c8ef7e79b4d7 | UNH | 2026-09-11 15:37 | call_condor | 4 | 1 | 5 | 339950.00 | unknown | — | 377.5200 | 15.8000 | ["145","160","180","345"] | ["4.1772","2.6746","2.6258","0.6079"] | [] | ["XPHO"] | 145.0000 | 345.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:37:05Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a170-a611-7da1-bcf3-00463e580bb0 | MRK | 2026-09-14 15:41 | call_condor | 4 | 1 | 60 | 1195080.00 | unknown | — | 144.4400 | 5.8500 | ["75","80","100","125"] | ["3.1531","2.9456","1.9425","0.8626"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:41:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a170-bd80-7843-9dda-e0597e1811ec | MRK | 2026-09-14 15:41 | call_condor | 4 | 1 | 60 | 1195080.00 | unknown | — | 144.4400 | 5.8500 | ["75","80","100","125"] | ["3.1531","2.9456","1.9425","0.8626"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:41:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a170-d4f0-70e1-9869-84ea98b0585c | MRK | 2026-09-14 15:41 | call_condor | 4 | 1 | 60 | 1195080.00 | unknown | — | 144.4201 | 5.8500 | ["75","80","100","125"] | ["3.1853","2.9728","1.9621","0.8746"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:42:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a170-f430-74b2-843f-7174b6659375 | MRK | 2026-09-14 15:42 | call_condor | 4 | 1 | 80 | 1593440.00 | unknown | — | 144.4450 | 5.8500 | ["75","80","100","125"] | ["3.1448","2.9386","1.9374","0.8595"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:42:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a563-578e-7341-878e-62557366b1b3 | APA | 2026-09-15 10:05 | call_condor | 4 | 1 | 200 | 1173200.00 | short | bid | 46.6900 | 5.7000 | ["30","40","47.5","55"] | ["0.3689","0.4070","0.4083","0.4082"] | ["32.60","54.9"] | ["SPHR"] | 30.0000 | 55.0000 | 822 | 822 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:05:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5fc-539e-70f3-9f88-ed60a84f3710 | NVDA | 2026-09-15 12:52 | call_condor | 4 | 1 | 150 | 56250.00 | unknown | — | 212.1300 | 0.0400 | ["215","217.5","220","222.5"] | ["0.3877","0.3836","0.3832","0.3899"] | [] | ["SPHR"] | 215.0000 | 222.5000 | 3 | 3 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:53:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a67b-285e-7043-a1a3-b61ec10a3a25 | NXPI | 2026-09-15 15:11 | call_condor | 4 | 1 | 5 | 142920.00 | unknown | — | 225.9700 | 11.8000 | ["110","115","190","200"] | ["4.1177","3.8875","1.5075","0.9225"] | [] | ["XPHO"] | 110.0000 | 200.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:12:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aba5-3a6b-7692-92ce-5ecf84866481 | RCL | 2026-09-16 15:15 | call_condor | 4 | 1 | 5 | 131720.00 | unknown | — | 252.3800 | 10.9000 | ["135","140","230","240"] | ["5.2413","4.9776","0.9946","0.6433"] | [] | ["XPHO"] | 135.0000 | 240.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:15:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afff-16db-7761-9bdd-8f9422674953 | PANW | 2026-09-17 11:32 | call_condor | 4 | 3 | 55 | 1251800.00 | unknown | — | 376.6901 | 15.3000 | ["280","340","350","430"] | ["0.6276","0.5662","0.5595","0.5420"] | [] | ["AMXO"] | 280.0000 | 430.0000 | 64 | 64 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:32:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b032-4854-7d12-bf58-dedc12bd540b | GEV | 2026-09-17 12:27 | call_condor | 4 | 1 | 100 | 972000.00 | unknown | — | 940.2800 | 2.3000 | ["930","1000","1060","1140"] | ["0.4518","0.4532","0.4538","0.4604"] | [] | ["XPHO"] | 930.0000 | 1140.0000 | 29 | 29 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:28:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |