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 | 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 |
|---|
| 01a0c969-d256-7e41-a245-0156dc9fbb2f | BX | 2026-09-22 09:59 | put_calendar | 2 | 1 | 55 | 152735.00 | short | bid | 125.3900 | 3.9500 | ["139"] | ["0.4384"] | [] | ["XCBO"] | 139.0000 | 139.0000 | 10 | 38 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:59:10Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b07a-a3c3-7182-b252-c1fd7dbe9216 | BX | 2026-09-17 13:47 | other | 3 | 1 | 50 | 193600.00 | unknown | — | 125.8650 | 1.1500 | ["125"] | ["0.4012"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 92 | 456 | false | false | true | false | true | ||||||||
| 01a08bf4-5fc0-7b51-a382-ba47107e1baf | BX | 2026-09-10 11:34 | call_calendar | 2 | 1 | 95 | 166535.00 | short | bid | 127.2700 | 1.9000 | ["150"] | ["0.3514"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 127 | 463 | false | true | true | ||||||||||
| 01a08765-9871-7421-bf2a-597b694922c5 | BX | 2026-09-09 14:19 | put_vertical_spread | 2 | 1 | 270 | 273510.00 | long | ask | 129.2750 | 0.5500 | ["125","130"] | ["0.3742","0.3704"] | ["127.75"] | ["XCBO"] | 125.0000 | 130.0000 | 37 | 37 | false | false | |||||||||||
| 01a08296-da21-7552-8ad9-ec1ee72072d2 | BX | 2026-09-08 15:55 | put_diagonal_spread | 2 | 1 | 285 | 119415.00 | short | ask | 134.1300 | 0.5000 | ["130","135"] | ["0.3935","0.4191"] | [] | ["XCBO"] | 130.0000 | 135.0000 | 3 | 10 | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:47:23Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:34:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:20:05Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:55:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |