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 | direction |
|---|
| 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 |
|---|
| 01a0879b-61f8-76a0-b988-7c02d500cb28 | XSP | 2026-09-09 15:18 | other | 4 | 1 | 45 | 31923.00 | unknown | — | 764.7100 | 5.1800 | ["750","755","760"] | ["0.2453","0.1286","0.1417"] | [] | ["XCBO"] | 750.0000 | 760.0000 | 1 | 55 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:18:25Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08687-1781-7063-bab6-96451c81c4ce | XSP | 2026-09-09 10:16 | call_vertical_spread | 2 | 2 | 516 | 62023.20 | short | bid | 764.8100 | 0.8300 | ["759","760"] | ["0.1528","0.1502"] | ["759.84"] | ["XCBO"] | 759.0000 | 760.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a08686-8ae0-74c2-aa62-a6987c17a662 | XSP | 2026-09-09 10:15 | call_vertical_spread | 2 | 1 | 278 | 34666.60 | unknown | — | 765.0400 | 0.7700 | ["759","760"] | ["0.1566","0.1534"] | [] | ["XCBO"] | 759.0000 | 760.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a08663-5ef8-75e1-bc98-edac8a04a573 | XSP | 2026-09-09 09:37 | put_vertical_spread | 2 | 1 | 75 | 25432.50 | long | ask | 765.4500 | 1.7400 | ["782","783"] | ["0.5081","0.5938"] | ["782.01"] | ["XCBO"] | 782.0000 | 783.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0829a-1258-7812-b75c-09ebc04dd53b | XSP | 2026-09-08 15:58 | iron_condor | 4 | 1 | 100 | 34600.00 | unknown | — | 766.9800 | 0.6000 | ["757","758","782","783"] | ["0.1429","0.1419","0.1188","0.1182"] | [] | ["XCBO"] | 757.0000 | 783.0000 | 45 | 45 | true | true | false | true | true | ||||||||
| 01a0827d-7df0-77c2-93c8-71b84dd80d6d | XSP | 2026-09-08 15:27 | other | 4 | 1 | 31 | 28027.10 | unknown | — | 768.2900 | 4.2700 | ["741","751"] | ["1.5853","1.0863"] | [] | ["XCBO"] | 741.0000 | 751.0000 | 0 | 1 | false | false | true | true | false | ||||||||
| 01a0827d-1090-7fe3-a6a8-3febc151a70e | XSP | 2026-09-08 15:27 | other | 4 | 1 | 26 | 26816.40 | unknown | — | 768.1300 | 1.9800 | ["740","745"] | ["1.3283","1.0685"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 1 | false | false | true | true | false | ||||||||
| 01a08278-cad0-7d92-8ca9-2bd0583058e3 | XSP | 2026-09-08 15:22 | other | 4 | 1 | 26 | 28867.80 | unknown | — | 768.1400 | 2.3200 | ["738","743"] | ["1.3378","1.2770"] | [] | ["XCBO"] | 738.0000 | 743.0000 | 0 | 1 | false | false | true | true | false | ||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:16:43Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:16:05Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:37:51Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:59:04Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:27:43Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:27:43Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:22:43Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| 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 |
| false |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |
| false |
| 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 |