core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg508,354 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 |
|---|
| 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 | true | 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 |
| 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 | true | true | |||||||||
| 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 | true | true | |||||||||
| 01a0ced5-6516-7b03-85fa-a702dc7c1bcb | CCJ | 2026-09-23 11:14 | other | 2 | 1 | 700 | 171500.00 | unknown | ask | 92.7000 | 0.6500 | ["85","120"] | ["0.4462","0.5282"] | [] | ["SPHR"] | 85.0000 | 120.0000 | 23 | 58 | false | true | true | true | true | ||||||||
| 01a0aaac-8e42-7732-bfdd-4b7896a768c0 | CCJ | 2026-09-16 10:43 | other | 4 | 1 | 60 | 147660.00 | unknown | — | 91.9800 | 1.7000 | ["95","100"] | ["0.5297","0.5699"] | [] | ["XCBO"] | 95.0000 | 100.0000 | 2 | 9 | false | false | true | true | false | mlat | |||||||
| 01a06d7d-93f5-7ed2-b9d4-0928fb93a64b | CCJ | 2026-09-04 13:35 | other | 2 | 2 | 159 | 174955.00 | unknown | — | 100.4600 | 0.8802 | ["94","97"] | ["2.6156","0.4091"] | [] | ["C2OX","EDGO"] | 94.0000 | 97.0000 | 0 | 7 | false | false | true | true | false | mesl | |||||||
| 01a06d7d-900d-7250-9f36-80051fc34d57 | CCJ | 2026-09-04 13:35 | other | 2 | 4 | 249 | 254476.00 | unknown | — | 100.4300 | 1.5323 | ["94","97"] | ["3.7860","0.3165"] | [] | ["C2OX","SPHR","XBOX","XCBO"] | 94.0000 | 97.0000 | 0 | 7 | false | false | true | true | false | mlet | |||||||
| 01a06d48-dbdd-7202-9aaf-30523696864a | CCJ | 2026-09-04 12:38 | other | 2 | 1 | 1000 | 387000.00 | unknown | — | 100.8300 | 0.3000 | ["110"] | ["0.4513"] | [] | ["XPHO"] | 110.0000 | 110.0000 | 14 | 42 | false | true | true | false | false | mlat | |||||||
| 01a06d47-f94d-72c0-a286-9eeda22b2347 | CCJ | 2026-09-04 12:37 | other | 2 | 1 | 2000 | 774000.00 | unknown | — | 100.7900 | 0.3100 | ["110"] | ["0.4525"] | [] | ["XPHO"] | 110.0000 | 110.0000 | 14 | 42 | false | true | true | false | false | mlat | |||||||
| 01a06d32-a075-7f70-9495-0f5f1ad00f13 | CCJ | 2026-09-04 12:13 | other | 4 | 5 | 267 | 105478.00 | unknown | — | 100.7700 | 2.2935 | ["105","110"] | ["1.5250","0.4541"] | [] | ["BATO","C2OX","EDGO","MCRY","XBOX"] | 105.0000 | 110.0000 | 0 | 42 | false | false | true | true | true | mlet |
| 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 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:15:03Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:44:27Z"} |
| 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-04T17:36:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:36:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:38:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:37:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:13:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |