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 |
|---|
| 01a0c979-7a27-7033-8c12-38fcfac867a9 | XLE | 2026-09-22 10:16 | call_diagonal_spread | 2 | 1 | 100 | 49000.00 | long | ask | 62.3300 | 0.7300 | ["60","65"] | ["0.2686","0.2533"] | [] | ["XMIO"] | 60.0000 | 65.0000 | 24 | 59 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:16:15Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c582-c86f-7b03-90ff-f94a8d0f79aa | XLE | 2026-09-21 15:47 | call_diagonal_spread | 2 | 1 | 532 | 256424.00 | long | ask | 62.5200 | 0.0600 | ["65","66"] | ["0.2598","0.2707"] | [] | ["EDGO"] | 65.0000 | 66.0000 | 88 | 101 | false | true | true | ||||||||||
| 01a0c582-c86f-7b03-90ff-f9254033c324 | XLE | 2026-09-21 15:47 | call_diagonal_spread | 2 | 3 | 229 | 110016.00 | long | ask | 62.5200 | 0.0400 | ["65","66"] | ["0.2592","0.2700"] | [] | ["AMXO","ARCO","SPHR"] | 65.0000 | 66.0000 | 88 | 101 | false | true | true | ||||||||||
| 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 | ||||||||||
| 01a0b60c-7737-73d0-aa26-31f361f229fc | XLE | 2026-09-18 15:44 | call_diagonal_spread | 2 | 1 | 20 | 52400.00 | unknown | ask | 64.3200 | 0.6500 | ["45","65"] | ["30.4610","0.2272"] | [] | ["XCBO"] | 45.0000 | 65.0000 | 0 | 364 | false | false | true | ||||||||||
| 01a0b5d5-a7f8-7213-8af6-831ec7f96f27 | XLE | 2026-09-18 14:44 | call_diagonal_spread | 2 | 1 | 34 | 91766.00 | long | ask | 64.4000 | 1.0500 | ["51","52"] | ["0.3364","0.2031"] | [] | ["XISX"] | 51.0000 | 52.0000 | 63 | 182 | false | false | 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 | ||||||||||
| 01a0a67c-aefe-7f50-9424-b710db6a2ea3 | XLE | 2026-09-15 15:13 | call_diagonal_spread | 2 | 1 | 20 | 117920.00 | long | ask | 65.8000 | 3.5000 | ["35","38"] | ["1.1512","2.6667"] | [] | ["BATO"] | 35.0000 | 38.0000 | 3 | 31 | false | false | true | ||||||||||
| 01a0a637-ab06-7f72-bcd5-7669fa0829a8 | XLE | 2026-09-15 13:57 | call_diagonal_spread | 2 | 1 | 14 | 25816.00 | long | ask | 66.1000 | 0.8500 | ["65","70"] | ["0.2161","0.2078"] | [] | ["XPHO"] | 65.0000 | 70.0000 | 458 | 822 | 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 | ||||||||||
| 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-8b9c21764a08 | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 7 | 215 | 145383.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2527","0.2421"] | [] | ["BATO","C2OX","EDGO","XCBO","XISX"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a09105-5348-7202-998d-8b8a0007119c | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 6 | 161 | 108533.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2517","0.2416"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XPHO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a09105-5348-7202-998d-8b7393e63be3 | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 6 | 108 | 73008.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2526","0.2421"] | [] | ["ARCO","BATO","C2OX","EDGO","XCBO","XISX"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a09105-5348-7202-998d-8b5441204ddf | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 5 | 120 | 81144.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2527","0.2421"] | [] | ["BATO","C2OX","EDGO","XCBO","XISX"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | ||||||||||
| 01a09105-3fc0-7de2-953d-248c79abb6ae | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 6 | 168 | 113624.00 | long | ask | 64.8150 | 0.1800 | ["65","68"] | ["0.2523","0.2419"] | [] | ["ARCO","BATO","C2OX","EDGO","XCBO","XISX"] | 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-21T19:47:59Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:47:59Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:44:37Z"} |
| 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-18T18:45:03Z"} |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:13:03Z"} |
| 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-15T17:58:07Z"} |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |