core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_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 |
|---|
| 01a0ca65-e597-7d53-8729-8ada97472bf0 | XLE | 2026-09-22 14:34 | call_diagonal_spread | 2 | 1 | 200 | 160200.00 | short | bid | 62.2200 | 0.4500 | ["59","60"] | ["0.2977","0.2546"] | [] | ["SPHR"] | 59.0000 | 60.0000 | 24 | 59 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:34:36Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a090f2-ec58-7331-b458-f301fecb700e | XLE | 2026-09-11 10:50 | call_diagonal_spread | 2 | 1 | 200 | 300000.00 | short | ask | 64.8197 | 1.0000 | ["55","65"] | ["0.6783","0.2294"] | [] | ["SPHR"] | 55.0000 | 65.0000 | 7 | 201 | false | false | true | ||||||||||
| 01a086e1-35d0-78e2-a1ee-98097dfbf186 | XLE | 2026-09-09 11:54 | call_diagonal_spread | 2 | 1 | 88 | 85800.00 | short | ask | 65.2397 | 0.3500 | ["60","65"] | ["0.2720","0.2388"] | [] | ["SPHR"] | 60.0000 | 65.0000 | 21 | 128 | false | false | true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:50:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:55:31Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |