core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|
| 01a0c475-82d7-7fc3-8903-bc128b118781 | MXL | 2026-09-21 10:53 | call_diagonal_spread | 2 | 1 | 150 | 232500.00 | short | ask | 87.0700 | 1.8000 | ["90","125"] | ["0.9919","1.0444"] | [] | ["SPHR"] | 90.0000 | 125.0000 | 25 | 88 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:54:01Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a091a5-c968-7b22-8f95-4dac78186927 | MXL | 2026-09-11 14:05 | other | 2 | 1 | 150 | 110550.00 | unknown | — | 75.2400 | 0.9000 | ["75","90"] | ["0.8731","0.8924"] | [] | ["XPHO"] | 75.0000 | 90.0000 | 7 | 35 | false | false | true | true | false | mlet | |||||||
| 01a08bd9-f608-7fd2-92a5-08b7c5c3ee3b | MXL | 2026-09-10 11:05 | call_vertical_spread | 2 | 1 | 15 | 106500.00 | short | bid | 67.9600 | 7.0000 | ["70","105"] | ["1.0052","1.0124"] | ["76"] | ["EMLD"] | 70.0000 | 105.0000 | 827 | 827 | false | true | false | true | false | ||||||||
| 01a08b8c-9d40-75b3-aeb2-f9afb4e1511b | MXL | 2026-09-10 09:40 | call_vertical_spread | 2 | 1 | 15 | 106650.00 | unknown | — | 68.8800 | 5.6000 | ["70","105"] | ["0.9959","0.9845"] | [] | ["XISX"] | 70.0000 | 105.0000 | 827 | 827 | false | true | false | true | false | mlet |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:05:59Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:05:15Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:40:52Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |