core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0caad-0c6f-71d3-ad9f-0bf3a329da05 | XOM | 2026-09-22 15:52 | strangle | 2 | 1 | 32 | 56934.00 | long | ask | 158.8800 | 1.2200 | ["145","155"] | ["0.3006","0.2959"] | ["137.21","162.79"] | ["XCBO"] | 145.0000 | 155.0000 | 24 | 24 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:52:21Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0caad-0887-7d93-8e4a-56d6eb76a8c6 | XOM | 2026-09-22 15:52 | strangle | 2 | 3 | 47 | 83143.00 | unknown | — | 158.8800 | 1.2200 | ["145","155"] | ["0.2885","0.2948"] | [] | ["ARCO","EMLD","SPHR"] | 145.0000 | 155.0000 | 24 | 24 | false | false | false | true | true | ||||||||
| 01a0ca50-bf87-7081-b949-feb4bc7ec830 | XOM | 2026-09-22 14:11 | strangle | 2 | 3 | 170 | 26520.00 | long | ask | 158.7250 | 0.2400 | ["152.5","167.5"] | ["0.3103","0.3003"] | ["150.94","169.06"] | ["XMIO"] | 152.5000 | 167.5000 | 10 | 10 | false | true | false | ||||||||||
| 01a0c9b0-a728-7073-9822-654a9bb5048f | XOM | 2026-09-22 11:16 | strangle | 2 | 7 | 33 | 44451.00 | short | bid | 159.0450 | 0.5500 | ["160","165"] | ["0.3218","0.2899"] | ["146.53","178.47"] | ["AMXO","ARCO","EMLD","XCBO","XISX","XMIO","XPHO"] | 160.0000 | 165.0000 | 59 | 59 | false | false | false | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:52:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:16:51Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |