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 | directiontext |
|---|
| 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 |
|---|
| 01a0ca96-f046-7ab0-b8de-551f838662b1 | HPE | 2026-09-22 15:28 | call_diagonal_spread | 2 | 1 | 20 | 116760.00 | short | bid | 61.1450 | 2.0500 | ["13","55"] | ["1.0295","0.6359"] | [] | ["XPHO"] | 13.0000 | 55.0000 | 59 | 486 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:28:04Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca96-f046-7ab0-b8de-5507f6534268 | HPE | 2026-09-22 15:28 | call_diagonal_spread | 2 | 1 | 20 | 117160.00 | short | bid | 61.1600 | 2.0500 | ["13","55"] | ["1.0260","0.6465"] | [] | ["AMXO"] | 13.0000 | 55.0000 | 59 | 486 | false | false | true | true | |||||||||
| 01a0ca93-621f-7861-930b-1ef9a98e939f | HPE | 2026-09-22 15:24 | call_diagonal_spread | 2 | 3 | 40 | 233720.00 | short | bid | 61.1900 | 1.7000 | ["13","55"] | ["0.9416","0.6350"] | [] | ["AMXO","XISX"] | 13.0000 | 55.0000 | 59 | 486 | false | false | true | true | |||||||||
| 01a0ca93-5e37-76c2-a8a0-9f94ef49f42e | HPE | 2026-09-22 15:24 | call_diagonal_spread | 2 | 1 | 20 | 116600.00 | short | bid | 61.1900 | 1.5500 | ["13","55"] | ["0.9416","0.6272"] | [] | ["XISX"] | 13.0000 | 55.0000 | 59 | 486 | false | false | true | true | |||||||||
| 01a0c9e8-83ee-7840-acd2-b5df29bea9c5 | HPE | 2026-09-22 12:17 | call_diagonal_spread | 2 | 1 | 500 | 239000.00 | short | bid | 60.9400 | 0.3200 | ["64","70"] | ["0.6729","0.6419"] | [] | ["AMXO"] | 64.0000 | 70.0000 | 10 | 59 | false | true | true | true | |||||||||
| 01a0c53d-8dc6-72e3-8896-77331cce56f0 | HPE | 2026-09-21 14:32 | risk_reversal | 2 | 1 | 100 | 115500.00 | short | bid | 61.3350 | 0.4500 | ["55","70"] | ["0.6561","0.6536"] | ["70.75"] | ["XCBO"] | 55.0000 | 70.0000 | 116 | 116 | false | true | false | true | true | ||||||||
| 01a0c524-29c6-7cb2-af65-67b73d94cbe0 | HPE | 2026-09-21 14:04 | call_diagonal_spread | 2 | 1 | 100 | 585800.00 | short | bid | 61.0900 | 2.6000 | ["13","55"] | ["1.1187","0.6466"] | [] | ["XPHO"] | 13.0000 | 55.0000 | 60 | 487 | false | false | true | true | |||||||||
| 01a0c512-9d97-7eb2-b45b-11a7a3d73e2d | HPE | 2026-09-21 13:45 | call_diagonal_spread | 2 | 1 | 17 | 114937.00 | short | ask | 61.6750 | 1.4000 | ["27","30"] | ["0.9327","0.6418"] | [] | ["XMIO"] | 27.0000 | 30.0000 | 60 | 179 | false | false | true | true | |||||||||
| 01a0c505-18a7-7fd2-8b61-116be843f7a9 | HPE | 2026-09-21 13:30 | call_diagonal_spread | 2 | 1 | 120 | 123600.00 | short | bid | 61.7250 | 1.1000 | ["58","59"] | ["0.6120","0.6069"] | [] | ["XPHO"] | 58.0000 | 59.0000 | 11 | 25 | false | false | true | true | |||||||||
| 01a0c487-881f-76f0-b538-6253c37fed2f | HPE | 2026-09-21 11:13 | call_diagonal_spread | 2 | 1 | 180 | 189180.00 | short | ask | 60.8700 | 1.1500 | ["56","58"] | ["0.7927","0.5654"] | [] | ["BATO"] | 56.0000 | 58.0000 | 4 | 25 | false | false | true | true | |||||||||
| 01a0b0c2-8a03-7283-b4b8-fbb0d939e97b | HPE | 2026-09-17 15:05 | call_diagonal_spread | 2 | 1 | 235 | 124550.00 | short | bid | 61.3700 | 0.2900 | ["60","70"] | ["0.7566","0.6251"] | [] | ["MCRY"] | 60.0000 | 70.0000 | 1 | 64 | false | false | true | true | |||||||||
| 01a0b08f-d1a3-7773-a89a-98886a7b6cd9 | HPE | 2026-09-17 14:10 | synthetic | 2 | 1 | 51 | 126225.00 | short | ask | 60.9550 | 0.5000 | ["70"] | ["0.6635"] | ["62.15"] | ["XBOX"] | 70.0000 | 70.0000 | 183 | 183 | false | false | false | false | true | ||||||||
| 01a0b08f-cdbb-7720-976a-a1f27a3716b8 | HPE | 2026-09-17 14:10 | synthetic | 2 | 2 | 47 | 116325.00 | short | ask | 60.9550 | 0.9000 | ["70"] | ["0.6635"] | ["62.19"] | ["ARCO","XBOX"] | 70.0000 | 70.0000 | 183 | 183 | false | false | false | false | true | ||||||||
| 01a0afd6-ce5c-7241-9758-e2fd0fab9392 | HPE | 2026-09-17 10:48 | call_diagonal_spread | 2 | 1 | 110 | 125950.00 | short | ask | 61.9400 | 0.4000 | ["60","65"] | ["0.6416","0.6280"] | [] | ["BATO"] | 60.0000 | 65.0000 | 36 | 64 | false | false | true | true | |||||||||
| 01a0ab4d-cf83-7800-bd1f-da21ef95f03b | HPE | 2026-09-16 13:39 | call_diagonal_spread | 2 | 1 | 25 | 131450.00 | short | ask | 57.3000 | 5.5500 | ["33","37"] | ["0.7744","0.5368"] | [] | ["XMIO"] | 33.0000 | 37.0000 | 184 | 492 | false | false | true | true | |||||||||
| 01a0a5ce-1b96-7a33-a05f-ce9897222d8e | HPE | 2026-09-15 12:02 | synthetic | 2 | 3 | 195 | 444600.00 | short | ask | 56.5400 | 1.3000 | ["65"] | ["0.6510"] | ["57.64"] | ["ARCO","EMLD","XBOX"] | 65.0000 | 65.0000 | 185 | 185 | false | false | false | false | true | ||||||||
| 01a0a03a-c208-7fe1-b206-d40de8759e88 | HPE | 2026-09-14 10:03 | put_diagonal_spread | 2 | 1 | 38 | 123500.00 | short | bid | 55.9200 | 1.1000 | ["47","75"] | ["0.6418","0.6784"] | [] | ["XISX"] | 47.0000 | 75.0000 | 186 | 494 | false | false | true | true | |||||||||
| 01a0a035-2489-70c3-afdd-aa48f64eb15f | HPE | 2026-09-14 09:57 | put_diagonal_spread | 2 | 1 | 50 | 162100.00 | short | bid | 56.0300 | 1.2500 | ["47","75"] | ["0.6425","0.6781"] | [] | ["XISX"] | 47.0000 | 75.0000 | 186 | 494 | false | false | true | true | |||||||||
| 01a091f3-6880-7ed1-adc6-355890a4e896 | HPE | 2026-09-11 15:30 | call_diagonal_spread | 2 | 1 | 98 | 124558.00 | short | bid | 61.3200 | 0.6100 | ["55","60"] | ["0.6336","1.6014"] | [] | ["XISX"] | 55.0000 | 60.0000 | 0 | 98 | false | false | true | true | |||||||||
| 01a09146-9650-7d32-9281-43a7ccde34ee | HPE | 2026-09-11 12:21 | call_diagonal_spread | 2 | 1 | 120 | 111600.00 | short | ask | 60.5900 | 0.7625 | ["56","57"] | ["2.6991","0.5041"] | [] | ["XMIO"] | 56.0000 | 57.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a090f8-3000-7d40-b96b-55b00acbdf8b | HPE | 2026-09-11 10:56 | call_vertical_spread | 2 | 1 | 1200 | 775200.00 | short | bid | 61.0300 | 1.1500 | ["61","64"] | ["0.6089","0.6854"] | ["61.80"] | ["ARCO"] | 61.0000 | 64.0000 | 21 | 21 | false | false | false | true | |||||||||
| 01a0865e-d6d0-77a3-b6d4-36f1aae9a325 | HPE | 2026-09-09 09:32 | call_vertical_spread | 2 | 1 | 20 | 103100.00 | short | bid | 57.5800 | 6.0000 | ["30","35"] | ["0.4708","0.5796"] | ["34.51"] | ["XISX"] | 30.0000 | 35.0000 | 128 | 128 | false | false | false | true | |||||||||
| 01a08169-ac91-72d0-81e6-b02e9d988404 | HPE | 2026-09-08 10:26 | call_vertical_spread | 2 | 1 | 39 | 234546.00 | short | bid | 54.6000 | 1.3000 | ["18","40"] | ["0.4942","0.5997"] | ["33.08"] | ["MCRY"] | 18.0000 | 40.0000 | 500 | 500 | false | false | false | true | |||||||||
| 01a0814c-8f71-7343-8cbb-014c16510051 | HPE | 2026-09-08 09:54 | call_vertical_spread | 2 | 2 | 600 | 402743.00 | short | bid | 52.9400 | 0.9267 | ["49","51"] | ["0.6154","0.7818"] | ["50.41"] | ["C2OX"] | 49.0000 | 51.0000 | 3 | 3 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:28:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:24:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:24:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:18:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:32:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:04:57Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:45:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:31:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:13:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:05:50Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:10:46Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:10:46Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:48:30Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:40:36Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:02:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:03:18Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:57:20Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:31:06Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:22:16Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:56:46Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:32:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:26:25Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:54:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |