core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_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 |
|---|
| 01a06d5e-f806-7a51-b0ce-f1cd99478382 | MSFT | 2026-09-04 13:02 | call_diagonal_spread_bearish | 2 | 1 | 85 | 164220.00 | long | ask | 500.3800 | 0.4500 | ["520","555"] | ["0.2425","0.2921"] | [] | ["XMIO"] | 520.0000 | 555.0000 | 42 | 77 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:02:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d59-d39e-7b81-9294-76c05c504d20 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 1 | 19 | 43605.00 | short | ask | 500.7200 | 0.7000 | ["487.5","492.5"] | ["0.7485","0.1762"] | [] | ["EDGO"] | 487.5000 | 492.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d59-cfb6-7920-a332-6fe3cabd4425 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 2 | 46 | 106904.00 | long | bid | 500.7200 | 1.9000 | ["487.5","492.5"] | ["0.8871","0.1870"] | [] | ["C2OX","XCBO"] | 487.5000 | 492.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d59-cfb6-7920-a332-6fdcf1845da3 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 2 | 34 | 78778.00 | long | bid | 500.8598 | 1.9000 | ["487.5","492.5"] | ["0.9805","0.1786"] | [] | ["C2OX","XISX"] | 487.5000 | 492.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d59-cbcd-7c11-8fc9-e2040adeaab1 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 1 | 25 | 58100.00 | long | bid | 500.8598 | 1.9000 | ["487.5","492.5"] | ["0.6956","0.1804"] | [] | ["C2OX"] | 487.5000 | 492.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d59-cbcd-7c11-8fc9-e1fa4f5257c9 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 1 | 12 | 27732.00 | long | bid | 500.8000 | 1.9000 | ["487.5","492.5"] | ["0.6667","0.1796"] | [] | ["XISX"] | 487.5000 | 492.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d52-8485-7582-bd40-cbc1e4e69774 | MSFT | 2026-09-04 12:48 | call_diagonal_spread_bearish | 2 | 1 | 4 | 30780.00 | long | bid | 500.7300 | 1.8000 | ["490","500"] | ["0.2863","0.2834"] | [] | ["XMIO"] | 490.0000 | 500.0000 | 105 | 133 | false | false | true | ||||||||||
| 01a06d46-3fe5-7ab1-84f5-dc2bdbc6b4a6 | MSFT | 2026-09-04 12:35 | call_diagonal_spread_bearish | 2 | 1 | 2 | 36406.00 | short | bid | 501.3300 | 1.8000 | ["420","430"] | ["0.3325","0.3064"] | [] | ["XCBO"] | 420.0000 | 430.0000 | 77 | 196 | false | false | true | ||||||||||
| 01a06d44-308d-7830-a61c-bde911f4fc6d | MSFT | 2026-09-04 12:32 | call_diagonal_spread_bearish | 2 | 1 | 4 | 25092.00 | long | ask | 501.3400 | 1.2500 | ["500","510"] | ["0.2940","0.2798"] | [] | ["XMIO"] | 500.0000 | 510.0000 | 77 | 133 | false | false | true | ||||||||||
| 01a06d3f-94dd-7e21-93d2-4e122da3e525 | MSFT | 2026-09-04 12:27 | call_diagonal_spread_bearish | 2 | 1 | 2 | 33860.00 | long | bid | 501.2750 | 2.1000 | ["410","435"] | ["0.3322","0.3240"] | [] | ["XCBO"] | 410.0000 | 435.0000 | 42 | 77 | false | false | true | ||||||||||
| 01a06d3b-c44d-7a92-a554-bdc37b48efb1 | MSFT | 2026-09-04 12:23 | call_diagonal_spread_bearish | 2 | 1 | 3 | 51618.00 | short | ask | 501.4350 | 3.4000 | ["415","500"] | ["5.0002","0.3067"] | [] | ["XPHO"] | 415.0000 | 500.0000 | 0 | 504 | false | false | true | ||||||||||
| 01a06d2f-21ee-76f3-92c6-00c282049271 | MSFT | 2026-09-04 12:09 | call_diagonal_spread_bearish | 2 | 1 | 7 | 78337.00 | long | bid | 500.8540 | 3.4500 | ["445","450"] | ["0.4179","0.2800"] | [] | ["MCRY"] | 445.0000 | 450.0000 | 7 | 42 | false | false | true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:48:56Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:35:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:28:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:24:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:10:26Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |