core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0e83b-e5b7-7f41-9fa3-536311a94824 | CCJ | 2026-09-28 09:37 | put_calendar | 2 | 1 | 100 | 137000.00 | short | bid | 85.9900 | 0.4000 | ["90"] | ["0.4496"] | [] | ["XISX"] | 90.0000 | 90.0000 | 18 | 53 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T13:37:24Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0d9fd-b007-7690-9fda-59e8b3f848e1 | CCJ | 2026-09-25 15:14 | straddle | 2 | 3 | 86 | 255850.00 | short | bid | 88.2350 | 0.2919 | ["100"] | ["0.4637"] | ["70.25","129.75"] | ["ARCO","XBOX"] | 100.0000 | 100.0000 | 265 | 265 | false | false | |||||||||||
| 01a0d8f2-faaf-7572-89cf-bae4f2932ced | CCJ | 2026-09-25 10:23 | other | 4 | 1 | 39 | 135954.00 | unknown | bid | 88.2900 | 4.1000 | ["93","95","98","100"] | ["0.4359","0.4373","0.4834","0.5836"] | [] | ["XCBO"] | 93.0000 | 100.0000 | 7 | 14 | false | false | |||||||||||
| 01a0d4d8-ea46-73e3-aa01-c34d9c74347d | CCJ | 2026-09-24 15:16 | other | 5 | 1 | 260 | 704440.00 | unknown | bid | 88.2750 | 8.3000 | ["99","100","102","104","116"] | ["1.5708","1.6721","1.8678","2.2028","1.2708"] | [] | ["XBOX"] | 99.0000 | 116.0000 | 1 | 8 | false | false | |||||||||||
| 01a0d4c4-29c7-7cd3-8c07-8d08f1b9da6e | CCJ | 2026-09-24 14:53 | other | 6 | 1 | 177 | 513384.00 | unknown | bid | 88.6000 | 10.5500 | ["98","99","100","101","102","116"] | ["1.7734","1.5646","1.6407","2.1175","2.2264","1.2451"] | [] | ["XBOX"] | 98.0000 | 116.0000 | 1 | 8 | false | false | |||||||||||
| 01a0d42f-8317-79f0-8fd4-441b9fee6fc4 | CCJ | 2026-09-24 12:11 | put_diagonal_spread | 2 | 2 | 337 | 310714.00 | unknown | bid | 88.8050 | 1.6500 | ["90","93"] | ["0.4276","0.8133"] | [] | ["ARCO"] | 90.0000 | 93.0000 | 1 | 29 | false | false | |||||||||||
| 01a0d415-cd0e-7b93-9250-b3eda2552d3c | CCJ | 2026-09-24 11:43 | call_vertical_spread | 2 | 1 | 50 | 105100.00 | short | bid | 88.6100 | 1.2500 | ["90","95"] | ["0.4626","0.4628"] | ["92"] | ["AMXO"] | 90.0000 | 95.0000 | 176 | 176 | false | true | |||||||||||
| 01a0ca4b-4cfe-7652-8f4d-b98c2108e360 | CCJ | 2026-09-22 14:05 | straddle | 2 | 1 | 500 | 500000.00 | short | bid | 94.8200 | 1.2700 | ["100"] | ["0.4612"] | ["90","110.00"] | ["XBOX"] | 100.0000 | 100.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c955-b9cf-7f03-820a-adfc905cab9d | CCJ | 2026-09-22 09:37 | call_vertical_spread | 2 | 1 | 700 | 338800.00 | unknown | bid | 92.6500 | 1.0400 | ["120","130"] | ["0.4931","0.5013"] | ["124.84"] | ["AMXO"] | 120.0000 | 130.0000 | 115 | 115 | false | true | |||||||||||
| 01a08c12-3478-7561-aeca-4be4188b6f56 | CCJ | 2026-09-10 12:06 | call_vertical_spread | 2 | 1 | 20 | 107880.00 | short | bid | 98.3471 | 3.1000 | ["85","105"] | ["0.5257","0.5134"] | ["93.80"] | ["ARCO"] | 85.0000 | 105.0000 | 498 | 498 | false | false | |||||||||||
| 01a0824d-8898-7fc0-9f92-3b9fb2c86f38 | CCJ | 2026-09-08 14:35 | call_vertical_spread | 2 | 5 | 139 | 131877.00 | short | bid | 103.5800 | 0.5600 | ["115","140"] | ["0.5057","0.5169"] | ["119.75"] | ["BATO","SPHR","XCBO","XMIO","XPHO"] | 115.0000 | 140.0000 | 101 | 101 | false | true | |||||||||||
| 01a0821c-dba8-7bc2-ac9e-6d04c7114a39 | CCJ | 2026-09-08 13:42 | straddle | 2 | 1 | 500 | 712500.00 | short | bid | 103.6050 | 0.5000 | ["110"] | ["0.4897"] | ["95.75","124.25"] | ["AMXO"] | 110.0000 | 110.0000 | 38 | 38 | false | false |
| false |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:14:53Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:23:25Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:16:40Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:54:24Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:11:41Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:43:37Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:37:16Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:06:52Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:35:30Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:42:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |