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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4fb-8050-7cb2-994a-1ce76f3b6baf | SPY | 2026-09-18 10:46 | put_vertical_spread | 2 | 3 | 850 | 433925.00 | unknown | ask | 759.1150 | 0.0400 | ["695","700"] | ["0.2125","0.2056"] | ["694.95"] | ["AMXO"] | 695.0000 | 700.0000 | 42 | 42 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:46:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f2-605f-7480-a039-950c9bc646e1 | SPY | 2026-09-18 10:36 | put_vertical_spread | 2 | 2 | 220 | 294360.00 | unknown | bid | 759.0800 | 0.0600 | ["700","755"] | ["0.2043","0.1394"] | ["741.62"] | ["AMXO"] | 700.0000 | 755.0000 | 42 | 42 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:36:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f2-2d53-7c82-a60f-d5a94a745c4f | SPY | 2026-09-17 15:57 | put_vertical_spread | 2 | 2 | 1000 | 1236000.00 | unknown | — | 763.0850 | 0.0700 | ["660","700"] | ["0.2363","0.2019"] | [] | ["AMXO"] | 660.0000 | 700.0000 | 105 | 105 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:49Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b02c-87ab-7960-8a35-62be31c031ad | SPY | 2026-09-17 12:21 | put_vertical_spread | 2 | 1 | 68 | 59636.00 | unknown | — | 762.3800 | 0.0500 | ["762","766"] | ["0.2027","0.2343"] | [] | ["SPHR"] | 762.0000 | 766.0000 | 1 | 1 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:21:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9e-8433-7ed0-97b4-3864fa8ac49a | SPY | 2026-09-17 09:46 | put_vertical_spread | 2 | 1 | 500 | 1499500.00 | unknown | — | 760.8900 | 0.1300 | ["700","715"] | ["0.1968","0.1870"] | [] | ["XPHO"] | 700.0000 | 715.0000 | 183 | 183 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:46:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9c-49e3-7cf3-aee6-6598fdbad872 | SPY | 2026-09-17 09:44 | put_vertical_spread | 2 | 1 | 1175 | 3588450.00 | unknown | — | 761.0500 | 0.2000 | ["725","745"] | ["0.1794","0.1651"] | [] | ["XPHO"] | 725.0000 | 745.0000 | 120 | 120 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:44:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abac-106c-7843-a327-f34a33903810 | SPY | 2026-09-16 15:22 | put_vertical_spread | 2 | 1 | 514 | 1859652.00 | long | ask | 750.3800 | 0.1300 | ["700","715"] | ["0.2042","0.1951"] | ["712.04"] | ["SPHR"] | 700.0000 | 715.0000 | 184 | 184 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:23:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-9f6b-7971-a6ef-396e588060ce | SPY | 2026-09-16 15:20 | put_vertical_spread | 2 | 1 | 1175 | 4138350.00 | short | bid | 751.3200 | 0.3000 | ["725","735"] | ["0.1857","0.1783"] | ["732.58"] | ["XPHO"] | 725.0000 | 735.0000 | 121 | 121 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba5-3684-74e1-918c-da00cab63d34 | SPY | 2026-09-16 15:15 | put_vertical_spread | 2 | 1 | 200 | 760000.00 | short | bid | 752.0400 | 0.4200 | ["760","770"] | ["0.1501","0.1486"] | ["763.80"] | ["SPHR"] | 760.0000 | 770.0000 | 30 | 30 | 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 |
| 01a0aba3-ee63-7ed0-84ab-b7adb6224315 | SPY | 2026-09-16 15:14 | put_vertical_spread | 2 | 1 | 60 | 101400.00 | short | bid | 751.3950 | 0.2900 | ["730","760"] | ["0.1980","0.1549"] | ["750.20"] | ["SPHR"] | 730.0000 | 760.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:14:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab87-b7bb-7771-b6b7-e14905ec176f | SPY | 2026-09-16 14:43 | put_vertical_spread | 2 | 1 | 1125 | 3843000.00 | unknown | — | 760.0600 | 0.1800 | ["735","745"] | ["0.1773","0.1704"] | [] | ["XPHO"] | 735.0000 | 745.0000 | 121 | 121 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:43:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf6-2233-7db2-ae47-92b9642a02cf | SPY | 2026-09-16 12:04 | put_vertical_spread | 2 | 1 | 1175 | 3990300.00 | unknown | — | 760.4000 | 0.1800 | ["735","745"] | ["0.1773","0.1705"] | [] | ["SPHR"] | 735.0000 | 745.0000 | 121 | 121 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:04:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a578-4ad6-7603-b825-0abf4a63f40b | SPY | 2026-09-15 10:28 | put_vertical_spread | 2 | 2 | 1100 | 3977600.00 | unknown | — | 757.5300 | 0.1800 | ["735","745"] | ["0.1778","0.1710"] | [] | ["XPHO"] | 735.0000 | 745.0000 | 122 | 122 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:29:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0bd-a5d9-71d0-ba6e-756ee21d2c0b | SPY | 2026-09-14 12:26 | put_vertical_spread | 2 | 1 | 1175 | 3937425.00 | long | ask | 762.0500 | 0.1600 | ["735","745"] | ["0.1779","0.1711"] | ["742.59"] | ["SPHR"] | 735.0000 | 745.0000 | 123 | 123 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:26:41Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02e-e2f8-7702-8428-228b81a85773 | SPY | 2026-09-14 09:50 | put_vertical_spread | 2 | 1 | 600 | 2194200.00 | long | ask | 760.4400 | 0.1900 | ["715","725"] | ["0.1962","0.1905"] | ["722.95"] | ["XPHO"] | 715.0000 | 725.0000 | 186 | 186 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:50:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02d-3161-7ad1-88e5-7ecc9cd8f814 | SPY | 2026-09-14 09:48 | put_vertical_spread | 2 | 1 | 1063 | 3752390.00 | unknown | — | 759.9400 | 0.2100 | ["735","745"] | ["0.1793","0.1724"] | [] | ["XPHO"] | 735.0000 | 745.0000 | 123 | 123 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:48:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091f3-5110-7b83-a427-42419b451112 | SPY | 2026-09-11 15:30 | put_vertical_spread | 2 | 1 | 200 | 413600.00 | long | ask | 765.0750 | 0.0900 | ["705","710"] | ["0.1978","0.1942"] | ["709.30"] | ["SPHR"] | 705.0000 | 710.0000 | 126 | 126 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:30:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f0-b518-7761-86b9-b2741b1ba476 | SPY | 2026-09-11 15:27 | put_vertical_spread | 2 | 1 | 700 | 2396800.00 | unknown | — | 765.1200 | 0.1500 | ["715","725"] | ["0.1906","0.1843"] | [] | ["XPHO"] | 715.0000 | 725.0000 | 189 | 189 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:28:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09132-4b00-73c2-97c2-842e31850e21 | SPY | 2026-09-11 11:59 | put_vertical_spread | 2 | 1 | 60000 | 12600000.00 | short | bid | 765.7300 | 0.0200 | ["730","750"] | ["0.2139","0.1657"] | ["748.84"] | ["AMXO"] | 730.0000 | 750.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:59:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ba-3ca0-7433-993c-777af98774e5 | SPY | 2026-09-11 09:48 | put_vertical_spread | 2 | 1 | 52 | 167856.00 | long | ask | 765.0100 | 0.1800 | ["750","770"] | ["0.1635","0.1496"] | ["763.22"] | ["SPHR"] | 750.0000 | 770.0000 | 70 | 70 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:48:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce6-a730-78d1-bb65-1f686a7f4fb7 | SPY | 2026-09-10 15:58 | put_vertical_spread | 2 | 1 | 1600 | 5292800.00 | unknown | — | 757.9350 | 0.2000 | ["774","775"] | ["0.1934","0.2036"] | [] | ["XPHO"] | 774.0000 | 775.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:58:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ccb-37c0-7d31-807a-518d3080c536 | SPY | 2026-09-10 15:28 | put_vertical_spread | 2 | 1 | 1000 | 3182000.00 | unknown | — | 757.5400 | 0.2600 | ["773","774"] | ["0.1720","0.1816"] | [] | ["XPHO"] | 773.0000 | 774.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:29:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb0-abb8-7372-b3c6-4825977eb133 | SPY | 2026-09-10 10:20 | put_vertical_spread | 2 | 1 | 1150 | 4356200.00 | long | ask | 758.0100 | 0.2100 | ["735","745"] | ["0.1802","0.1741"] | ["742.28"] | ["XPHO"] | 735.0000 | 745.0000 | 127 | 127 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:20:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0872e-fbf8-7451-b05d-e7e2979c7e77 | SPY | 2026-09-09 13:19 | put_vertical_spread | 2 | 1 | 200 | 73400.00 | long | ask | 762.8700 | 0.0300 | ["764","765"] | ["0.1343","0.1469"] | ["764.15"] | ["SPHR"] | 764.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:20:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f6-b1d0-7703-86f5-aeebf584159a | SPY | 2026-09-09 12:18 | put_vertical_spread | 2 | 1 | 200 | 36600.00 | short | bid | 761.4400 | 0.0200 | ["761","762"] | ["0.1440","0.1343"] | ["761.55"] | ["SPHR"] | 761.0000 | 762.0000 | 0 | 0 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:18:50Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868b-f1b0-7611-b1f1-31f3beae9a8c | SPY | 2026-09-09 10:21 | put_vertical_spread | 2 | 1 | 1150 | 3868600.00 | unknown | — | 762.8882 | 0.1800 | ["735","745"] | ["0.1767","0.1700"] | [] | ["XPHO"] | 735.0000 | 745.0000 | 128 | 128 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:22:01Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0829c-fc70-7b51-bec0-cf079d33c227 | SPY | 2026-09-08 16:01 | put_vertical_spread | 2 | 1 | 1175 | 4328700.00 | unknown | — | 765.8800 | 0.1500 | ["745","755"] | ["0.1695","0.1635"] | [] | ["ARCO"] | 745.0000 | 755.0000 | 129 | 129 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T20:03:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08262-1651-7ef3-9319-e0127e969912 | SPY | 2026-09-08 14:57 | put_vertical_spread | 2 | 1 | 158 | 49454.00 | long | ask | 767.0300 | 0.0300 | ["750","765"] | ["0.1752","0.1352"] | ["762.69"] | ["SPHR"] | 750.0000 | 765.0000 | 3 | 3 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:58:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06da6-cea5-7183-a418-78ea3bf74cb9 | SPY | 2026-09-04 14:20 | put_vertical_spread | 2 | 1 | 2458 | 4694780.00 | unknown | — | 769.8200 | 0.0800 | ["750","760"] | ["0.1510","0.1430"] | [] | ["XBOX"] | 750.0000 | 760.0000 | 56 | 56 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:21:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8f-b495-79b3-a6b3-316bcbbcd6e4 | SPY | 2026-09-04 13:55 | put_vertical_spread | 2 | 1 | 1500 | 2637000.00 | unknown | — | 769.3300 | 0.0500 | ["720","750"] | ["0.1821","0.1561"] | [] | ["XPHO"] | 720.0000 | 750.0000 | 77 | 77 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:55:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |