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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c534-94e7-73a0-85d1-f853a5fdad28 | SPY | 2026-09-21 14:22 | put_frontspread | 2 | 2 | 420 | 252741.00 | long | ask | 773.6850 | 0.0400 | ["745","768"] | ["0.1565","0.1265"] | ["723.47","766.53"] | ["EDGO","MCRY"] | 745.0000 | 768.0000 | 25 | 25 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:22:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c534-94e7-73a0-85d1-f84a87e8c341 | SPY | 2026-09-21 14:22 | put_frontspread | 2 | 1 | 146 | 88038.00 | long | ask | 773.6850 | 0.0400 | ["745","768"] | ["0.1567","0.1266"] | ["723.46","766.54"] | ["EDGO"] | 745.0000 | 768.0000 | 25 | 25 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:22:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c534-94e7-73a0-85d1-f817c9360d05 | SPY | 2026-09-21 14:22 | put_frontspread | 2 | 1 | 292 | 176076.00 | long | ask | 773.6850 | 0.0400 | ["745","768"] | ["0.1567","0.1266"] | ["723.46","766.54"] | ["EDGO"] | 745.0000 | 768.0000 | 25 | 25 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:22:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c534-71bf-7540-9829-f7b7c85ffffe | SPY | 2026-09-21 14:22 | put_frontspread | 2 | 1 | 88 | 53284.00 | long | ask | 773.5500 | 0.0400 | ["745","768"] | ["0.1564","0.1264"] | ["723.47","766.53"] | ["EDGO"] | 745.0000 | 768.0000 | 25 | 25 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:22:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c48d-ecd7-74c0-b65d-d81d6e7a5e47 | SPY | 2026-09-21 11:20 | put_frontspread | 2 | 1 | 375 | 219625.00 | long | ask | 770.0600 | 0.0200 | ["760","769"] | ["0.1245","0.1119"] | ["744.51","767.74"] | ["XMIO"] | 760.0000 | 769.0000 | 11 | 11 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:20:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b03d-779b-7341-87d6-70b119065951 | SPY | 2026-09-17 12:40 | put_frontspread | 2 | 1 | 562 | 361366.00 | long | ask | 762.1100 | 0.0900 | ["745","760"] | ["0.1565","0.1357"] | ["730.70","759.30"] | ["EDGO"] | 745.0000 | 760.0000 | 15 | 15 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:40:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abbc-0273-7421-b87e-90cacc71ffbe | SPY | 2026-09-16 15:40 | put_frontspread | 2 | 1 | 60 | 41010.00 | long | ask | 752.1800 | 0.0600 | ["627","650"] | ["0.2690","0.2484"] | ["601.15"] | ["XCBO"] | 627.0000 | 650.0000 | 106 | 106 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a158-7a90-7c92-9282-5cec6314c05c | SPY | 2026-09-14 15:15 | put_frontspread | 2 | 1 | 153 | 47124.00 | long | ask | 761.8900 | 0.0200 | ["600","650"] | ["0.3216","0.2648"] | ["500.96","649.52"] | ["XPHO"] | 600.0000 | 650.0000 | 67 | 67 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:15:23Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a11d-4e20-72f0-a348-7509244088ec | SPY | 2026-09-14 14:10 | put_frontspread | 2 | 1 | 75 | 31750.00 | unknown | — | 762.3808 | 0.0600 | ["727","755"] | ["0.1967","0.1527"] | [] | ["MCRY"] | 727.0000 | 755.0000 | 18 | 18 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:11:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a117-cbf8-73a1-8253-bafe04d21df3 | SPY | 2026-09-14 14:04 | put_frontspread | 2 | 1 | 150 | 48350.00 | long | ask | 762.2386 | 0.0200 | ["745","755"] | ["0.2122","0.1882"] | ["727.05","753.98"] | ["EDGO"] | 745.0000 | 755.0000 | 4 | 4 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:05:07Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a117-9548-7f03-a8c2-463fd099189c | SPY | 2026-09-14 14:04 | put_frontspread | 2 | 1 | 102 | 32776.00 | long | ask | 762.2900 | 0.0300 | ["745","755"] | ["0.2124","0.1884"] | ["727.04","753.98"] | ["EDGO"] | 745.0000 | 755.0000 | 4 | 4 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:05:07Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09207-1f60-7d11-8f19-03dc39bb0ffc | SPY | 2026-09-11 15:52 | put_frontspread | 2 | 1 | 422 | 142847.00 | long | ask | 764.5000 | 0.0500 | ["720","750"] | ["0.1965","0.1501"] | ["691.71","748.29"] | ["EDGO"] | 720.0000 | 750.0000 | 19 | 19 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:52:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0913a-b358-7340-b958-9c50b76845db | SPY | 2026-09-11 12:08 | put_frontspread | 2 | 1 | 10 | 67680.00 | long | ask | 765.8400 | 2.0400 | ["795","800"] | ["0.1483","0.1522"] | ["751.80","799.80"] | ["AMXO"] | 795.0000 | 800.0000 | 70 | 70 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:09:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c6-df00-77a0-b4b5-271bf41f7b20 | SPY | 2026-09-11 10:02 | put_frontspread | 2 | 1 | 9960 | 3192058.00 | long | ask | 765.6800 | 0.0500 | ["750","755"] | ["0.1737","0.1644"] | ["743.97"] | ["XMIO"] | 750.0000 | 755.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:02:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b8-3131-71f1-aee3-76a35ed0b467 | SPY | 2026-09-11 09:46 | put_frontspread | 2 | 1 | 261 | 151467.00 | unknown | — | 765.8000 | 0.0700 | ["735","750"] | ["0.1789","0.1573"] | [] | ["XMIO"] | 735.0000 | 750.0000 | 21 | 21 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:46:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce7-9578-70e0-8825-29233d1d4934 | SPY | 2026-09-10 15:59 | put_frontspread | 2 | 1 | 500 | 399750.00 | long | ask | 757.7400 | 0.0900 | ["749","757"] | ["0.1865","0.1739"] | ["739.23"] | ["XPHO"] | 749.0000 | 757.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:59:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c5d-b498-7e03-ad90-ba920c62294e | SPY | 2026-09-10 13:29 | put_frontspread | 2 | 1 | 56 | 64512.00 | long | ask | 758.6000 | 0.0700 | ["758","768"] | ["0.1931","0.1496"] | ["760.58"] | ["EDGO"] | 758.0000 | 768.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:29:30Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba3-1728-79f2-9f31-eb4ac204b58f | SPY | 2026-09-10 10:05 | put_frontspread | 2 | 1 | 50 | 81950.00 | long | ask | 757.3500 | 0.2300 | ["757","762"] | ["0.1573","0.1526"] | ["744.06"] | ["XCBO"] | 757.0000 | 762.0000 | 20 | 20 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:05:32Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08710-63f0-7381-b529-012389543935 | SPY | 2026-09-09 12:46 | put_frontspread | 2 | 1 | 1000 | 256000.00 | long | ask | 762.2850 | 0.0200 | ["753","758"] | ["0.1779","0.1636"] | ["756.82"] | ["EDGO"] | 753.0000 | 758.0000 | 2 | 2 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:47:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e2-7a08-7f90-9864-01ba6b7d98fa | SPY | 2026-09-09 11:56 | put_frontspread | 2 | 1 | 56 | 93080.00 | long | ask | 762.0100 | 0.1100 | ["725","755"] | ["0.1822","0.1535"] | ["577.49","749.58"] | ["XMIO"] | 725.0000 | 755.0000 | 51 | 51 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:56:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c4-62e8-7111-b197-cf0fa63184bb | SPY | 2026-09-09 11:23 | put_frontspread | 2 | 1 | 44 | 55242.00 | long | ask | 761.1800 | 0.1700 | ["762","767"] | ["0.1556","0.1534"] | ["752.23"] | ["XCBO"] | 762.0000 | 767.0000 | 9 | 9 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:23:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08225-3c30-7df3-a098-3cf3a81e2633 | SPY | 2026-09-08 13:51 | put_frontspread | 2 | 1 | 20 | 30176.00 | long | ask | 767.5850 | 0.0600 | ["735","745"] | ["0.1720","0.1635"] | ["714.17"] | ["XCBO"] | 735.0000 | 745.0000 | 73 | 73 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:51:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08172-d450-7a13-b661-9acd12d72abe | SPY | 2026-09-08 10:36 | put_frontspread | 2 | 1 | 189 | 111447.00 | long | ask | 766.9399 | 0.0300 | ["735","750"] | ["0.1729","0.1539"] | ["706.55","749.22"] | ["XPHO"] | 735.0000 | 750.0000 | 24 | 24 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:36:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dff-d3b5-7841-b1f1-9b155b8a92a0 | SPY | 2026-09-04 15:57 | put_frontspread | 2 | 1 | 40 | 30260.00 | long | ask | 770.2805 | 0.0600 | ["750","766"] | ["0.1444","0.1287"] | ["734.13","765.87"] | ["MCRY"] | 750.0000 | 766.0000 | 26 | 26 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:58:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |