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 | 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 |
|---|
| 01a08267-e698-7080-8648-657d7452bf2e | HWM | 2026-09-08 15:04 | risk_reversal | 2 | 1 | 250 | 152500.00 | long | ask | 236.9283 | 0.9000 | ["235","240"] | ["0.4582","0.5160"] | ["240.12"] | ["XPHO"] | 235.0000 | 240.0000 | 3 | 3 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:04:06Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08c9d-55a8-7260-b6fc-a1e30495cb5e | HWM | 2026-09-10 14:38 | other | 7 | 1 | 545 | 4065052.00 | unknown | — | 228.7650 | 23.7000 | ["245","250","252.5","255","270","280","290"] | ["1.2880","1.8294","1.9545","1.8316","0.8659","1.0938","0.6435"] | [] | ["XBOX"] | 245.0000 | 290.0000 | 1 | 36 | false | false | true | true | false | ||||||||
| 01a0b0ad-cd6b-7bc0-bf59-d161abe2cf35 | HWM | 2026-09-17 14:42 | other | 6 | 1 | 96 | 895400.00 | unknown | — | 226.0900 | 18.4000 | ["250","255","260","265","267.5","280"] | ["1.9612","2.2011","2.1975","2.6456","2.7506","0.4322"] | [] | ["XBOX"] | 250.0000 | 280.0000 | 1 | 29 | true | false | true | true | false | mlft | |||||||
| 01a0b0be-8e7b-7992-8062-25f2c8e914e0 | HWM | 2026-09-17 15:01 | other | 4 | 1 | 48 | 456320.00 | unknown | — | 225.8250 | 12.4000 | ["245","250","260","280"] | ["1.6709","1.8878","2.0965","0.6425"] | [] | ["XBOX"] | 245.0000 | 280.0000 | 1 | 29 | false | false | true | true | false | mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:38:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:43:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:01:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |