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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5a8-fe5f-76c3-a619-f4b6871f58d6 | SPCX | 2026-09-18 13:55 | put_vertical_spread | 2 | 2 | 37 | 26825.00 | long | ask | 152.2950 | 0.0600 | ["120","150"] | ["0.5513","0.4832"] | ["143.75"] | ["XISX","XMIO"] | 120.0000 | 150.0000 | 28 | 28 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:56:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a8-b03f-77b0-b6bd-12b61c1a1930 | SPCX | 2026-09-18 13:55 | put_vertical_spread | 2 | 2 | 53 | 38425.00 | long | ask | 152.2950 | 0.0600 | ["120","150"] | ["0.5513","0.4832"] | ["143.75"] | ["EDGO"] | 120.0000 | 150.0000 | 28 | 28 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:56:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a8-90ff-7e53-b367-e3920b894c98 | SPCX | 2026-09-18 13:55 | put_vertical_spread | 2 | 3 | 43 | 31175.00 | long | ask | 152.2900 | 0.0600 | ["120","150"] | ["0.5512","0.4830"] | ["143.75"] | ["XBOX","XISX","XMIO"] | 120.0000 | 150.0000 | 28 | 28 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:55:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b9-56cf-76d3-8d57-2d6c3a7493e5 | SPCX | 2026-09-18 09:33 | put_vertical_spread | 2 | 2 | 190 | 183350.00 | long | ask | 155.7900 | 0.0800 | ["135","155"] | ["0.5217","0.5000"] | ["148.75"] | ["C2OX"] | 135.0000 | 155.0000 | 28 | 28 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:34:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b09e-ae53-7723-b427-8b38acbf32b1 | SPCX | 2026-09-17 14:26 | put_vertical_spread | 2 | 3 | 99 | 99000.00 | long | ask | 155.0000 | 0.1400 | ["135","155"] | ["0.5066","0.4883"] | ["148.50"] | ["AMXO","ARCO","MCRY"] | 135.0000 | 155.0000 | 29 | 29 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:26:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09e-ae53-7723-b427-8b0560400ac0 | SPCX | 2026-09-17 14:26 | put_vertical_spread | 2 | 3 | 58 | 58000.00 | long | ask | 155.0050 | 0.1400 | ["135","155"] | ["0.5067","0.4885"] | ["148.50"] | ["AMXO","ARCO","XMIO"] | 135.0000 | 155.0000 | 29 | 29 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:26:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aaed-d14b-7513-b7de-ebaa2496e4a9 | SPCX | 2026-09-16 11:55 | put_vertical_spread | 2 | 1 | 10 | 142550.00 | unknown | — | 151.8100 | 6.2500 | ["220","225"] | ["0.6599","0.6788"] | [] | ["XISX"] | 220.0000 | 225.0000 | 65 | 65 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:55:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aad3-3c9b-7ad2-8d65-66b1187cbb62 | SPCX | 2026-09-16 11:26 | put_vertical_spread | 2 | 1 | 221 | 67626.00 | long | ask | 152.7430 | 0.0200 | ["135","145"] | ["0.6236","0.5836"] | ["143.30"] | ["C2OX"] | 135.0000 | 145.0000 | 9 | 9 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:26:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aad3-38b3-7bb0-bf5a-eced4b94d289 | SPCX | 2026-09-16 11:26 | put_vertical_spread | 2 | 1 | 158 | 48348.00 | long | ask | 152.7430 | 0.0200 | ["135","145"] | ["0.6236","0.5836"] | ["143.30"] | ["C2OX"] | 135.0000 | 145.0000 | 9 | 9 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:26:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a61a-6abe-7b12-8da4-6cdd561d0b9a | SPCX | 2026-09-15 13:25 | put_vertical_spread | 2 | 1 | 180 | 29340.00 | short | bid | 143.7351 | 0.0300 | ["135","138"] | ["0.6400","0.6163"] | ["137.51"] | ["XISX"] | 135.0000 | 138.0000 | 3 | 3 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:26:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a618-e036-7891-b9f5-99e89d0a21c2 | SPCX | 2026-09-15 13:24 | put_vertical_spread | 2 | 1 | 12 | 68880.00 | unknown | — | 143.8901 | 0.5500 | ["135","185"] | ["0.5343","0.5484"] | [] | ["MCRY"] | 135.0000 | 185.0000 | 122 | 122 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:24:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a090f6-8a20-7853-9447-6617c144046d | SPCX | 2026-09-11 10:54 | put_vertical_spread | 2 | 1 | 100 | 52600.00 | short | bid | 147.4800 | 0.0500 | ["139","140"] | ["0.5220","0.5194"] | ["139.72"] | ["XISX"] | 139.0000 | 140.0000 | 14 | 14 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:54:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b96-e9f8-7dd2-a05b-1a5b3c339a82 | SPCX | 2026-09-10 09:51 | put_vertical_spread | 2 | 1 | 60 | 321300.00 | unknown | — | 152.6301 | 0.9500 | ["160","190"] | ["0.5581","0.6263"] | [] | ["XPHO"] | 160.0000 | 190.0000 | 36 | 36 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:51:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08755-dd18-7152-9a03-14be7e4ab738 | SPCX | 2026-09-09 14:02 | put_vertical_spread | 2 | 1 | 7 | 26145.00 | short | bid | 147.8550 | 2.8500 | ["148","175"] | ["0.5248","0.5624"] | ["155.05"] | ["MCRY"] | 148.0000 | 175.0000 | 30 | 30 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:03:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0873d-6760-7ce1-95b1-03228dfd87e6 | SPCX | 2026-09-09 13:35 | put_vertical_spread | 2 | 1 | 11 | 128755.00 | unknown | — | 145.9500 | 0.8500 | ["110","245"] | ["0.5754","0.6109"] | [] | ["XPHO"] | 110.0000 | 245.0000 | 373 | 373 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:35:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081c6-a558-79e1-beba-07066809e686 | SPCX | 2026-09-08 12:07 | put_vertical_spread | 2 | 1 | 20 | 72500.00 | unknown | — | 153.8000 | 0.6000 | ["152.5","182.5"] | ["0.5550","0.6537"] | [] | ["XISX"] | 152.5000 | 182.5000 | 17 | 17 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:08:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d54-267d-79d0-8c1d-f65d98379dbc | SPCX | 2026-09-04 12:50 | put_vertical_spread | 2 | 1 | 21 | 142695.00 | short | bid | 148.8200 | 1.6000 | ["150","200"] | ["0.5451","0.5996"] | ["161.65"] | ["MCRY"] | 150.0000 | 200.0000 | 77 | 77 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:50:58Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |