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 | ||||||||||
| 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 | ||||||||||
| 01a0b0d9-f61b-7e21-a968-17041b1a0ff9 | XLE | 2026-09-17 15:31 | call_diagonal_spread | 2 | 1 | 14 | 30927.00 | long | bid | 64.3950 | 0.3000 | ["52.5","55"] | ["0.5888","0.2200"] | [] | ["XMIO"] | 52.5000 | 55.0000 | 13 | 92 | false | false | true | ||||||||||
| 01a0aabc-b313-7d83-ae43-519c6f4fc5fb | XLE | 2026-09-16 11:01 | call_diagonal_spread | 2 | 1 | 20 | 50080.00 | long | bid | 64.0800 | 0.9500 | ["51","55"] | ["1.9070","0.2149"] | [] | ["XPHO"] | 51.0000 | 55.0000 | 2 | 274 | 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 | ||||||||||
| 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 | ||||||||||
| 01a087ac-2ec0-77a3-9adb-0bbcebf5834c | XLE | 2026-09-09 15:36 | call_diagonal_spread | 2 | 1 | 14 | 34440.00 | long | bid | 65.4200 | 0.5500 | ["50","57.5"] | ["0.3286","0.2386"] | [] | ["XISX"] | 50.0000 | 57.5000 | 72 | 100 | false | false | true | ||||||||||
| 01a086c3-6500-79a1-bad4-e83a1a45f5a2 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 28 | 36682.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4092","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | ||||||||||
| 01a086c3-6500-79a1-bad4-e817c65e8591 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 53 | 69437.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4064","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | ||||||||||
| 01a086c3-6500-79a1-bad4-e80f774108a1 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 53 | 69433.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4058","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | ||||||||||
| 01a08682-1e10-76e0-89b8-6c9529c4eecc | XLE | 2026-09-09 10:11 | call_diagonal_spread | 2 | 1 | 12 | 31224.00 | long | bid | 65.4050 | 0.8500 | ["51","55"] | ["0.9607","0.2249"] | [] | ["XMIO"] | 51.0000 | 55.0000 | 9 | 128 | 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 |
| 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 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:31:25Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:01:56Z"} |
| 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 |
| 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 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:36:42Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 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-09T14:11:15Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |