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 | 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 |
|---|
| 01a06dca-f48e-77e1-ae1a-18cd3ba0ba25 | ORCL | 2026-09-04 15:00 | put_diagonal_spread_bearish | 2 | 3 | 15 | 35902.00 | short | bid | 157.2600 | 0.5220 | ["160","175"] | ["0.9414","1.0906"] | [] | ["XPHO"] | 160.0000 | 175.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:00:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d61-da4d-7983-9655-f5f227ea47af | ORCL | 2026-09-04 13:05 | put_diagonal_spread_bearish | 2 | 1 | 5 | 26565.00 | short | bid | 157.4400 | 1.4500 | ["155","170"] | ["0.5998","0.6065"] | [] | ["AMXO"] | 155.0000 | 170.0000 | 133 | 196 | false | false | true | ||||||||||
| 01a06d5f-ee1d-73f1-8490-463fe2a67637 | ORCL | 2026-09-04 13:03 | put_diagonal_spread_bearish | 2 | 1 | 5 | 26505.00 | short | bid | 157.3650 | 1.7000 | ["155","170"] | ["0.5976","0.6042"] | [] | ["ARCO"] | 155.0000 | 170.0000 | 133 | 196 | false | false | true | ||||||||||
| 01a06d5f-ee1d-73f1-8490-4628b13baedf | ORCL | 2026-09-04 13:03 | put_diagonal_spread_bearish | 2 | 1 | 5 | 25120.00 | short | bid | 157.3650 | 2.0000 | ["150","170"] | ["0.5939","0.6027"] | [] | ["ARCO"] | 150.0000 | 170.0000 | 133 | 196 | false | false | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:05:54Z"} |
| 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:03:31Z"} |
| 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:03:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |