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 | directiontext | net_side |
|---|
| 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 |
|---|
| 01a06dc3-6add-73c2-86fe-ae83b15234f2 | PFE | 2026-09-04 14:51 | other | 2 | 1 | 3000 | 102000.00 | unknown | — | 28.5150 | 0.0500 | ["28.5"] | ["0.2125"] | [] | ["XCBO"] | 28.5000 | 28.5000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:52:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a081ac-2819-7a23-94cb-572eb92af0c5 | PFE | 2026-09-08 11:38 | put_vertical_spread | 2 | 1 | 1000 | 154000.00 | unknown | — | 27.9050 | 0.0300 | ["25","27"] | ["0.2858","0.2795"] | [] | ["XCBO"] | 25.0000 | 27.0000 | 101 | 101 | false | true | false | true | false | mlat | |||||||
| 01a0a5bf-f296-7dc1-a15b-5cd1fa0338da | PFE | 2026-09-15 11:46 | call_diagonal_spread | 2 | 1 | 4420 | 221006.00 | short | bid | 27.5050 | 0.1500 | ["30","37"] | ["0.4731","0.2274"] | [] | ["XCBO"] | 30.0000 | 37.0000 | 3 | 367 | false | true | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:38:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:47:29Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |