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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08b83-3ed2-77a2-85d6-7736b0a5e2f3 | SPY | 2026-09-10 09:30 | box_spread | 4 | 1 | 17 | 310080.00 | long | ask | 758.1400 | 2.0500 | ["755","775"] | ["0.1751","0.1683"] | [] | ["XISX"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:30:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bfc-81c9-7852-8caf-146561fcb453 | SPY | 2026-09-10 11:42 | box_spread | 4 | 1 | 18 | 328464.00 | short | bid | 759.2850 | 0.2100 | ["755","775"] | ["0.1751","0.1677"] | [] | ["XISX"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:43:11Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c50-2bc0-7133-954f-fa7ffe70604b | SPY | 2026-09-10 13:14 | box_spread | 4 | 1 | 9 | 164142.00 | short | bid | 759.1700 | 0.3600 | ["755","775"] | ["0.1750","0.1676"] | [] | ["XISX"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:14:37Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7c-2d60-7a33-9bc0-4de65df1faa9 | SPY | 2026-09-10 14:02 | box_spread | 4 | 1 | 10 | 182220.00 | short | bid | 758.0350 | 0.5700 | ["755","775"] | ["0.1753","0.1679"] | [] | ["AMXO"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:02:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb3-1fc8-7cf2-8a00-f0c36f2613d0 | SPY | 2026-09-10 15:02 | box_spread | 4 | 1 | 18 | 42174.00 | unknown | — | 757.5400 | 0.4300 | ["765","770"] | ["0.1190","0.1117"] | [] | ["ARCO"] | 765.0000 | 770.0000 | 5 | 5 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:02:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091cc-25b8-7b20-a896-772a67e76dfc | SPY | 2026-09-11 14:47 | box_spread | 4 | 1 | 6 | 58164.00 | short | bid | 765.2400 | 0.3100 | ["735","795"] | ["0.1647","0.1297"] | [] | ["SPHR"] | 735.0000 | 795.0000 | 80 | 80 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:48:11Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091cc-25b8-7b20-a896-77124aa331a7 | SPY | 2026-09-11 14:47 | box_spread | 4 | 2 | 9 | 87362.00 | short | bid | 765.2400 | 0.5778 | ["735","795"] | ["0.1656","0.1294"] | [] | ["ARCO","EMLD"] | 735.0000 | 795.0000 | 80 | 80 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:48:11Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a55c-1bfe-75b3-93f0-c47d531b93dd | SPY | 2026-09-15 09:57 | box_spread | 4 | 1 | 3 | 28662.00 | long | ask | 759.5000 | 2.1200 | ["735","795"] | ["0.1657","0.1320"] | [] | ["EMLD"] | 735.0000 | 795.0000 | 76 | 76 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:57:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a572-47c6-7662-b6bd-aac527484096 | SPY | 2026-09-15 10:22 | box_spread | 4 | 1 | 9 | 212922.00 | unknown | — | 757.6250 | 3.0100 | ["700","800"] | ["0.1976","0.1679"] | [] | ["XISX"] | 700.0000 | 800.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:22:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a593-ae8e-78f3-89e3-a35be5b7c7dc | SPY | 2026-09-15 10:58 | box_spread | 4 | 2 | 4 | 58900.00 | long | ask | 756.6400 | 2.5100 | ["715","769"] | ["0.1823","0.1524"] | [] | ["EMLD","XMIO"] | 715.0000 | 769.0000 | 164 | 164 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:59:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a6-86c6-7093-a7ed-3194377660a9 | SPY | 2026-09-15 11:19 | box_spread | 4 | 2 | 4 | 59166.00 | long | ask | 757.3200 | 2.4900 | ["715","769"] | ["0.1828","0.1526"] | [] | ["ARCO","EMLD"] | 715.0000 | 769.0000 | 164 | 164 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:19:09Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e9-8b06-7d91-9af7-df317787d367 | SPY | 2026-09-15 12:32 | box_spread | 4 | 1 | 7 | 150472.00 | short | bid | 757.6400 | 1.0500 | ["755","775"] | ["0.1794","0.1737"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:32:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f5-568e-7501-9fa6-8e03d0b91430 | SPY | 2026-09-15 12:45 | box_spread | 4 | 2 | 10 | 214800.00 | unknown | — | 757.6550 | 1.1500 | ["755","775"] | ["0.1792","0.1736"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:45:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f5-e32e-7661-b767-1fe2de5a8b70 | SPY | 2026-09-15 12:45 | box_spread | 4 | 1 | 10 | 214840.00 | short | bid | 757.7000 | 1.0000 | ["755","775"] | ["0.1794","0.1734"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:46:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f9-4275-7ad1-9b79-3fd94a08365f | SPY | 2026-09-15 12:49 | box_spread | 4 | 1 | 10 | 214720.00 | short | bid | 757.3700 | 1.0300 | ["755","775"] | ["0.1793","0.1736"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:49:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a676-3aa6-7e93-b7e9-3ee5d51bd583 | SPY | 2026-09-15 15:05 | box_spread | 4 | 1 | 10 | 214200.00 | short | bid | 757.3300 | 0.9700 | ["755","775"] | ["0.1789","0.1731"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:06:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a680-a2b6-7561-82ec-33cdbf58d5d6 | SPY | 2026-09-15 15:17 | box_spread | 4 | 3 | 16 | 341648.00 | unknown | — | 757.1200 | 0.9300 | ["755","775"] | ["0.1782","0.1728"] | [] | ["AMXO"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:17:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a683-9886-7403-b427-4d01994d7059 | SPY | 2026-09-15 15:20 | box_spread | 4 | 2 | 30 | 642084.00 | short | bid | 757.1900 | 1.3700 | ["755","775"] | ["0.1789","0.1729"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:20:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a691-198e-7712-ba20-4a21b431c079 | SPY | 2026-09-15 15:35 | box_spread | 4 | 1 | 30 | 641940.00 | short | bid | 756.9200 | 0.9700 | ["755","775"] | ["0.1789","0.1731"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:35:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa7e-98a3-75d0-b230-3abf6a56476f | SPY | 2026-09-16 09:53 | box_spread | 4 | 1 | 2 | 43004.00 | unknown | — | 760.0800 | 8.1500 | ["755","775"] | ["0.1780","0.1736"] | [] | ["XISX"] | 755.0000 | 775.0000 | 366 | 366 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:53:45Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa82-49f3-7463-9cb3-390308c43a3e | SPY | 2026-09-16 09:57 | box_spread | 4 | 1 | 10 | 215040.00 | unknown | — | 760.2300 | 2.2000 | ["755","775"] | ["0.1786","0.1729"] | [] | ["XISX"] | 755.0000 | 775.0000 | 366 | 366 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:57:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaee-d703-7290-9e02-af226eee3fc4 | SPY | 2026-09-16 11:56 | box_spread | 4 | 1 | 10 | 215620.00 | short | bid | 760.8100 | 1.0200 | ["755","775"] | ["0.1789","0.1731"] | [] | ["XPHO"] | 755.0000 | 775.0000 | 366 | 366 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:56:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab06-bc33-72d3-a953-b7dd8e486467 | SPY | 2026-09-16 12:22 | box_spread | 4 | 1 | 10 | 215160.00 | unknown | — | 760.0200 | 3.4800 | ["755","775"] | ["0.1788","0.1731"] | [] | ["XCBO"] | 755.0000 | 775.0000 | 366 | 366 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:22:44Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0af9b-5f83-75b3-877b-5233523e1c47 | SPY | 2026-09-17 09:43 | box_spread | 4 | 1 | 8 | 171632.00 | unknown | — | 760.9950 | 2.7600 | ["755","775"] | ["0.1735","0.1670"] | [] | ["XISX"] | 755.0000 | 775.0000 | 365 | 365 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:43:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb9-055b-7841-9353-5fb62859d7c5 | SPY | 2026-09-17 10:15 | box_spread | 4 | 2 | 5 | 77980.00 | long | ask | 761.1800 | 2.6800 | ["700","792"] | ["0.1888","0.1445"] | [] | ["EMLD","XMIO"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:15:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb9-14fc-74b0-8c1a-0875c30a7267 | SPY | 2026-09-17 10:15 | box_spread | 4 | 1 | 4 | 62376.00 | long | ask | 761.1200 | 2.5600 | ["700","792"] | ["0.1890","0.1444"] | [] | ["EMLD"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:15:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd1-a60b-7113-b2b8-2ec2e27ee756 | SPY | 2026-09-17 10:42 | box_spread | 4 | 2 | 4 | 62656.00 | long | ask | 762.1500 | 1.9700 | ["700","792"] | ["0.1903","0.1440"] | [] | ["ARCO","EMLD"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:42:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd1-b993-7c40-b2c8-a1e832251597 | SPY | 2026-09-17 10:42 | box_spread | 4 | 1 | 5 | 78295.00 | long | ask | 762.2100 | 2.1500 | ["700","792"] | ["0.1896","0.1443"] | [] | ["EMLD"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:42:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afdc-6bdb-7543-b35a-8b13acdcc888 | SPY | 2026-09-17 10:54 | box_spread | 4 | 1 | 3 | 43422.00 | short | bid | 760.6900 | 3.4500 | ["720","800"] | ["0.1780","0.1439"] | [] | ["ARCO"] | 720.0000 | 800.0000 | 162 | 162 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:54:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe4-b8db-7000-9519-7678248feae9 | SPY | 2026-09-17 11:03 | box_spread | 4 | 2 | 4 | 53472.00 | short | bid | 760.8000 | 1.9300 | ["705","790"] | ["0.1850","0.1354"] | [] | ["EMLD","XMIO"] | 705.0000 | 790.0000 | 120 | 120 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:03:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe4-b8db-7000-9519-76696aa807f1 | SPY | 2026-09-17 11:03 | box_spread | 4 | 2 | 5 | 66840.00 | short | bid | 760.8000 | 1.9300 | ["705","790"] | ["0.1850","0.1354"] | [] | ["EMLD","XMIO"] | 705.0000 | 790.0000 | 120 | 120 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:03:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b080-be43-7e73-8e5a-e5ea95ea4827 | SPY | 2026-09-17 13:53 | box_spread | 4 | 1 | 3 | 64860.00 | short | bid | 762.3050 | 3.6400 | ["755","775"] | ["0.1748","0.1676"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 365 | 365 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:54:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b5ba-1d2f-79b0-be3e-ffbace5f7ded | SPY | 2026-09-18 14:14 | box_spread | 4 | 1 | 5 | 107910.00 | short | bid | 759.8700 | 0.7900 | ["755","775"] | ["0.1809","0.1741"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 364 | 364 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:14:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5bd-ab57-7e43-8f1b-296b8302c1da | SPY | 2026-09-18 14:18 | box_spread | 4 | 1 | 5 | 107920.00 | short | bid | 759.9450 | 0.7900 | ["755","775"] | ["0.1809","0.1741"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 364 | 364 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:18:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e6-651f-7711-8c6c-14092417d4f4 | SPY | 2026-09-18 15:02 | box_spread | 4 | 2 | 9 | 82317.00 | short | bid | 761.1800 | 0.4133 | ["735","795"] | ["0.1620","0.1238"] | [] | ["ARCO","EMLD"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e7-d837-7ac0-b93f-ba0fd2cd5e51 | SPY | 2026-09-18 15:04 | box_spread | 4 | 1 | 3 | 27429.00 | short | bid | 761.3450 | 0.7200 | ["735","795"] | ["0.1617","0.1240"] | [] | ["EMLD"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:04:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e7-d837-7ac0-b93f-b9f5349c0c7c | SPY | 2026-09-18 15:04 | box_spread | 4 | 3 | 7 | 63975.00 | short | bid | 761.3450 | 0.7200 | ["735","795"] | ["0.1618","0.1237"] | [] | ["ARCO","EMLD","XMIO"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:04:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |