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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5c8-caff-79b0-b897-5961ac8d0181 | SPY | 2026-09-18 14:30 | risk_reversal | 2 | 1 | 4 | 54600.00 | short | bid | 760.3300 | 1.0700 | ["760","790"] | ["0.2062","0.1698"] | ["821.00"] | ["XBOX"] | 760.0000 | 790.0000 | 637 | 637 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b3-b13b-76a0-96d3-1e35e7f094e1 | SPY | 2026-09-17 14:49 | risk_reversal | 2 | 1 | 6 | 41610.00 | short | bid | 762.5500 | 0.0800 | ["700","800"] | ["0.2018","0.1519"] | ["820.53"] | ["XISX"] | 700.0000 | 800.0000 | 365 | 365 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:49:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab28-03bb-7553-89b7-216ae475250a | SPY | 2026-09-16 12:58 | risk_reversal | 2 | 1 | 33 | 59202.00 | long | bid | 759.9050 | 0.0400 | ["755","767"] | ["0.1507","0.1193"] | ["753.56"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:59:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab27-ffd3-7562-9f07-147df094528d | SPY | 2026-09-16 12:58 | risk_reversal | 2 | 1 | 14 | 25116.00 | long | bid | 759.9050 | 0.0400 | ["755","767"] | ["0.1507","0.1193"] | ["753.56"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:59:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab27-fbeb-7602-a5a1-6ae654a87f5e | SPY | 2026-09-16 12:58 | risk_reversal | 2 | 1 | 17 | 30498.00 | long | bid | 759.8950 | 0.0400 | ["755","767"] | ["0.1506","0.1193"] | ["753.56"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:59:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab27-d4db-7763-97f1-f429ed289a41 | SPY | 2026-09-16 12:58 | risk_reversal | 2 | 1 | 50 | 89700.00 | long | bid | 759.9150 | 0.0500 | ["755","767"] | ["0.1506","0.1193"] | ["753.58"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:59:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab27-d0f3-7650-9bcf-349b0582db2a | SPY | 2026-09-16 12:58 | risk_reversal | 2 | 1 | 31 | 55614.00 | long | bid | 759.8900 | 0.0600 | ["755","767"] | ["0.1505","0.1195"] | ["753.58"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:59:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab27-c53b-7553-b6fd-f19433a8f029 | SPY | 2026-09-16 12:58 | risk_reversal | 2 | 1 | 20 | 35880.00 | long | bid | 759.9100 | 0.0400 | ["755","767"] | ["0.1507","0.1193"] | ["753.56"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:58:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab27-406a-71d3-80ed-9e22e3ec8642 | SPY | 2026-09-16 12:57 | risk_reversal | 2 | 2 | 26 | 46644.00 | long | bid | 759.9100 | 0.0400 | ["755","767"] | ["0.1506","0.1194"] | ["753.58"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:58:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab27-34b2-7821-80df-4178fa956e21 | SPY | 2026-09-16 12:57 | risk_reversal | 2 | 2 | 18 | 32292.00 | long | bid | 759.8800 | 0.0400 | ["755","767"] | ["0.1506","0.1194"] | ["753.56"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:58:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab26-fa1b-75a1-ba3f-aeb3d951dd03 | SPY | 2026-09-16 12:57 | risk_reversal | 2 | 1 | 19 | 34086.00 | long | bid | 759.8800 | 0.0300 | ["755","767"] | ["0.1507","0.1193"] | ["753.54"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:58:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab26-bb9b-7590-936a-cecb3d7303fe | SPY | 2026-09-16 12:57 | risk_reversal | 2 | 1 | 28 | 50232.00 | short | ask | 759.8700 | 0.0200 | ["755","767"] | ["0.1508","0.1192"] | ["753.52"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:57:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab25-d90b-7a32-a33f-142511200041 | SPY | 2026-09-16 12:56 | risk_reversal | 2 | 1 | 50 | 89700.00 | long | bid | 759.9850 | 0.0200 | ["755","767"] | ["0.1507","0.1192"] | ["753.62"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:57:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab25-d523-70c3-a280-c0170360e628 | SPY | 2026-09-16 12:56 | risk_reversal | 2 | 1 | 24 | 43056.00 | long | bid | 759.9500 | 0.0400 | ["755","767"] | ["0.1505","0.1194"] | ["753.62"] | ["XBOX"] | 755.0000 | 767.0000 | 30 | 30 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:57:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf2-558b-7351-9c96-b8b9f1225234 | SPY | 2026-09-16 12:00 | risk_reversal | 2 | 1 | 5 | 69440.00 | long | bid | 760.6800 | 2.9100 | ["800","865"] | ["0.2099","0.1535"] | ["790.70"] | ["XBOX"] | 800.0000 | 865.0000 | 856 | 856 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:00:38Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a662-83c6-70a2-b4c9-7e03ae02a775 | SPY | 2026-09-15 14:44 | risk_reversal | 2 | 3 | 31 | 28985.00 | short | ask | 757.2050 | 0.0200 | ["760","762"] | ["0.2087","0.1508"] | ["755.17"] | ["XBOX","XISX"] | 760.0000 | 762.0000 | 3 | 3 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:45:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5db-90e6-7453-aff8-a79cc783ccf7 | SPY | 2026-09-15 12:17 | risk_reversal | 2 | 1 | 10 | 37890.00 | short | bid | 756.8150 | 0.1300 | ["730","760"] | ["0.1806","0.1430"] | ["770.95"] | ["XISX"] | 730.0000 | 760.0000 | 94 | 94 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:17:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a142-3758-7401-bc79-da2b259ae064 | SPY | 2026-09-14 14:51 | risk_reversal | 2 | 1 | 38 | 79990.00 | short | ask | 762.4400 | 0.0200 | ["745","785"] | ["0.1654","0.1229"] | ["742.33"] | ["XBOX"] | 745.0000 | 785.0000 | 67 | 67 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:52:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a12d-72f1-7780-901e-682bdfec440f | SPY | 2026-09-14 14:28 | risk_reversal | 2 | 1 | 15 | 31575.00 | short | ask | 761.9700 | 0.0200 | ["745","785"] | ["0.1656","0.1229"] | ["741.99"] | ["XBOX"] | 745.0000 | 785.0000 | 67 | 67 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:28:29Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0cc-ccc0-7f72-b968-1d26cc325934 | SPY | 2026-09-14 12:42 | risk_reversal | 2 | 1 | 49 | 103145.00 | short | ask | 762.0000 | 0.0200 | ["745","785"] | ["0.1656","0.1229"] | ["742.01"] | ["XBOX"] | 745.0000 | 785.0000 | 67 | 67 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:43:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09211-c5f0-7410-9ced-92f37db961e1 | SPY | 2026-09-11 16:03 | risk_reversal | 3 | 1 | 91 | 32032.00 | short | ask | 764.3148 | 0.0300 | ["761","764","767"] | ["0.0827","0.0745","0.0634"] | ["763.94"] | ["ARCO"] | 761.0000 | 767.0000 | 3 | 3 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T20:04:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bf4-a228-7bf1-ac76-1867157d3bfb | SPY | 2026-09-10 11:34 | risk_reversal | 2 | 2 | 329 | 39480.00 | short | ask | 759.4799 | 0.0200 | ["750","767"] | ["0.2272","0.1778"] | ["749.88"] | ["BATO"] | 750.0000 | 767.0000 | 1 | 1 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:34:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0869d-3b78-75c3-a710-b16e4a1aae4d | SPY | 2026-09-09 10:40 | risk_reversal | 2 | 3 | 8 | 75336.00 | unknown | — | 763.5800 | 0.2563 | ["785","805"] | ["0.1860","0.1513"] | [] | ["ARCO","XBOX"] | 785.0000 | 805.0000 | 373 | 373 | false | false | false | true | true | mesl | tracked | 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 |
| 01a06df9-1525-7ad1-b995-be019171bbed | SPY | 2026-09-04 15:50 | risk_reversal | 2 | 1 | 32 | 154624.00 | short | bid | 770.1200 | 0.1400 | ["690","850"] | ["0.2154","0.1382"] | ["854.30"] | ["XISX"] | 690.0000 | 850.0000 | 378 | 378 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:50:54Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de7-8125-7740-be62-de882aa2e36d | SPY | 2026-09-04 15:31 | risk_reversal | 2 | 1 | 13 | 62556.00 | short | bid | 769.9200 | 0.1200 | ["690","850"] | ["0.2150","0.1380"] | ["854.20"] | ["XISX"] | 690.0000 | 850.0000 | 378 | 378 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:31:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d51-5f8d-7730-b4a4-4aa6f702f251 | SPY | 2026-09-04 12:47 | risk_reversal | 2 | 1 | 23 | 58075.00 | long | ask | 771.1000 | 0.0400 | ["768","769"] | ["0.1319","0.1114"] | ["772.89"] | ["XBOX"] | 768.0000 | 769.0000 | 42 | 42 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:47:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d51-57bd-7490-8cbc-98e8091f99dd | SPY | 2026-09-04 12:47 | risk_reversal | 2 | 1 | 134 | 338350.00 | long | ask | 771.1099 | 0.0400 | ["768","769"] | ["0.1320","0.1113"] | ["772.89"] | ["XISX"] | 768.0000 | 769.0000 | 42 | 42 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:47:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d51-57bd-7490-8cbc-98b73e776de3 | SPY | 2026-09-04 12:47 | risk_reversal | 2 | 1 | 51 | 128775.00 | long | ask | 771.1099 | 0.0400 | ["768","769"] | ["0.1320","0.1113"] | ["772.89"] | ["XISX"] | 768.0000 | 769.0000 | 42 | 42 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:47:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d50-cb1d-7090-9aa2-de1c655698d2 | SPY | 2026-09-04 12:46 | risk_reversal | 2 | 1 | 49 | 123725.00 | long | ask | 770.9700 | 0.0900 | ["768","769"] | ["0.1321","0.1115"] | ["772.75"] | ["XBOX"] | 768.0000 | 769.0000 | 42 | 42 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:47:14Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |