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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08244-8400-79e3-badc-b3435570f153 | AMD | 2026-09-08 14:25 | call_ladder | 3 | 1 | 150 | 1686150.00 | long | ask | 507.1000 | 2.4000 | ["470","510","550"] | ["0.5423","0.5436","0.5494"] | ["471.55","588.45"] | ["SPHR"] | 470.0000 | 550.0000 | 38 | 38 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:26:06Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0868e-cc28-7dd3-bbe8-5927eefac0cc | TLT | 2026-09-09 10:24 | call_ladder | 3 | 3 | 3500 | 241500.00 | long | ask | 82.0400 | 0.0300 | ["82.5","83.5","84.5"] | ["0.1229","0.1227","0.1289"] | ["82.73","85.27"] | ["AMXO"] | 82.5000 | 84.5000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:25:10Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0a04e-6948-75a3-b941-9abe45832214 | DRAM | 2026-09-14 10:24 | call_ladder | 3 | 1 | 4000 | 2572000.00 | long | ask | 55.0000 | 0.3900 | ["70","80","100"] | ["0.6268","0.6335","0.6577"] | ["70.77","109.23"] | ["SPHR"] | 70.0000 | 100.0000 | 123 | 123 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:24:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a5f7-98ae-7883-974d-beba1e30ce69 | ARES | 2026-09-15 12:47 | call_ladder | 6 | 1 | 100 | 835200.00 | unknown | — | 129.4250 | 15.4000 | ["90","100","105","110","115","120"] | ["2.9481","2.2564","1.9266","1.6033","1.2824","0.9573"] | [] | ["XPHO"] | 90.0000 | 120.0000 | 3 | 3 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:48:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ff-bab5-70a3-b640-2b98ab5e606a | ARES | 2026-09-15 12:56 | call_ladder | 5 | 1 | 150 | 710150.00 | unknown | — | 129.5900 | 12.8000 | ["100","105","110","115","120"] | ["2.1714","1.8511","1.5374","1.2263","0.9116"] | [] | ["XPHO"] | 100.0000 | 120.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:57:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a616-8a8e-7ca1-a078-8b086fcd63c5 | ICE | 2026-09-15 13:21 | call_ladder | 3 | 1 | 20 | 141000.00 | unknown | — | 156.0600 | 8.1000 | ["115","120","125"] | ["2.0370","1.6285","1.4950"] | [] | ["XPHO"] | 115.0000 | 125.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:21:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a628-16be-7b31-912f-af5697b0c8b4 | ARES | 2026-09-15 13:40 | call_ladder | 6 | 1 | 40 | 419660.00 | unknown | — | 128.9400 | 15.4000 | ["90","100","105","110","115","120"] | ["2.2112","1.7794","1.4172","1.1519","0.8961","0.6056"] | [] | ["XPHO"] | 90.0000 | 120.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a643-e7d6-72b2-8c86-c66938fbab95 | MSI | 2026-09-15 14:11 | call_ladder | 5 | 1 | 25 | 489480.00 | unknown | — | 467.3450 | 16.9000 | ["370","410","420","430","440"] | ["1.2006","0.7231","0.6231","0.4727","0.3759"] | [] | ["XPHO"] | 370.0000 | 440.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:11:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a660-5cfd-7802-a7a7-f3aeb8ceb896 | VAC | 2026-09-15 14:42 | call_ladder | 5 | 1 | 10 | 160460.00 | unknown | — | 100.7150 | 18.4000 | ["40","55","60","65","70"] | ["2.3342","1.6175","1.4226","1.2426","1.0745"] | [] | ["XPHO"] | 40.0000 | 70.0000 | 31 | 31 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:42:08Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a676-dace-7453-b59f-15c68ac28801 | TSM | 2026-09-15 15:06 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.5000 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7570","4.5949","4.3845","4.0251","3.8768","3.6374","3.4887","3.2148"] | [] | ["XPHO"] | 170.0000 | 240.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:07:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a677-6f3e-7781-991f-475f55128ee9 | TSM | 2026-09-15 15:07 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.5500 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7113","4.5563","4.3546","3.9891","3.8459","3.6081","3.4632","3.1892"] | [] | ["XPHO"] | 170.0000 | 240.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:07:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a678-693e-70b1-bb97-11472842b502 | TSM | 2026-09-15 15:08 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.4600 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7921","4.6248","4.4078","4.0530","3.9009","3.6603","3.5087","3.2347"] | [] | ["XPHO"] | 170.0000 | 240.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:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a678-cece-7740-91e5-09264ee21cb2 | TSM | 2026-09-15 15:08 | call_ladder | 8 | 1 | 80 | 13346880.00 | unknown | — | 414.6000 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.6637","4.5163","4.3239","3.9516","3.8140","3.5778","3.4370","3.1629"] | [] | ["XPHO"] | 170.0000 | 240.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:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a67b-5b26-7692-b98e-d344780658a3 | TSM | 2026-09-15 15:11 | call_ladder | 6 | 1 | 10 | 1088880.00 | unknown | — | 414.7200 | 17.0000 | ["110","130","135","155","160","175"] | ["6.9789","6.1852","5.8305","5.0396","4.8861","4.6835"] | [] | ["XPHO"] | 110.0000 | 175.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 |
| 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 |
| 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 |
| 01a0b04e-82e3-7f12-a2fd-e8410e186221 | IFF | 2026-09-17 12:58 | call_ladder | 3 | 1 | 500 | 465700.00 | unknown | — | 85.4400 | 2.7500 | ["77.5","80","82.5"] | ["1.6479","1.0452","0.6761"] | [] | ["XPHO"] | 77.5000 | 82.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:59:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c3-0703-7572-a85f-e8bad53414c1 | VYM | 2026-09-17 15:06 | call_ladder | 3 | 1 | 800 | 4809400.00 | unknown | — | 160.7850 | 7.3000 | ["120","140","142"] | ["0.7609","0.4041","0.3001"] | [] | ["XPHO"] | 120.0000 | 142.0000 | 29 | 29 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:06:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0da-1173-7452-8b73-f2829acc90ee | SPY | 2026-09-17 15:31 | call_ladder | 3 | 1 | 3000 | 8652000.00 | unknown | — | 762.8900 | 2.4100 | ["747","749","750"] | ["0.3237","0.2306","0.2512"] | [] | ["XPHO"] | 747.0000 | 750.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:31:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f0-1a13-73c0-862f-9c0e0dafaec1 | SPY | 2026-09-17 15:55 | call_ladder | 6 | 1 | 60 | 2696440.00 | unknown | — | 763.0850 | 21.6000 | ["600","645","650","660","675","743"] | ["2.7481","2.0524","1.2169","1.1258","1.5980","0.2682"] | [] | ["XPHO"] | 600.0000 | 743.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:55:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f0-e91b-7a52-b006-8627c88b3a09 | SPY | 2026-09-17 15:56 | call_ladder | 6 | 1 | 60 | 2695040.00 | unknown | — | 763.0850 | 21.4800 | ["600","645","650","660","675","743"] | ["2.7336","2.0430","1.0719","0.9742","1.5902","0.2598"] | [] | ["XPHO"] | 600.0000 | 743.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:56:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f2-6fbb-7681-a116-00faa0d194d6 | SPY | 2026-09-17 15:57 | call_ladder | 6 | 1 | 60 | 2695040.00 | unknown | — | 763.0750 | 21.4850 | ["600","645","650","660","675","743"] | ["2.7451","2.0499","1.1074","1.0081","1.5979","0.2640"] | [] | ["XPHO"] | 600.0000 | 743.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f2-8efb-7c93-82a5-8240e54dda45 | SPY | 2026-09-17 15:57 | call_ladder | 6 | 1 | 60 | 2696880.00 | unknown | — | 763.0600 | 20.8050 | ["600","645","650","660","675","743"] | ["2.7493","2.0532","1.1223","1.0467","1.6007","0.4603"] | [] | ["XPHO"] | 600.0000 | 743.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f2-a283-7cc0-bcc6-856b3b9de3fa | SPY | 2026-09-17 15:58 | call_ladder | 8 | 1 | 5 | 1150780.00 | unknown | — | 762.9900 | 31.1550 | ["335","345","350","355","601","602","607","608"] | ["5.4643","5.3294","7.6489","3.8080","1.4788","1.4683","1.4164","1.4060"] | [] | ["XPHO"] | 335.0000 | 608.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b5ae-6918-7770-8601-0a55985d6a2b | BABA | 2026-09-18 14:01 | call_ladder | 3 | 2 | 400 | 165600.00 | unknown | bid | 113.2200 | 0.4000 | ["112","116","128"] | ["0.4845","0.5078","0.5644"] | ["112.10","119.90","136.10"] | ["AMXO"] | 112.0000 | 128.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:01:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5db-2638-70e0-8b86-aba972f01f82 | XLV | 2026-09-18 14:50 | call_ladder | 6 | 1 | 5 | 127220.00 | unknown | bid | 168.8500 | 6.4000 | ["90","95","100","155","158","159"] | ["1.9959","1.8323","1.6771","0.3287","0.2653","0.2075"] | ["134.40","168.80"] | ["XPHO"] | 90.0000 | 159.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:50:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b600-c707-78f1-8d57-9a28c6e4ac2b | SBAC | 2026-09-18 15:31 | call_ladder | 3 | 1 | 550 | 288750.00 | short | bid | 179.3850 | 3.0500 | ["185","195","200"] | ["0.2690","0.2943","0.2937"] | ["186.25","208.75"] | ["SPHR"] | 185.0000 | 200.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:31:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |