core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a06dfc-12c5-7783-b0b7-57adceeb6a2c | SPX | 2026-09-04 15:53 | put_diagonal_spread_bearish | 2 | 1 | 22 | 215094.00 | long | ask | 7717.5900 | 0.7000 | ["7675","7680"] | ["0.1159","0.1127"] | [] | ["XCBO"] | 7675.0000 | 7680.0000 | 14 | 17 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:07Z"} | 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 | true | ||||||||||
| 01a06df4-b025-7643-a35e-493c62c40b00 | SPX | 2026-09-04 15:45 | put_diagonal_spread_bearish | 2 | 1 | 6 | 116658.00 | long | ask | 7715.3900 | 0.8000 | ["7715","7725"] | ["0.1144","0.1253"] | [] | ["XCBO"] | 7715.0000 | 7725.0000 | 21 | 42 | false | false | true | ||||||||||
| 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 | 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 | true | ||||||||||
| 01a06def-8bbd-7933-94ab-cc5b8d730d65 | SPX | 2026-09-04 15:40 | put_diagonal_spread_bearish | 2 | 1 | 26 | 399906.00 | long | ask | 7712.9300 | 0.8000 | ["7675","7700"] | ["0.1162","0.1189"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a06def-4d3d-7df0-95e8-e40736c4dd4f | SPX | 2026-09-04 15:39 | put_diagonal_spread_bearish | 2 | 1 | 31 | 476346.00 | long | ask | 7713.3000 | 0.9000 | ["7675","7700"] | ["0.1163","0.1190"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a06def-4955-7e82-8d9a-d953b1b0f626 | SPX | 2026-09-04 15:39 | put_diagonal_spread_bearish | 2 | 1 | 30 | 461160.00 | long | ask | 7713.1900 | 0.8000 | ["7675","7700"] | ["0.1163","0.1190"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a06dee-d425-7d22-b0b7-7e539da87bb6 | SPX | 2026-09-04 15:39 | put_diagonal_spread_bearish | 2 | 1 | 31 | 477028.00 | long | ask | 7713.1000 | 0.9000 | ["7675","7700"] | ["0.1164","0.1190"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a06ded-b6fd-7c62-932e-a03982478ba8 | SPX | 2026-09-04 15:38 | put_diagonal_spread_bearish | 2 | 1 | 32 | 492384.00 | long | ask | 7713.2100 | 0.9000 | ["7675","7700"] | ["0.1165","0.1190"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a06ded-0b1d-7fb2-b774-d7e14ebb31b1 | SPX | 2026-09-04 15:37 | put_diagonal_spread_bearish | 2 | 1 | 30 | 459660.00 | long | ask | 7713.8100 | 0.8000 | ["7675","7700"] | ["0.1164","0.1189"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a06dec-4f9d-7cb0-8bc1-87a9fbccc1be | SPX | 2026-09-04 15:36 | put_diagonal_spread_bearish | 2 | 1 | 28 | 425992.00 | long | ask | 7715.2700 | 1.0000 | ["7675","7700"] | ["0.1165","0.1190"] | [] | ["XCBO"] | 7675.0000 | 7700.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a06dd8-b7fd-7c80-a097-bd03107c3a12 | SPX | 2026-09-04 15:15 | put_diagonal_spread_bearish | 2 | 1 | 3 | 172719.00 | long | ask | 7711.8600 | 2.0000 | ["7845","8025"] | ["0.1150","0.1434"] | [] | ["XCBO"] | 7845.0000 | 8025.0000 | 42 | 196 | false | 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 | 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 | 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 | true | ||||||||||
| 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 | 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 | 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 | 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 | 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 | 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 | 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:46:04Z"} |
| 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 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:40:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:40:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:40:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:39:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:38:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:37:46Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:36:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:15:16Z"} |
| 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-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: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-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: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 |