core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 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 |
|---|
| 01a06e09-e5d5-7e00-8c3f-76defbab5f34 | SPX | 2026-09-04 16:08 | put_diagonal_spread_bearish | 2 | 1 | 15 | 26700.00 | short | bid | 7718.6000 | 0.5000 | ["7125","7200"] | ["0.2178","0.1878"] | [] | ["XCBO"] | 7125.0000 | 7200.0000 | 14 | 28 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:11:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfa-8c25-7a73-ab51-304392e27560 | SPX | 2026-09-04 15:52 | put_diagonal_spread_bearish | 2 | 1 | 5 | 74405.00 | long | ask | 7718.7800 | 3.4000 | ["7790","7795"] | ["1.3778","0.0781"] | [] | ["XCBO"] | 7790.0000 | 7795.0000 | 0 | 4 | false | false | |||||||||||
| 01a06df3-e11d-7d42-bbee-05050db2a57e | SPX | 2026-09-04 15:44 | put_diagonal_spread_bearish | 2 | 1 | 2 | 38936.00 | long | ask | 7715.0200 | 0.9000 | ["7715","7725"] | ["0.1145","0.1252"] | [] | ["XCBO"] | 7715.0000 | 7725.0000 | 21 | 42 | false | false | |||||||||||
| 01a06df3-6bed-7970-8711-4396d2dcfa98 | SPX | 2026-09-04 15:44 | put_diagonal_spread_bearish | 2 | 1 | 2 | 33228.00 | short | bid | 7714.8200 | 0.7000 | ["7745","7750"] | ["0.1078","0.1108"] | [] | ["XCBO"] | 7745.0000 | 7750.0000 | 14 | 21 | false | false | |||||||||||
| 01a06df2-75d5-79e0-9ae8-ff2f88f96f01 | SPX | 2026-09-04 15:43 | put_diagonal_spread_bearish | 2 | 1 | 7 | 61229.00 | short | bid | 7714.0200 | 0.6000 | ["7675","7700"] | ["0.0948","0.1090"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 10 | 17 | false | true | |||||||||||
| 01a06df0-33b5-7530-8ceb-db583b6c9ff3 | SPX | 2026-09-04 15:40 | put_diagonal_spread_bearish | 2 | 1 | 2 | 35096.00 | long | ask | 7713.6800 | 0.7000 | ["7640","7740"] | ["0.1220","0.1229"] | [] | ["XCBO"] | 7640.0000 | 7740.0000 | 21 | 42 | false | false | |||||||||||
| 01a06de5-3b1e-7c33-9218-5bbcf2a7d54f | SPX | 2026-09-04 15:28 | put_diagonal_spread_bearish | 2 | 1 | 3 | 46197.00 | short | bid | 7716.0500 | 0.7000 | ["7675","7700"] | ["0.1150","0.1265"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 14 | 42 | false | true | |||||||||||
| 01a06dd1-16dd-78f3-a3c8-b501efb0856e | SPX | 2026-09-04 15:06 | put_diagonal_spread_bearish | 2 | 1 | 27 | 84861.00 | short | bid | 7712.3500 | 0.9000 | ["6500","6850"] | ["0.2738","0.2192"] | [] | ["XCBO"] | 6500.0000 | 6850.0000 | 42 | 61 | false | true | |||||||||||
| 01a06dce-e845-7d82-8ca4-5b6bee857442 | SPX | 2026-09-04 15:04 | put_diagonal_spread_bearish | 2 | 1 | 3 | 36126.00 | short | bid | 7713.5500 | 1.1000 | ["7500","7700"] | ["0.1364","0.1243"] | [] | ["XCBO"] | 7500.0000 | 7700.0000 | 14 | 42 | false | true | |||||||||||
| 01a06dce-53d5-7c23-9e02-b420cb2a7018 | SPX | 2026-09-04 15:03 | put_diagonal_spread_bearish | 2 | 1 | 3 | 35931.00 | short | bid | 7713.9800 | 1.0000 | ["7500","7700"] | ["0.1358","0.1241"] | [] | ["XCBO"] | 7500.0000 | 7700.0000 | 14 | 42 | false | true | |||||||||||
| 01a06dcd-dabd-7682-a145-0ba8e9c2f6cb | SPX | 2026-09-04 15:03 | put_diagonal_spread_bearish | 2 | 1 | 3 | 35715.00 | short | bid | 7715.6300 | 1.2000 | ["7500","7700"] | ["0.1361","0.1242"] | [] | ["XCBO"] | 7500.0000 | 7700.0000 | 14 | 42 | false | true | |||||||||||
| 01a06dcd-a40d-7843-82e0-6952cdcba421 | SPX | 2026-09-04 15:03 | put_diagonal_spread_bearish | 2 | 2 | 25 | 46725.00 | long | ask | 7715.7000 | 0.2500 | ["7705","7715"] | ["0.1299","0.0614"] | [] | ["XCBO"] | 7705.0000 | 7715.0000 | 0 | 4 | false | true | |||||||||||
| 01a06dcb-989d-7de3-a9cf-2a440d56f887 | SPX | 2026-09-04 15:00 | put_diagonal_spread_bearish | 2 | 1 | 2 | 29748.00 | long | ask | 7716.8700 | 0.8000 | ["7720","7730"] | ["0.1040","0.1158"] | [] | ["XCBO"] | 7720.0000 | 7730.0000 | 12 | 28 | false | false | |||||||||||
| 01a06dc3-66f5-7a21-b72b-fc655ec6e2c1 | SPX | 2026-09-04 14:51 | put_diagonal_spread_bearish | 2 | 1 | 30 | 92010.00 | short | bid | 7717.2000 | 0.8000 | ["6500","6850"] | ["0.2731","0.2188"] | [] | ["XCBO"] | 6500.0000 | 6850.0000 | 42 | 61 | false | true | |||||||||||
| 01a06dab-3f5d-7d53-8225-91b9be1c5fe4 | SPX | 2026-09-04 14:25 | put_diagonal_spread_bearish | 2 | 1 | 2 | 34202.00 | long | ask | 7714.7200 | 1.1000 | ["7000","7200"] | ["0.2002","0.1822"] | [] | ["XCBO"] | 7000.0000 | 7200.0000 | 77 | 168 | false | true | |||||||||||
| 01a06da2-179d-7b20-b404-03b5fc4720c1 | SPX | 2026-09-04 14:15 | put_diagonal_spread_bearish | 2 | 1 | 19 | 45125.00 | short | bid | 7712.0000 | 0.6000 | ["6000","6450"] | ["0.3418","0.2568"] | [] | ["XCBO"] | 6000.0000 | 6450.0000 | 42 | 77 | false | true | |||||||||||
| 01a06da0-e305-7de3-b381-64118b9e4edb | SPX | 2026-09-04 14:14 | put_diagonal_spread_bearish | 2 | 1 | 23 | 53521.00 | short | bid | 7712.6000 | 0.3000 | ["7710","7715"] | ["0.1093","0.0625"] | [] | ["XCBO"] | 7710.0000 | 7715.0000 | 0 | 4 | false | false | |||||||||||
| 01a06d89-309d-7cc3-bbe6-bc17efa47e75 | SPX | 2026-09-04 13:48 | put_diagonal_spread_bearish | 2 | 1 | 2 | 41046.00 | long | ask | 7709.5700 | 1.2000 | ["6200","7625"] | ["0.2839","0.1507"] | [] | ["XCBO"] | 6200.0000 | 7625.0000 | 77 | 133 | false | true | |||||||||||
| 01a06d82-720d-70a0-aeec-0464c34541d9 | SPX | 2026-09-04 13:40 | put_diagonal_spread_bearish | 2 | 1 | 17 | 42483.00 | long | ask | 7711.1200 | 0.2500 | ["7690","7720"] | ["0.1442","0.0651"] | [] | ["XCBO"] | 7690.0000 | 7720.0000 | 0 | 4 | false | false | |||||||||||
| 01a06d56-f155-71d1-8ec0-d6901365e5e9 | SPX | 2026-09-04 12:53 | put_diagonal_spread_bearish | 2 | 1 | 5 | 50990.00 | short | bid | 7728.5300 | 1.4000 | ["7775","7780"] | ["0.2073","0.0714"] | [] | ["XCBO"] | 7775.0000 | 7780.0000 | 0 | 4 | false | false | |||||||||||
| 01a06d3a-baad-70b1-a8c7-c7e3c99c1779 | SPX | 2026-09-04 12:22 | put_diagonal_spread_bearish | 2 | 1 | 2 | 25664.00 | short | bid | 7725.2800 | 0.9000 | ["7720","7725"] | ["0.0952","0.1150"] | [] | ["XCBO"] | 7720.0000 | 7725.0000 | 11 | 26 | false | true | |||||||||||
| 01a06d30-75c5-71d0-af3f-7a649a1e6d8e | SPX | 2026-09-04 12:11 | put_diagonal_spread_bearish | 2 | 1 | 3 | 54816.00 | long | ask | 7720.0100 | 1.0000 | ["7690","7710"] | ["0.1217","0.1210"] | [] | ["XCBO"] | 7690.0000 | 7710.0000 | 33 | 35 | false | true | |||||||||||
| 01a06d2f-9335-7a31-abcc-c56d7d570afa | SPX | 2026-09-04 12:10 | put_diagonal_spread_bearish | 2 | 1 | 3 | 48129.00 | long | ask | 7718.5500 | 0.8000 | ["7690","7710"] | ["0.1184","0.1187"] | [] | ["XCBO"] | 7690.0000 | 7710.0000 | 26 | 28 | false | true | |||||||||||
| 01a06d2e-9935-7ca0-9011-0632b5b8146c | SPX | 2026-09-04 12:09 | put_diagonal_spread_bearish | 2 | 1 | 3 | 40026.00 | long | ask | 7719.4800 | 0.8000 | ["7695","7710"] | ["0.1137","0.1148"] | [] | ["XCBO"] | 7695.0000 | 7710.0000 | 19 | 21 | false | true | |||||||||||
| 01a06d29-2a95-77d3-ba39-d225c221d5ca | SPX | 2026-09-04 12:03 | put_diagonal_spread_bearish | 2 | 1 | 7 | 48202.00 | long | ask | 7715.3100 | 0.7000 | ["7620","7625"] | ["0.1224","0.1183"] | [] | ["XCBO"] | 7620.0000 | 7625.0000 | 14 | 17 | false | true | |||||||||||
| 01a06d22-f8a5-7eb1-8832-373acbd2de1e | SPX | 2026-09-04 11:56 | put_diagonal_spread_bearish | 2 | 1 | 2 | 63452.00 | long | ask | 7715.1800 | 1.3000 | ["7600","7650"] | ["0.1449","0.1477"] | [] | ["XCBO"] | 7600.0000 | 7650.0000 | 87 | 118 | false | true |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:52:21Z"} |
| 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-04T19:45:03Z"} |
| 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-04T19:44:39Z"} |
| 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-04T19:43:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:41:10Z"} |
| 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-04T19:29:07Z"} |
| 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-04T19:07:12Z"} |
| 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-04T19:04:45Z"} |
| 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-04T19:04:13Z"} |
| 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-04T19:03:44Z"} |
| 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-04T19:03:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:01:26Z"} |
| 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:52:02Z"} |
| 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:25:55Z"} |
| 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:16:10Z"} |
| 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:14:38Z"} |
| 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-04T17:48:28Z"} |
| 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-04T17:41:43Z"} |
| 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-04T16:53:35Z"} |
| 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-04T16:23:08Z"} |
| 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-04T16:11:37Z"} |
| 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-04T16:10:59Z"} |
| 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-04T16:09:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:03: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-04T15:57:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |