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 |
|---|
| 01a0c4e5-7ae7-71f1-a065-4696ae2df3e4 | XOM | 2026-09-21 12:56 | call_vertical_spread | 2 | 1 | 10 | 37450.00 | unknown | ask | 158.4250 | 0.9000 | ["140","145"] | ["0.3093","0.2989"] | ["161.22"] | ["XISX"] | 140.0000 | 145.0000 | 60 | 60 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:56:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4e5-7317-7442-9cef-8946c26fdcb0 | XOM | 2026-09-21 12:56 | call_vertical_spread | 2 | 1 | 12 | 35580.00 | unknown | ask | 158.4250 | 0.7000 | ["145","150"] | ["0.3016","0.2932"] | ["162.32"] | ["XPHO"] | 145.0000 | 150.0000 | 60 | 60 | false | false | false | ||||||||||
| 01a0814c-3980-75c1-82a0-7d5b5c2aa570 | XOM | 2026-09-08 09:54 | call_vertical_spread | 2 | 1 | 99 | 81180.00 | short | bid | 160.7300 | 0.5400 | ["160","175"] | ["0.2858","0.2850"] | ["165"] | ["C2OX"] | 160.0000 | 175.0000 | 38 | 38 | false | false | false |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:56:07Z"} |
| 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-08T13:54:31Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |