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_side |
|---|
| 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 |
|---|
| 01a081f6-73a0-7450-91de-bd19690cc6d0 | XSP | 2026-09-08 13:00 | put_vertical_spread | 2 | 1 | 40 | 34860.00 | short | bid | 768.4500 | 2.3500 | ["710","730"] | ["0.2150","0.2095"] | ["725.45"] | ["XCBO"] | 710.0000 | 730.0000 | 829 | 829 | true | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:00:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e5-8f68-7173-9fb5-ec1e727ffeb3 | XSP | 2026-09-08 12:41 | other | 4 | 1 | 257 | 45000.70 | unknown | — | 768.4700 | 0.2500 | ["721","724","759","760"] | ["0.1900","0.1854","0.1372","0.1361"] | [] | ["XCBO"] | 721.0000 | 760.0000 | 24 | 31 | true | true | true | true | false | mlet | |||||||
| 01a06e03-fa35-7bd3-bbf2-da18fbd0ed91 | XSP | 2026-09-04 16:02 | call_vertical_spread | 2 | 1 | 94 | 39066.40 | long | ask | 771.8400 | 0.7900 | ["750","752"] | ["0.1267","0.1201"] | ["751.98"] | ["XCBO"] | 750.0000 | 752.0000 | 5 | 5 | false | false | false | true | false | ||||||||
| 01a06dea-ffad-7de0-b13f-7cab80873516 | XSP | 2026-09-04 15:35 | other | 4 | 1 | 26 | 32312.80 | unknown | — | 771.5000 | 2.5900 | ["738","743"] | ["2.0107","1.3694"] | [] | ["XCBO"] | 738.0000 | 743.0000 | 0 | 4 | false | false | true | true | false | mlet | |||||||
| 01a06de5-4abd-7c10-8de3-949bf84a31af | XSP | 2026-09-04 15:28 | other | 4 | 1 | 26 | 30248.40 | unknown | — | 771.5900 | 2.2000 | ["740","745"] | ["1.6377","1.4017"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 4 | false | false | true | true | false | mlet | |||||||
| 01a06de4-8b55-7e32-8d65-2969d23e48d2 | XSP | 2026-09-04 15:28 | other | 4 | 1 | 31 | 31595.20 | unknown | — | 771.5200 | 2.3600 | ["741","751"] | ["1.1787","1.1125"] | [] | ["XCBO"] | 741.0000 | 751.0000 | 0 | 4 | false | false | true | true | false | mlet | |||||||
| 01a06dc1-5f6e-7df2-9beb-1fcfa46801c4 | XSP | 2026-09-04 14:49 | call_diagonal_spread_bearish | 2 | 1 | 4 | 46242.40 | long | ask | 771.7600 | 27.9700 | ["195","200"] | ["1.5518","0.4452"] | [] | ["XCBO"] | 195.0000 | 200.0000 | 133 | 833 | false | false | true | true | |||||||||
| 01a06dbf-251d-7ce1-b89d-265e4fe140f2 | XSP | 2026-09-04 14:47 | call_diagonal_spread_bearish | 2 | 1 | 4 | 46238.40 | long | ask | 771.7200 | 29.5800 | ["195","200"] | ["1.5514","0.4451"] | [] | ["XCBO"] | 195.0000 | 200.0000 | 133 | 833 | false | false | true | true | |||||||||
| 01a06d84-d36d-7c20-8078-daf4079e8aa5 | XSP | 2026-09-04 13:43 | put_vertical_spread | 2 | 1 | 151 | 34730.00 | long | ask | 771.0500 | 0.4500 | ["700","790"] | ["0.2058","0.1147"] | ["770.36"] | ["XCBO"] | 700.0000 | 790.0000 | 42 | 42 | false | false | false | true | false | ||||||||
| 01a06d84-d36d-7c20-8078-dae8c3310048 | XSP | 2026-09-04 13:43 | put_vertical_spread | 2 | 1 | 153 | 35174.70 | unknown | — | 771.0500 | 0.4500 | ["700","790"] | ["0.2058","0.1146"] | [] | ["XCBO"] | 700.0000 | 790.0000 | 42 | 42 | false | false | false | true | false | mlet | |||||||
| 01a06d84-d36d-7c20-8078-daddde2c4223 | XSP | 2026-09-04 13:43 | put_vertical_spread | 2 | 1 | 153 | 35174.70 | unknown | — | 771.0500 | 0.4500 | ["700","790"] | ["0.2058","0.1146"] | [] | ["XCBO"] | 700.0000 | 790.0000 | 42 | 42 | false | false | false | true | false | mlet | |||||||
| 01a06d84-d36d-7c20-8078-dac1dac432f0 | XSP | 2026-09-04 13:43 | put_vertical_spread | 2 | 1 | 153 | 35174.70 | unknown | — | 771.0500 | 0.4500 | ["700","790"] | ["0.2058","0.1146"] | [] | ["XCBO"] | 700.0000 | 790.0000 | 42 | 42 | false | false | false | true | false | mlet | |||||||
| 01a06d84-d36d-7c20-8078-dabd86c78b31 | XSP | 2026-09-04 13:43 | put_vertical_spread | 2 | 1 | 153 | 35159.40 | unknown | — | 771.0500 | 0.4500 | ["700","790"] | ["0.2058","0.1145"] | [] | ["XCBO"] | 700.0000 | 790.0000 | 42 | 42 | false | false | false | true | false | mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:41:46Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T20:02:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:35:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:29:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:28:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:49:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:47:35Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |