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 |
|---|
| 01a0c596-b9e6-7a61-bcc5-3e462411386e | SMH | 2026-09-21 16:09 | call_diagonal_spread | 2 | 1 | 31 | 98270.00 | long | bid | 596.0000 | 4.9500 | ["580","585"] | ["0.3867","0.3384"] | [] | ["XISX"] | 580.0000 | 585.0000 | 1 | 4 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T20:11:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c550-2396-7162-8720-30f83c646050 | SMH | 2026-09-21 14:52 | call_diagonal_spread | 2 | 1 | 24 | 72000.00 | unknown | ask | 595.4050 | 0.9500 | ["595","600"] | ["0.3334","0.3282"] | [] | ["XCBO"] | 595.0000 | 600.0000 | 11 | 18 | false | false | true | ||||||||||
| 01a0b4e0-d430-7482-9217-060df3c7b56e | SMH | 2026-09-18 10:17 | call_diagonal_spread | 2 | 2 | 30 | 97800.00 | long | ask | 565.4300 | 2.1500 | ["550","552.5"] | ["0.4471","0.2874"] | [] | ["XCBO"] | 550.0000 | 552.5000 | 0 | 7 | false | false | true | ||||||||||
| 01a0a55f-0de6-7bd2-8e3c-b31da556deac | SMH | 2026-09-15 10:01 | call_diagonal_spread | 2 | 1 | 6 | 69780.00 | short | bid | 547.2650 | 2.8000 | ["490","495"] | ["0.6044","0.3614"] | [] | ["XCBO"] | 490.0000 | 495.0000 | 3 | 31 | false | false | true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:53:02Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:17:17Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:01:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |