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 |
|---|
| 01a0ca65-e597-7d53-8729-8ada97472bf0 | XLE | 2026-09-22 14:34 | call_diagonal_spread | 2 | 1 | 200 | 160200.00 | short | bid | 62.2200 | 0.4500 | ["59","60"] | ["0.2977","0.2546"] | [] | ["SPHR"] | 59.0000 | 60.0000 | 24 | 59 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:34:36Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c482-30ef-74c3-aeea-70e842a49b44 | XLE | 2026-09-21 11:07 | call_diagonal_spread | 2 | 1 | 18 | 100008.00 | short | ask | 62.7050 | 2.8000 | ["35","36"] | ["1.2587","0.9513"] | [] | ["BATO"] | 35.0000 | 36.0000 | 25 | 60 | false | false | true | ||||||||||
| 01a0b617-508f-7d23-af3b-d95f03881ac7 | XLE | 2026-09-18 15:56 | call_diagonal_spread | 2 | 1 | 38 | 34428.00 | short | bid | 64.2750 | 0.3500 | ["60","61"] | ["0.1869","0.2292"] | [] | ["MCRY"] | 60.0000 | 61.0000 | 14 | 63 | false | false | true | ||||||||||
| 01a0b60e-d4b0-70a0-9602-2d7a169c168f | XLE | 2026-09-18 15:46 | call_diagonal_spread | 2 | 1 | 20 | 38580.00 | short | bid | 64.3050 | 0.4500 | ["55","59"] | ["0.4013","0.2138"] | [] | ["XISX"] | 55.0000 | 59.0000 | 12 | 364 | false | false | true | ||||||||||
| 01a0b4dc-c907-79d1-9c7e-3f119915ad72 | XLE | 2026-09-18 10:12 | call_diagonal_spread | 2 | 1 | 100 | 38500.00 | short | bid | 64.3800 | 0.0600 | ["65.5","66"] | ["0.2386","0.2488"] | [] | ["XISX"] | 65.5000 | 66.0000 | 42 | 63 | false | true | true | ||||||||||
| 01a0ab73-e19b-73c3-a2d4-4fd7e2a2f6c5 | XLE | 2026-09-16 14:21 | call_diagonal_spread | 2 | 1 | 33 | 59169.00 | short | ask | 64.7850 | 1.4500 | ["54","60"] | ["2.0991","0.2538"] | [] | ["BATO"] | 54.0000 | 60.0000 | 2 | 93 | false | false | true | ||||||||||
| 01a0ab56-b0f3-71c1-8ec3-087a6bedc0f1 | XLE | 2026-09-16 13:49 | call_diagonal_spread | 2 | 1 | 24 | 41304.00 | short | ask | 64.6905 | 0.2000 | ["54","60"] | ["1.1358","0.2500"] | [] | ["XMIO"] | 54.0000 | 60.0000 | 2 | 93 | false | false | true | ||||||||||
| 01a0aac7-8883-7882-93f7-6946a0875e07 | XLE | 2026-09-16 11:13 | call_diagonal_spread | 2 | 1 | 22 | 82390.00 | short | ask | 64.0700 | 2.8000 | ["45","54"] | ["0.3336","0.1545"] | [] | ["XMIO"] | 45.0000 | 54.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0aab8-afbb-7d70-a573-3456725a5e67 | XLE | 2026-09-16 10:57 | call_diagonal_spread | 2 | 1 | 10 | 34170.00 | short | ask | 64.3550 | 0.4000 | ["45","50"] | ["2.1425","0.3619"] | [] | ["XPHO"] | 45.0000 | 50.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0aaa9-8103-74c1-bdfd-1cb58720e437 | XLE | 2026-09-16 10:40 | call_diagonal_spread | 2 | 1 | 10 | 47680.00 | short | bid | 64.4950 | 2.4500 | ["38.5","44"] | ["0.4698","3.4254"] | [] | ["BATO"] | 38.5000 | 44.0000 | 2 | 274 | false | false | true | ||||||||||
| 01a0aa84-74a3-7e60-b2e0-f9265f02904e | XLE | 2026-09-16 10:00 | call_diagonal_spread | 2 | 1 | 25 | 27200.00 | short | bid | 64.7050 | 0.5500 | ["60","65"] | ["0.5806","0.2346"] | [] | ["XMIO"] | 60.0000 | 65.0000 | 2 | 274 | false | false | true | ||||||||||
| 01a0a66a-1d16-7053-979e-1dc11a23e396 | XLE | 2026-09-15 14:52 | call_diagonal_spread | 2 | 1 | 20 | 54520.00 | short | bid | 65.8750 | 0.6000 | ["52","52.5"] | ["0.3740","1.3979"] | [] | ["XMIO"] | 52.0000 | 52.5000 | 3 | 31 | false | false | true | ||||||||||
| 01a0a640-617e-79c0-be16-dbac0a09e737 | XLE | 2026-09-15 14:07 | call_diagonal_spread | 2 | 2 | 38 | 46360.00 | short | bid | 66.0150 | 0.1500 | ["60","62.5"] | ["0.2821","0.2366"] | [] | ["EDGO","XISX"] | 60.0000 | 62.5000 | 15 | 122 | false | false | true | ||||||||||
| 01a0a5d0-f60e-7c92-8889-317ae358295b | XLE | 2026-09-15 12:05 | call_diagonal_spread | 2 | 1 | 10 | 41440.00 | short | ask | 65.6900 | 2.5500 | ["42","50"] | ["0.2618","0.2836"] | [] | ["XMIO"] | 42.0000 | 50.0000 | 122 | 493 | false | false | true | ||||||||||
| 01a0a02b-7029-7d53-9ce0-73b97d978cf9 | XLE | 2026-09-14 09:46 | call_diagonal_spread | 2 | 1 | 20 | 41800.00 | short | bid | 65.9400 | 0.6000 | ["52.5","59"] | ["0.2535","0.6846"] | [] | ["XMIO"] | 52.5000 | 59.0000 | 4 | 95 | false | false | true | ||||||||||
| 01a09113-1e88-7832-ac00-5c20bc613116 | XLE | 2026-09-11 11:25 | call_diagonal_spread | 2 | 1 | 168 | 216384.00 | short | bid | 65.0700 | 0.4000 | ["59","60"] | ["0.4311","0.2331"] | [] | ["AMXO"] | 59.0000 | 60.0000 | 7 | 98 | false | false | true | ||||||||||
| 01a09110-1919-7b20-bfc4-44e50dd8f162 | XLE | 2026-09-11 11:22 | call_diagonal_spread | 2 | 1 | 534 | 764688.00 | short | ask | 65.0200 | 0.5000 | ["57.5","60"] | ["0.5947","0.2289"] | [] | ["ARCO"] | 57.5000 | 60.0000 | 7 | 98 | false | false | true | ||||||||||
| 01a09105-5348-7202-998d-8b4241a92578 | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 7 | 174 | 117270.00 | short | bid | 64.8050 | 0.1800 | ["65","68"] | ["0.2526","0.2410"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a09105-2c38-78e2-a55d-6e00dbd35e8a | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 9 | 326 | 221828.00 | short | bid | 64.8350 | 0.1700 | ["65","68"] | ["0.2527","0.2428"] | [] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","XCBO","XISX"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a09105-2c38-78e2-a55d-6df29498d909 | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 8 | 184 | 124984.00 | short | bid | 64.8350 | 0.1654 | ["65","68"] | ["0.2521","0.2424"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a09105-14c8-7972-91c0-d65cf7bb6fce | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 6 | 145 | 98851.00 | short | bid | 64.8600 | 0.1700 | ["65","68"] | ["0.2516","0.2427"] | [] | ["AMXO","EMLD","MCRY","XISX","XMIO","XPHO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a090f2-ec58-7331-b458-f301fecb700e | XLE | 2026-09-11 10:50 | call_diagonal_spread | 2 | 1 | 200 | 300000.00 | short | ask | 64.8197 | 1.0000 | ["55","65"] | ["0.6783","0.2294"] | [] | ["SPHR"] | 55.0000 | 65.0000 | 7 | 201 | false | false | true | ||||||||||
| 01a08749-9c60-7790-b5b4-b3ee29f3260e | XLE | 2026-09-09 13:49 | call_diagonal_spread | 2 | 1 | 16 | 40848.00 | short | ask | 65.3750 | 1.0500 | ["50","57.5"] | ["0.3113","0.2100"] | [] | ["XCBO"] | 50.0000 | 57.5000 | 128 | 203 | false | false | true | ||||||||||
| 01a086e1-35d0-78e2-a1ee-98097dfbf186 | XLE | 2026-09-09 11:54 | call_diagonal_spread | 2 | 1 | 88 | 85800.00 | short | ask | 65.2397 | 0.3500 | ["60","65"] | ["0.2720","0.2388"] | [] | ["SPHR"] | 60.0000 | 65.0000 | 21 | 128 | false | false | true | ||||||||||
| 01a08239-0e68-7130-ad7a-4c942aabcd51 | XLE | 2026-09-08 14:12 | call_diagonal_spread | 2 | 1 | 30 | 30090.00 | short | ask | 64.7200 | 0.3500 | ["62.5","67.5"] | ["0.2287","0.2267"] | [] | ["XCBO"] | 62.5000 | 67.5000 | 129 | 282 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:07:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:56:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:47:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:12:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:21:54Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:50:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:13:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:57:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:40:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:00:03Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:07:24Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:05:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:46:50Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:25:47Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:22:43Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:10:45Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:10:45Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:10:45Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:10:45Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:50:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:50:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:55:31Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:13:09Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |