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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b565-61c7-7fc3-b32d-7a6983529fec | SPY | 2026-09-18 12:41 | put_frontspread | 2 | 5 | 448 | 59031.00 | long | ask | 758.8950 | 0.0200 | ["750","755"] | ["0.1053","0.0920"] | ["754.38"] | ["BATO","C2OX","EDGO","MCRY","XISX"] | 750.0000 | 755.0000 | 3 | 3 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:42:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bf-3a9f-7982-b355-892e73559b40 | SPY | 2026-09-18 09:40 | put_frontspread | 2 | 2 | 54 | 70060.00 | long | ask | 761.0800 | 0.1000 | ["680","755"] | ["0.2236","0.1477"] | ["491.84","745.86"] | ["ARCO","XBOX"] | 680.0000 | 755.0000 | 63 | 63 | false | true | false | true | false | mesl | 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 |
| 01a0afbf-23c3-7b91-b1dc-3a8d094a05ea | SPY | 2026-09-17 10:22 | put_frontspread | 2 | 1 | 966 | 41055.00 | long | ask | 761.6650 | 0.0200 | ["756","760"] | ["0.2005","0.1663"] | ["752.37","759.63"] | ["EMLD"] | 756.0000 | 760.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:22:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab59-163a-7093-9102-b77ecc8cc2f4 | SPY | 2026-09-16 13:52 | put_frontspread | 2 | 3 | 834 | 55327.00 | long | ask | 759.6900 | 0.0200 | ["750","751"] | ["0.6084","0.6036"] | ["750.90"] | ["ARCO","C2OX","XBOX"] | 750.0000 | 751.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:52:44Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a09166-3410-74b0-b5ff-da6b784f793a | SPY | 2026-09-11 12:56 | put_frontspread | 2 | 3 | 108 | 48888.00 | long | ask | 765.4900 | 0.0400 | ["750","762"] | ["0.1653","0.1450"] | ["729.62","760.19"] | ["C2OX","EMLD","XBOX"] | 750.0000 | 762.0000 | 7 | 7 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:56:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09166-1ca0-7423-a236-0170021a0eb2 | SPY | 2026-09-11 12:56 | put_frontspread | 2 | 2 | 57 | 25897.00 | long | ask | 765.4800 | 0.0374 | ["750","762"] | ["0.1656","0.1452"] | ["729.61","760.20"] | ["ARCO","C2OX"] | 750.0000 | 762.0000 | 7 | 7 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:56:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090bd-6150-71e0-b468-4e2b41581cd6 | SPY | 2026-09-11 09:52 | put_frontspread | 2 | 1 | 505 | 99855.00 | long | ask | 765.0950 | 0.0200 | ["736","742"] | ["0.2053","0.1931"] | ["741.60"] | ["C2OX"] | 736.0000 | 742.0000 | 7 | 7 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:52:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090bd-5d68-7920-89e1-3386c91f9f3c | SPY | 2026-09-11 09:52 | put_frontspread | 2 | 1 | 145 | 28615.00 | long | ask | 765.0950 | 0.0200 | ["736","742"] | ["0.2053","0.1931"] | ["741.59"] | ["C2OX"] | 736.0000 | 742.0000 | 7 | 7 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:52:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cdc-1bf8-7db2-b8e3-cabcc32ee1f5 | SPY | 2026-09-10 15:47 | put_frontspread | 2 | 1 | 201 | 114034.00 | long | ask | 757.8200 | 0.0500 | ["615","730"] | ["0.3033","0.1831"] | ["559.89","725.22"] | ["ARCO"] | 615.0000 | 730.0000 | 71 | 71 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:47:30Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c77-9598-7361-b8ff-2a8983e0f636 | SPY | 2026-09-10 13:57 | put_frontspread | 2 | 3 | 230 | 38847.00 | long | ask | 758.3150 | 0.0200 | ["747","755"] | ["0.2298","0.2015"] | ["730.96","753.87"] | ["ARCO","C2OX"] | 747.0000 | 755.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:58:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c77-91b0-7ba2-89d8-bf3637a18f95 | SPY | 2026-09-10 13:57 | put_frontspread | 2 | 2 | 190 | 32158.00 | long | ask | 758.3150 | 0.0200 | ["747","755"] | ["0.2298","0.2018"] | ["730.98","753.87"] | ["ARCO","XISX"] | 747.0000 | 755.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:58:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08711-4680-7a82-9739-6ac358ae7623 | SPY | 2026-09-09 12:47 | put_frontspread | 2 | 3 | 112 | 29519.00 | long | ask | 762.2300 | 0.0200 | ["753","758"] | ["0.1780","0.1632"] | ["756.88"] | ["ARCO","C2OX","EMLD"] | 753.0000 | 758.0000 | 2 | 2 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:48:04Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08711-32f8-78d2-91c6-7e8fe356b2af | SPY | 2026-09-09 12:47 | put_frontspread | 2 | 4 | 244 | 62892.00 | long | ask | 762.2600 | 0.0200 | ["753","758"] | ["0.1783","0.1637"] | ["756.82"] | ["ARCO","EMLD"] | 753.0000 | 758.0000 | 2 | 2 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:48:04Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08710-9aa0-7961-8d2a-efa302aa4548 | SPY | 2026-09-09 12:46 | put_frontspread | 2 | 6 | 132 | 33792.00 | long | ask | 762.2700 | 0.0200 | ["753","758"] | ["0.1778","0.1634"] | ["756.82"] | ["ARCO","C2OX","EMLD"] | 753.0000 | 758.0000 | 2 | 2 | false | true | false | true | false | mesl | tracked | 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 |
| 01a08710-92d0-71d2-96b5-ac1c5639a8b1 | SPY | 2026-09-09 12:46 | put_frontspread | 2 | 3 | 148 | 38147.00 | long | ask | 762.2700 | 0.0200 | ["753","758"] | ["0.1785","0.1639"] | ["756.82"] | ["ARCO","EMLD"] | 753.0000 | 758.0000 | 2 | 2 | false | true | false | true | false | mesl | tracked | 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 |
| 01a08710-8ee8-7f23-a0b5-648ea6d67882 | SPY | 2026-09-09 12:46 | put_frontspread | 2 | 4 | 276 | 71139.00 | long | ask | 762.2550 | 0.0200 | ["753","758"] | ["0.1783","0.1636"] | ["756.82"] | ["C2OX","EMLD"] | 753.0000 | 758.0000 | 2 | 2 | false | true | false | true | false | mesl | tracked | 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 |
| 01a08710-8718-79e2-88e3-4adabd176d1c | SPY | 2026-09-09 12:46 | put_frontspread | 2 | 3 | 144 | 37116.00 | long | ask | 762.2599 | 0.0200 | ["753","758"] | ["0.1783","0.1637"] | ["756.82"] | ["ARCO"] | 753.0000 | 758.0000 | 2 | 2 | false | true | false | true | false | mesl | tracked | 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 |
| 01a08283-5dd8-7cb0-ad53-acc0a3442c9f | SPY | 2026-09-08 15:34 | put_frontspread | 2 | 2 | 567 | 102094.00 | long | ask | 767.0400 | 0.0200 | ["750","760"] | ["0.1752","0.1462"] | ["759.00"] | ["XCBO","XISX"] | 750.0000 | 760.0000 | 3 | 3 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:34:20Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08209-e430-7651-9704-f57e2bb5c280 | SPY | 2026-09-08 13:21 | put_frontspread | 2 | 1 | 45 | 25425.00 | long | ask | 767.4600 | 0.0300 | ["750","765"] | ["0.1589","0.1396"] | ["725.25","762.38"] | ["XBOX"] | 750.0000 | 765.0000 | 10 | 10 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:22:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08208-f5e8-7992-983c-53dcbaa0ce2b | SPY | 2026-09-08 13:20 | put_frontspread | 2 | 1 | 45 | 25155.00 | long | ask | 767.5900 | 0.0300 | ["750","765"] | ["0.1590","0.1395"] | ["725.19","762.40"] | ["XBOX"] | 750.0000 | 765.0000 | 10 | 10 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:20:23Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08172-d450-7a13-b661-9abdfd3d6696 | SPY | 2026-09-08 10:36 | put_frontspread | 2 | 1 | 132 | 77836.00 | long | ask | 766.9399 | 0.0300 | ["735","750"] | ["0.1729","0.1539"] | ["706.55","749.22"] | ["ARCO"] | 735.0000 | 750.0000 | 24 | 24 | false | true | false | true | false | mesl | tracked | 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 |
| 01a08153-2ec0-7b71-8e08-08c08413cc33 | SPY | 2026-09-08 10:01 | put_frontspread | 2 | 1 | 10 | 31010.00 | long | ask | 767.0800 | 0.1100 | ["765","770"] | ["0.1560","0.1537"] | ["741.90"] | ["XISX"] | 765.0000 | 770.0000 | 101 | 101 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:01:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d29-2a95-77d3-ba39-d2ed8956e3ee | SPY | 2026-09-04 12:03 | put_frontspread | 2 | 1 | 10 | 28550.00 | long | ask | 769.9500 | 0.0600 | ["765","770"] | ["0.1511","0.1487"] | ["743.38"] | ["XISX"] | 765.0000 | 770.0000 | 105 | 105 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:03:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |