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 |
|---|
| 01a06de3-df76-7191-ac8a-3afc311eb7a3 | ORCL | 2026-09-04 15:27 | call_diagonal_spread_bullish | 2 | 1 | 5 | 33005.00 | long | ask | 156.9100 | 1.5500 | ["100","160"] | ["0.5909","1.0407"] | [] | ["XCBO"] | 100.0000 | 160.0000 | 7 | 77 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:27:33Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de2-6c5d-7562-b28f-706b51f8b6bc | ORCL | 2026-09-04 15:25 | call_diagonal_spread_bullish | 2 | 1 | 45 | 157950.00 | short | bid | 156.8800 | 0.4000 | ["150","170"] | ["0.5875","0.6448"] | [] | ["XCBO"] | 150.0000 | 170.0000 | 42 | 133 | false | false | true | ||||||||||
| 01a06de1-e3a5-70c2-85ce-c0c4a39141a4 | ORCL | 2026-09-04 15:25 | call_diagonal_spread_bullish | 2 | 1 | 50 | 175000.00 | short | bid | 156.8000 | 0.5000 | ["150","170"] | ["0.5875","0.6439"] | [] | ["XMIO"] | 150.0000 | 170.0000 | 42 | 133 | false | false | true | ||||||||||
| 01a06de1-5aed-7391-9a95-106e9c624178 | ORCL | 2026-09-04 15:24 | call_diagonal_spread_bullish | 2 | 1 | 18 | 63000.00 | short | bid | 156.8251 | 0.3000 | ["150","170"] | ["0.5870","0.6434"] | [] | ["XCBO"] | 150.0000 | 170.0000 | 42 | 133 | false | false | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:25:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:25:21Z"} |
| 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-04T19:24:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |