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 |
|---|
| 01a06d57-0cae-70b1-9f8d-85110a7a69c3 | DELL | 2026-09-04 12:53 | put_diagonal_spread_bearish | 2 | 1 | 10 | 46290.00 | long | ask | 525.4001 | 1.2400 | ["440","530"] | ["0.6204","0.6095"] | [] | ["XMIO"] | 440.0000 | 530.0000 | 14 | 42 | false | false | true | true | false | mlat | 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 |
| 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 | true | ||||||||||
| 01a06d50-e28d-74a1-a1e1-938e296d8de7 | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 4 | 23 | 35820.00 | short | bid | 718.9500 | 0.1022 | ["710","718"] | ["0.1689","0.1680"] | [] | ["AMXO","XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d50-e28d-74a1-a1e1-937e4b4e8581 | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 3 | 26 | 40536.00 | short | bid | 718.9500 | 0.1100 | ["710","718"] | ["0.1691","0.1681"] | [] | ["AMXO","XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d50-cb1d-7090-9aa2-dcf614198b2f | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 2 | 46 | 71438.00 | short | bid | 718.9600 | 0.1050 | ["710","718"] | ["0.1686","0.1678"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4e-cb65-7de0-b3bc-c02ee55e60a0 | QQQ | 2026-09-04 12:44 | put_diagonal_spread_bearish | 2 | 1 | 40 | 62240.00 | short | bid | 718.9150 | 0.0900 | ["710","718"] | ["0.1686","0.1677"] | [] | ["XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d45-41fd-77b2-bde3-96962bd0634d | SPY | 2026-09-04 12:34 | put_diagonal_spread_bearish | 2 | 1 | 45 | 33930.00 | long | ask | 770.8200 | 0.0300 | ["715","730"] | ["0.2037","0.1725"] | [] | ["EDGO"] | 715.0000 | 730.0000 | 14 | 77 | false | true | true | ||||||||||
| 01a06d45-22bd-7383-bdd5-403916990cec | META | 2026-09-04 12:33 | put_diagonal_spread_bearish | 2 | 1 | 6 | 29850.00 | long | ask | 612.5842 | 1.7200 | ["600","660"] | ["0.5191","0.3521"] | [] | ["XMIO"] | 600.0000 | 660.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a06d43-8895-76f1-bd3a-6db75a03a5cc | META | 2026-09-04 12:32 | put_diagonal_spread_bearish | 2 | 5 | 40 | 38756.00 | short | bid | 612.8100 | 0.1600 | ["575","600"] | ["1.2199","0.3289"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 575.0000 | 600.0000 | 0 | 14 | false | true | true | ||||||||||
| 01a06d43-8895-76f1-bd3a-6da69fcaa70f | META | 2026-09-04 12:32 | put_diagonal_spread_bearish | 2 | 5 | 44 | 42628.00 | short | bid | 612.8100 | 0.1600 | ["575","600"] | ["1.2165","0.3288"] | [] | ["EMLD","SPHR","XBOX"] | 575.0000 | 600.0000 | 0 | 14 | false | true | true | ||||||||||
| 01a06d43-84ad-7302-900a-be274f142f4b | PLTR | 2026-09-04 12:32 | put_diagonal_spread_bearish | 2 | 3 | 11 | 27963.00 | short | bid | 174.8650 | 0.3909 | ["175","180"] | ["0.4377","0.5454"] | [] | ["ARCO","XBOX","XISX"] | 175.0000 | 180.0000 | 14 | 77 | false | false | true | ||||||||||
| 01a06d41-07f5-7902-bb55-795a53d3ce67 | SPCX | 2026-09-04 12:29 | put_diagonal_spread_bearish | 2 | 1 | 15 | 30015.00 | short | bid | 148.3822 | 0.3000 | ["135","140"] | ["0.5461","0.5406"] | [] | ["XMIO"] | 135.0000 | 140.0000 | 77 | 105 | false | true | true | ||||||||||
| 01a06d3c-a6dd-7550-bf82-e9c39fbe58ef | SPCX | 2026-09-04 12:24 | put_diagonal_spread_bearish | 2 | 1 | 47 | 69889.00 | short | bid | 148.6200 | 0.1600 | ["130","140"] | ["0.5108","0.5424"] | [] | ["XISX"] | 130.0000 | 140.0000 | 42 | 105 | false | true | true | ||||||||||
| 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 | true | ||||||||||
| 01a06d35-d4c5-7720-83e5-d7aa0a1917e8 | SPCX | 2026-09-04 12:17 | put_diagonal_spread_bearish | 2 | 1 | 7 | 45246.00 | long | ask | 148.5600 | 1.4000 | ["140","200"] | ["0.4850","0.5773"] | [] | ["ARCO"] | 140.0000 | 200.0000 | 21 | 286 | 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 | ||||||||||
| 01a06d2f-5c85-7511-a4de-2a3aa9e88e31 | MU | 2026-09-04 12:10 | put_diagonal_spread_bearish | 2 | 1 | 12 | 95082.00 | long | ask | 999.8300 | 5.7500 | ["925","930"] | ["0.6377","0.6269"] | [] | ["XISX"] | 925.0000 | 930.0000 | 28 | 35 | 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-04T16:53: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-04T16:47:14Z"} |
| 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-04T16:47:14Z"} |
| 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-04T16:47:14Z"} |
| 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-04T16:45:11Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:34:11Z"} |
| 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-04T16:34:11Z"} |
| 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-04T16:32:18Z"} |
| 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-04T16:32:18Z"} |
| 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-04T16:32:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:29:55Z"} |
| 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-04T16:25:06Z"} |
| 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-04T16:23:08Z"} |
| 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-04T16:17:45Z"} |
| 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-04T16:11:37Z"} |
| 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-04T16:10:59Z"} |
| 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-04T16:10:26Z"} |
| 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-04T16:09:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |
| 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 |