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 |
|---|
| 01a081f7-5630-7e22-89bb-cd09c44fe9f1 | WHR | 2026-09-08 13:01 | other | 2 | 1 | 118 | 129800.00 | unknown | — | 38.7600 | 0.6000 | ["42.5"] | ["0.5361"] | [] | ["C2OX"] | 42.5000 | 42.5000 | 10 | 129 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:01:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081f7-ac20-7383-993c-e1775ca323ae | WHR | 2026-09-08 13:01 | other | 2 | 2 | 95 | 104302.00 | unknown | — | 38.7400 | 0.6000 | ["42.5"] | ["0.5286"] | [] | ["ARCO","C2OX"] | 42.5000 | 42.5000 | 10 | 129 | false | false | true | false | false | mlet | |||||||
| 01a0867d-d468-73f3-8b09-c6b11d4a7cb2 | WHR | 2026-09-09 10:06 | other | 2 | 1 | 1000 | 528850.00 | unknown | — | 37.1450 | 0.6500 | ["37.5"] | ["0.5583"] | [] | ["XCBO"] | 37.5000 | 37.5000 | 9 | 128 | false | false | true | false | false | mfsl | |||||||
| 01a08681-e760-7cd0-9b55-ed73e859168d | WHR | 2026-09-09 10:10 | other | 2 | 1 | 1000 | 400000.00 | unknown | — | 36.8000 | 0.7000 | ["37.5"] | ["0.4796"] | [] | ["AMXO"] | 37.5000 | 37.5000 | 9 | 37 | false | false | true | false | false | mlft | |||||||
| 01a0a077-ea48-7592-bca0-e50fede6e85e | WHR | 2026-09-14 11:10 | put_calendar | 2 | 1 | 100 | 107000.00 | unknown | — | 34.9600 | 1.3000 | ["40"] | ["0.6774"] | [] | ["XISX"] | 40.0000 | 40.0000 | 4 | 32 | false | false | true | false | false | mlet | |||||||
| 01a0a55d-065e-7e01-a2b0-22b98366293d | WHR | 2026-09-15 09:58 | put_diagonal_spread | 2 | 2 | 975 | 458610.00 | unknown | — | 33.2950 | 0.7000 | ["32.5","35"] | ["0.6010","0.7513"] | [] | ["XCBO"] | 32.5000 | 35.0000 | 3 | 122 | false | false | true | true | false | mfsl | |||||||
| 01a0a565-d05e-77a1-8d28-891274919bcc | WHR | 2026-09-15 10:08 | put_diagonal_spread | 2 | 1 | 299 | 182390.00 | unknown | — | 33.2100 | 0.6000 | ["32.5","35"] | ["0.6155","0.7240"] | [] | ["XMIO"] | 32.5000 | 35.0000 | 3 | 122 | false | false | true | true | false | mlet | |||||||
| 01a0a585-a4ce-73a3-a948-f4b62d746d05 | WHR | 2026-09-15 10:43 | call_diagonal_spread | 2 | 2 | 228 | 164388.00 | unknown | — | 33.6500 | 0.6500 | ["40","42.5"] | ["0.5935","0.6078"] | [] | ["ARCO","C2OX"] | 40.0000 | 42.5000 | 122 | 275 | false | true | true | true | false | mlet | |||||||
| 01a0aa98-8173-73f1-ad08-bd9e5441925d | WHR | 2026-09-16 10:21 | call_calendar | 2 | 1 | 40 | 152000.00 | unknown | — | 33.3500 | 1.4000 | ["20"] | ["0.6480"] | [] | ["XMIO"] | 20.0000 | 20.0000 | 821 | 856 | false | false | true | false | false | mlat | |||||||
| 01a0aaa3-7a0b-7642-a8cc-69db7fa52367 | WHR | 2026-09-16 10:33 | call_calendar | 2 | 1 | 50 | 142500.00 | unknown | — | 33.2300 | 2.0000 | ["30"] | ["0.6189"] | [] | ["XMIO"] | 30.0000 | 30.0000 | 821 | 856 | false | false | true | false | false | mlat | |||||||
| 01a0aaa5-9904-7a72-9706-d80c113dfa2b | WHR | 2026-09-16 10:36 | call_calendar | 2 | 1 | 49 | 138915.00 | unknown | — | 33.2500 | 1.8000 | ["30"] | ["0.6132"] | [] | ["XCBO"] | 30.0000 | 30.0000 | 821 | 856 | false | false | true | false | false | mlat | |||||||
| 01a0aab1-3993-7e20-ab91-3be855181aff | WHR | 2026-09-16 10:48 | other | 4 | 1 | 20 | 134180.00 | unknown | — | 33.2800 | 5.4000 | ["20","30"] | ["0.6481","0.6390"] | [] | ["XMIO"] | 20.0000 | 30.0000 | 821 | 856 | false | false | true | true | false | mlat | |||||||
| 01a0aab1-f12b-7a53-9270-8e072c675851 | WHR | 2026-09-16 10:49 | other | 4 | 1 | 20 | 133700.00 | unknown | — | 33.2450 | 5.4000 | ["20","30"] | ["0.6473","0.6356"] | [] | ["XCBO"] | 20.0000 | 30.0000 | 821 | 856 | false | false | true | true | false | mlat | |||||||
| 01a0aab2-7213-7f01-a9d7-e5583b780084 | WHR | 2026-09-16 10:50 | other | 4 | 1 | 20 | 134220.00 | unknown | — | 33.2400 | 5.4000 | ["20","30"] | ["0.6528","0.6406"] | [] | ["XMIO"] | 20.0000 | 30.0000 | 821 | 856 | false | false | true | true | false | mlat | |||||||
| 01a0aaba-bf13-7602-9cb1-241a121ee6eb | WHR | 2026-09-16 10:59 | other | 4 | 1 | 54 | 355482.00 | unknown | — | 33.1150 | 3.4000 | ["20","30"] | ["0.6410","0.6206"] | [] | ["XCBO"] | 20.0000 | 30.0000 | 821 | 856 | false | false | true | true | false | mlat | |||||||
| 01a0b005-0e33-7700-9a87-89a39129a0cb | WHR | 2026-09-17 11:38 | call_calendar | 2 | 1 | 50 | 183000.00 | unknown | — | 32.6550 | 2.1000 | ["20"] | ["0.6377"] | [] | ["AMXO"] | 20.0000 | 20.0000 | 820 | 855 | false | false | true | false | false | mlat | |||||||
| 01a0b089-5d4b-7433-b87c-7ccaa0126fcf | WHR | 2026-09-17 14:03 | call_vertical_spread | 2 | 1 | 50 | 123250.00 | unknown | — | 32.7900 | 1.8000 | ["22.5","32.5"] | ["0.6295","0.6041"] | [] | ["XCBO"] | 22.5000 | 32.5000 | 491 | 491 | false | false | false | true | false | mlat | |||||||
| 01a0b089-c6c3-79c2-91b6-12582d5d56c9 | WHR | 2026-09-17 14:03 | call_vertical_spread | 2 | 1 | 50 | 123250.00 | unknown | — | 32.8300 | 1.7000 | ["22.5","32.5"] | ["0.6196","0.6065"] | [] | ["XPHO"] | 22.5000 | 32.5000 | 491 | 491 | false | false | false | true | false | mlat | |||||||
| 01a0b0a2-2123-7762-93ea-4dbcef1356d0 | WHR | 2026-09-17 14:30 | other | 5 | 1 | 2440 | 3393600.00 | unknown | — | 32.7700 | 5.9000 | ["37.5","40","42.5","45","50"] | ["2.9571","3.7521","3.2519","4.1793","1.6075"] | [] | ["XBOX"] | 37.5000 | 50.0000 | 1 | 29 | true | false | true | true | false | mlft | |||||||
| 01a0b0ab-c1fb-7cb0-bcfb-5f878e67efe0 | WHR | 2026-09-17 14:40 | other | 3 | 1 | 334 | 629820.00 | unknown | — | 32.8700 | 4.0000 | ["37.5","45","50"] | ["2.2516","4.4770","1.5309"] | [] | ["XBOX"] | 37.5000 | 50.0000 | 1 | 29 | false | false | true | true | false | mlft | |||||||
| 01a0b0af-a9fb-7cf0-8f50-db0f9041e9c5 | WHR | 2026-09-17 14:44 | put_ladder | 3 | 1 | 1910 | 2534800.00 | unknown | — | 32.9500 | 1.9000 | ["37.5","40","42.5"] | ["2.4147","4.0577","3.8046"] | [] | ["XBOX"] | 37.5000 | 42.5000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0c969-593f-7261-953e-f1fc6f11d96e | WHR | 2026-09-22 09:58 | call_calendar | 2 | 2 | 38 | 115710.00 | unknown | ask | 33.4100 | 3.3000 | ["17.5"] | ["0.6392"] | [] | ["XISX"] | 17.5000 | 17.5000 | 815 | 850 | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:01:35Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:06:27Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:10:23Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:59:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:08:44Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:43:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:22:03Z"} |
| 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-16T14:34:12Z"} |
| 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-16T14:36:16Z"} |
| 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-16T14:49:14Z"} |
| 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-16T14:49:59Z"} |
| 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-16T14:50:44Z"} |
| 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-16T14:59:25Z"} |
| 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-17T15:38:55Z"} |
| 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:03:35Z"} |
| 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:03:35Z"} |
| 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:30:18Z"} |
| 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:41:00Z"} |
| 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:44:56Z"} |
| 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-22T13:58:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |