core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg508,354 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 |
|---|
| 01a06da9-726d-75f2-afa7-1739bb93942d | SPCX | 2026-09-04 14:23 | call_diagonal_spread_bearish | 2 | 1 | 8 | 33384.00 | short | bid | 148.6750 | 1.4500 | ["128","129"] | ["6.2751","0.4977"] | [] | ["XMIO"] | 128.0000 | 129.0000 | 0 | 21 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:24:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8d-33f5-7301-8e65-bd601a8c4a48 | SPCX | 2026-09-04 13:52 | call_diagonal_spread_bearish | 2 | 1 | 10 | 49730.00 | long | bid | 148.3800 | 0.6500 | ["130","140"] | ["0.5499","0.5342"] | [] | ["AMXO"] | 130.0000 | 140.0000 | 77 | 133 | false | false | true | ||||||||||
| 01a06d88-751d-7eb1-b530-41cbe8e82572 | SPCX | 2026-09-04 13:47 | call_diagonal_spread_bearish | 2 | 1 | 30 | 32190.00 | long | bid | 148.4300 | 0.2000 | ["145","150"] | ["0.4628","0.4808"] | [] | ["XISX"] | 145.0000 | 150.0000 | 7 | 14 | false | false | true | ||||||||||
| 01a06d5b-cf6d-74a0-bf7b-b8c760a92302 | SPCX | 2026-09-04 12:58 | call_diagonal_spread_bearish | 2 | 1 | 99 | 26235.00 | short | bid | 148.9201 | 0.0300 | ["150","152.5"] | ["0.5777","0.4688"] | [] | ["XPHO"] | 150.0000 | 152.5000 | 0 | 7 | false | true | true |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:53:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:47:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:59:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |