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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c588-370f-7f82-9c41-65a1d1fbbdf6 | XOM | 2026-09-21 15:53 | strangle | 2 | 6 | 79 | 140778.00 | long | ask | 158.6800 | 0.6551 | ["145","155"] | ["0.3055","0.2927"] | ["137.18","162.82"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"] | 145.0000 | 155.0000 | 25 | 25 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:54:04Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c55d-98e7-7bf0-9b47-6927346f5f00 | XOM | 2026-09-21 15:07 | strangle | 2 | 1 | 104 | 28704.00 | long | ask | 159.4200 | 0.2600 | ["155","165"] | ["0.3016","0.2936"] | ["152.24","167.76"] | ["XISX"] | 155.0000 | 165.0000 | 11 | 11 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:07:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c55d-98e7-7bf0-9b47-691a4fe90cd4 | XOM | 2026-09-21 15:07 | strangle | 2 | 1 | 104 | 28704.00 | long | ask | 159.4200 | 0.2600 | ["155","165"] | ["0.3016","0.2936"] | ["152.24","167.76"] | ["XISX"] | 155.0000 | 165.0000 | 11 | 11 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:07:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c55d-98e7-7bf0-9b47-6904d97688f2 | XOM | 2026-09-21 15:07 | strangle | 2 | 1 | 104 | 28704.00 | long | ask | 159.4200 | 0.2600 | ["155","165"] | ["0.3016","0.2936"] | ["152.24","167.76"] | ["XISX"] | 155.0000 | 165.0000 | 11 | 11 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:07:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b612-66c0-7540-a551-acb36bfacb80 | XOM | 2026-09-18 15:50 | strangle | 2 | 2 | 60 | 112680.00 | unknown | bid | 162.2250 | 0.6500 | ["160","165"] | ["0.2856","0.3170"] | ["162.50"] | ["EMLD","XISX"] | 160.0000 | 165.0000 | 63 | 63 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-66c0-7540-a551-acaab943e56a | XOM | 2026-09-18 15:50 | strangle | 2 | 5 | 101 | 189678.00 | long | ask | 162.2250 | 0.6500 | ["160","165"] | ["0.2864","0.3163"] | ["146.22","178.78"] | ["ARCO","EMLD","SPHR","XISX","XPHO"] | 160.0000 | 165.0000 | 63 | 63 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b611-9ba1-7c51-a9a2-d80ed9b3416a | XOM | 2026-09-18 15:50 | strangle | 2 | 1 | 38 | 71326.00 | unknown | bid | 161.8900 | 0.9000 | ["160","165"] | ["0.2881","0.3153"] | ["162.38"] | ["C2OX"] | 160.0000 | 165.0000 | 63 | 63 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60d-1377-7700-83d6-afde88605bf0 | XOM | 2026-09-18 15:45 | strangle | 2 | 3 | 18 | 33696.00 | short | bid | 162.2200 | 0.5500 | ["160","165"] | ["0.2859","0.3146"] | ["146.28","178.72"] | ["BATO","C2OX","EDGO"] | 160.0000 | 165.0000 | 63 | 63 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:45:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51f-b5d8-7e30-99e2-c3fcc7c841c1 | XOM | 2026-09-18 11:25 | strangle | 2 | 1 | 107 | 80464.00 | short | bid | 163.3100 | 0.4500 | ["160","167.5"] | ["0.6408","0.6165"] | ["159.98","167.52"] | ["XISX"] | 160.0000 | 167.5000 | 0 | 0 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:26:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e7-c970-7dc1-a46f-ab220c6529e2 | XOM | 2026-09-18 10:24 | strangle | 2 | 1 | 120 | 210240.00 | short | bid | 162.7000 | 1.6000 | ["150","167.5"] | ["1.7736","1.0512"] | ["149.98","167.52"] | ["XPHO"] | 150.0000 | 167.5000 | 0 | 0 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:24:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab93-9ab4-7241-ad86-9f17ed47bbb8 | XOM | 2026-09-16 14:56 | strangle | 2 | 3 | 17 | 36142.00 | long | ask | 163.5801 | 0.4588 | ["160","175"] | ["0.3265","0.2793"] | ["138.74","196.26"] | ["XCBO","XISX","XPHO"] | 160.0000 | 175.0000 | 184 | 184 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:56:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a087b7-e6c0-7233-9e93-40f05e40381a | XOM | 2026-09-09 15:49 | strangle | 2 | 3 | 12 | 29445.00 | short | bid | 164.3801 | 1.6500 | ["155","175"] | ["0.3133","0.2745"] | ["130.46","199.54"] | ["BATO","C2OX","EDGO"] | 155.0000 | 175.0000 | 281 | 281 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:49:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |