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 |
|---|
| 01a06de0-5d06-7be3-83d6-2b8012daa209 | AJG | 2026-09-04 15:23 | call_vertical_spread | 2 | 1 | 25 | 272250.00 | unknown | — | 264.1350 | 5.5000 | ["200","220"] | ["0.5202","0.6835"] | [] | ["XPHO"] | 200.0000 | 220.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:23:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4e-a83d-7640-ac0f-41ce496044eb | AJG | 2026-09-04 12:44 | call_calendar | 2 | 1 | 9 | 120834.00 | short | bid | 266.4150 | 4.7000 | ["200"] | ["0.4051"] | [] | ["XMIO"] | 200.0000 | 200.0000 | 42 | 77 | false | false | true | false | false | mlat | |||||||
| 01a06d4e-a455-7bd2-a201-a80286e971f7 | AJG | 2026-09-04 12:44 | call_calendar | 2 | 1 | 15 | 201120.00 | short | bid | 266.4150 | 5.2000 | ["200"] | ["0.4092"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 42 | 77 | false | false | true | false | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:44:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:44:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |