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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c530-37b7-78a2-a6f3-8f64eb72dcb4 | SPY | 2026-09-21 14:17 | strangle | 2 | 1 | 5 | 53635.00 | long | ask | 773.2700 | 0.5300 | ["770","920"] | ["0.2149","0.1524"] | ["662.73","1027.27"] | ["XPHO"] | 770.0000 | 920.0000 | 816 | 816 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:18:02Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4dc-33e7-7082-b005-6ffe2260e427 | SPY | 2026-09-21 12:45 | strangle | 2 | 1 | 20 | 57400.00 | short | bid | 772.1952 | 0.0800 | ["770","800"] | ["0.1473","0.1272"] | ["741.30","828.70"] | ["AMXO"] | 770.0000 | 800.0000 | 88 | 88 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:46:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b563-5a40-7202-9790-5fac9d7b2d6b | SPY | 2026-09-18 12:39 | strangle | 2 | 1 | 217 | 26257.00 | short | bid | 759.0550 | 0.0200 | ["758","759"] | ["0.1398","0.1313"] | ["756.79","760.21"] | ["XCBO"] | 758.0000 | 759.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:40:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b543-cc20-78a2-a49a-24b759940b35 | SPY | 2026-09-18 12:05 | strangle | 2 | 1 | 100 | 47700.00 | short | bid | 758.8700 | 0.0300 | ["759","764"] | ["0.1025","0.0867"] | ["754.23","768.77"] | ["XCBO"] | 759.0000 | 764.0000 | 5 | 5 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:05:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f4-b607-7a51-a686-75c9b4221189 | SPY | 2026-09-18 10:38 | strangle | 2 | 1 | 17 | 35360.00 | short | bid | 759.3300 | 0.1100 | ["754","762"] | ["0.1358","0.1246"] | ["733.20","782.80"] | ["XCBO"] | 754.0000 | 762.0000 | 35 | 35 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:39:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bf-6597-7c82-ad34-604fc67db538 | SPY | 2026-09-18 09:40 | strangle | 2 | 1 | 15 | 28185.00 | short | bid | 761.0850 | 0.1000 | ["756","762"] | ["0.1318","0.1231"] | ["737.21","780.79"] | ["XCBO"] | 756.0000 | 762.0000 | 28 | 28 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:40:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b6-417b-7a60-9781-b683e46187fa | SPY | 2026-09-17 14:52 | strangle | 2 | 1 | 9 | 104283.00 | long | ask | 762.4300 | 0.7700 | ["855","960"] | ["0.2125","0.1341"] | ["739.13","1075.87"] | ["AMXO"] | 855.0000 | 960.0000 | 638 | 638 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:52:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b6-417b-7a60-9781-b6796ec58f19 | SPY | 2026-09-17 14:52 | strangle | 2 | 1 | 4 | 49544.00 | long | ask | 762.4300 | 0.8900 | ["855","925"] | ["0.2127","0.1376"] | ["731.14","1048.86"] | ["XBOX"] | 855.0000 | 925.0000 | 638 | 638 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:52:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b6-417b-7a60-9781-b658a1684a0d | SPY | 2026-09-17 14:52 | strangle | 2 | 1 | 25 | 289725.00 | long | ask | 762.4300 | 0.7700 | ["855","960"] | ["0.2127","0.1339"] | ["739.11","1075.89"] | ["XBOX"] | 855.0000 | 960.0000 | 638 | 638 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:52:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b6-417b-7a60-9781-b6433fd4b21a | SPY | 2026-09-17 14:52 | strangle | 2 | 1 | 21 | 260232.00 | long | ask | 762.4300 | 0.8900 | ["855","925"] | ["0.2127","0.1378"] | ["731.08","1048.92"] | ["XBOX"] | 855.0000 | 925.0000 | 638 | 638 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:52:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0af-6793-7493-84e1-efd791151cd6 | SPY | 2026-09-17 14:44 | strangle | 2 | 1 | 50 | 40200.00 | short | bid | 762.3800 | 0.0300 | ["757","765"] | ["0.3186","0.1243"] | ["756.96","765.04"] | ["XMIO"] | 757.0000 | 765.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:44:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b018-4fe3-7f21-9f80-5c05028874cf | SPY | 2026-09-17 11:59 | strangle | 2 | 1 | 400 | 219200.00 | short | bid | 762.3800 | 0.0600 | ["754","765"] | ["0.1457","0.0894"] | ["748.52","770.48"] | ["XISX"] | 754.0000 | 765.0000 | 7 | 7 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:59:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa76-18db-7541-87a1-d03d17feb0ef | SPY | 2026-09-16 09:44 | strangle | 2 | 1 | 5 | 46020.00 | unknown | — | 758.8850 | 4.5500 | ["680","770"] | ["0.7316","0.2477"] | [] | ["XCBO"] | 680.0000 | 770.0000 | 2 | 2 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:44:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a584-3986-7141-8e7e-4df758be2f10 | SPY | 2026-09-15 10:41 | strangle | 2 | 1 | 200 | 147000.00 | short | bid | 757.0300 | 0.0800 | ["752","763"] | ["0.1724","0.1155"] | ["744.65","770.35"] | ["XCBO"] | 752.0000 | 763.0000 | 7 | 7 | true | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:42:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0a3-4fa8-7a02-9746-2f975367a3c1 | SPY | 2026-09-14 11:57 | strangle | 2 | 1 | 320 | 45120.00 | short | bid | 761.8900 | 0.0200 | ["761","762"] | ["0.1463","0.1359"] | ["759.59","763.41"] | ["XMIO"] | 761.0000 | 762.0000 | 0 | 0 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:57:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091bd-9728-7c01-a870-81992cfefd25 | SPY | 2026-09-11 14:31 | strangle | 2 | 1 | 300 | 249300.00 | unknown | — | 765.3100 | 0.0400 | ["755","775"] | ["0.1427","0.0933"] | [] | ["EDGO"] | 755.0000 | 775.0000 | 19 | 19 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:31:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a5-c968-7b22-8f95-4e86733fd873 | SPY | 2026-09-11 14:05 | strangle | 2 | 1 | 80 | 39760.00 | long | ask | 765.7300 | 0.0200 | ["765","766"] | ["0.0883","0.0816"] | ["760.03","770.97"] | ["XMIO"] | 765.0000 | 766.0000 | 4 | 4 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:05:59Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09171-7eb0-72b1-91fe-3c8e18711908 | SPY | 2026-09-11 13:08 | strangle | 2 | 1 | 180 | 30960.00 | short | bid | 765.7200 | 0.0300 | ["749","782"] | ["0.1668","0.0917"] | ["747.28","783.72"] | ["EDGO"] | 749.0000 | 782.0000 | 7 | 7 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:09:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09111-f5a8-76c3-a1a7-c82478871997 | SPY | 2026-09-11 11:24 | strangle | 2 | 1 | 103 | 38419.00 | short | bid | 765.6300 | 0.0200 | ["655","830"] | ["0.2583","0.1105"] | ["651.27","833.73"] | ["EDGO"] | 655.0000 | 830.0000 | 70 | 70 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:24:52Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d0-d5c9-7cf1-a5a2-6c3110ad901f | SPY | 2026-09-11 10:13 | strangle | 2 | 1 | 9 | 26287.00 | long | ask | 765.0200 | 0.2000 | ["759","766"] | ["0.1267","0.1395"] | ["736.79","788.21"] | ["XCBO"] | 759.0000 | 766.0000 | 35 | 35 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:13:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c8-bf78-7803-b196-9cfe44205ffa | SPY | 2026-09-11 10:04 | strangle | 2 | 1 | 204 | 156559.00 | long | ask | 765.5200 | 0.0400 | ["752","765"] | ["0.1700","0.1164"] | ["744.33","772.67"] | ["XCBO"] | 752.0000 | 765.0000 | 7 | 7 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:04:41Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cdd-f888-7480-b085-e5bbe0f6acd9 | SPY | 2026-09-10 15:49 | strangle | 2 | 1 | 60 | 38160.00 | unknown | — | 757.8800 | 0.0400 | ["756","760"] | ["0.1340","0.1252"] | [] | ["XCBO"] | 756.0000 | 760.0000 | 4 | 4 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:49:33Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c71-e0a8-7f60-b308-74b3d9b11577 | SPY | 2026-09-10 13:51 | strangle | 2 | 1 | 21 | 139818.00 | short | bid | 758.4200 | 0.2100 | ["700","840"] | ["0.2160","0.1482"] | ["633.42","906.58"] | ["XCBO"] | 700.0000 | 840.0000 | 463 | 463 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:51:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b84-34e8-7f33-b8d5-ea82fb610a17 | SPY | 2026-09-10 09:31 | strangle | 2 | 1 | 80 | 37040.00 | short | bid | 757.7400 | 0.0400 | ["762","763"] | ["0.1790","0.1881"] | ["757.37","767.63"] | ["XMIO"] | 762.0000 | 763.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:31:33Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087cd-6e78-7100-9bfa-cb8bcb8db0b8 | SPY | 2026-09-09 16:13 | strangle | 2 | 1 | 80 | 30000.00 | long | ask | 762.6200 | 0.0200 | ["762","763"] | ["0.1339","0.1316"] | ["758.25","766.75"] | ["XCBO"] | 762.0000 | 763.0000 | 1 | 1 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0869d-3b78-75c3-a710-b1589fcbb912 | SPY | 2026-09-09 10:40 | strangle | 2 | 1 | 50 | 471250.00 | short | bid | 763.5800 | 0.3700 | ["785","805"] | ["0.1862","0.1514"] | ["690.75","899.25"] | ["AMXO"] | 785.0000 | 805.0000 | 373 | 373 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:41:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866e-ff88-7e01-8cc0-1f7727149e51 | SPY | 2026-09-09 09:50 | strangle | 2 | 1 | 15 | 37380.00 | short | bid | 763.9051 | 0.0800 | ["757","766"] | ["0.1483","0.1246"] | ["732.08","790.92"] | ["XCBO"] | 757.0000 | 766.0000 | 44 | 44 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08147-c8c8-7633-833a-2ff948828270 | SPY | 2026-09-08 09:49 | strangle | 2 | 1 | 56 | 36176.00 | long | ask | 767.4800 | 0.0400 | ["765","770"] | ["0.1163","0.1061"] | ["758.54","776.46"] | ["XCBO"] | 765.0000 | 770.0000 | 6 | 6 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:49:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08142-a849-7822-9ebc-84ecc3c798c6 | SPY | 2026-09-08 09:43 | strangle | 2 | 1 | 9 | 26388.00 | long | ask | 767.3500 | 0.2500 | ["761","772"] | ["0.1235","0.1376"] | ["742.68","790.32"] | ["XCBO"] | 761.0000 | 772.0000 | 31 | 31 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:43:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06de4-3d35-72b0-84d9-0c76daebd293 | SPY | 2026-09-04 15:27 | strangle | 2 | 1 | 70 | 27930.00 | long | ask | 770.0122 | 0.0400 | ["769","771"] | ["0.0734","0.0634"] | ["765.01","774.99"] | ["XMIO"] | 769.0000 | 771.0000 | 5 | 5 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:28:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db9-f8e5-70a3-9743-611d36886eb1 | SPY | 2026-09-04 14:41 | strangle | 2 | 1 | 80 | 31840.00 | long | ask | 769.9350 | 0.0300 | ["769","771"] | ["0.0734","0.0633"] | ["765.02","774.98"] | ["XMIO"] | 769.0000 | 771.0000 | 5 | 5 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:42:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d93-890d-78b3-a403-7e237ed014fd | SPY | 2026-09-04 13:59 | strangle | 2 | 1 | 3 | 234330.00 | short | bid | 769.4800 | 6.9200 | ["50","830"] | ["2.1163","0.1673"] | ["48.90","831.10"] | ["XCBO"] | 50.0000 | 830.0000 | 133 | 133 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:00:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |