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 |
|---|
| 01a06db7-8bcd-77d2-a4db-d1642d5ced6b | XOM | 2026-09-04 14:38 | call_vertical_spread | 2 | 1 | 42 | 32340.00 | unknown | — | 159.9000 | 0.2400 | ["160","175"] | ["0.2735","0.2731"] | [] | ["C2OX"] | 160.0000 | 175.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:38:59Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db7-8bcd-77d2-a4db-d15e6bf51b89 | XOM | 2026-09-04 14:38 | call_vertical_spread | 2 | 4 | 58 | 44644.00 | unknown | — | 159.9000 | 0.2900 | ["160","175"] | ["0.2735","0.2730"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 160.0000 | 175.0000 | 42 | 42 | false | true | false | true | false | mlet | |||||||
| 01a06d89-3486-72e1-98a5-1e7fae851f73 | XOM | 2026-09-04 13:48 | call_diagonal_spread_bearish | 2 | 1 | 18 | 46494.00 | long | bid | 160.1500 | 1.5500 | ["150","155"] | ["0.2885","0.2694"] | [] | ["XCBO"] | 150.0000 | 155.0000 | 42 | 105 | false | false | true | true | false | ||||||||
| 01a06d53-b91d-7002-8e70-b1a7407cbc75 | XOM | 2026-09-04 12:49 | other | 3 | 1 | 800 | 81850.00 | unknown | — | 160.5150 | 0.2700 | ["162.5","167.5","172.5"] | ["0.2358","0.2518","0.2924"] | [] | ["XISX"] | 162.5000 | 172.5000 | 7 | 7 | false | true | false | true | false | mlat | |||||||
| 01a06d53-4fa5-7802-8caa-152512c155b0 | XOM | 2026-09-04 12:49 | call_butterfly_spread | 3 | 1 | 1560 | 158858.00 | short | bid | 160.5000 | 0.2500 | ["162.5","167.5","172.5"] | ["0.2376","0.2522","0.2821"] | ["163.26","171.74"] | ["EDGO"] | 162.5000 | 172.5000 | 7 | 7 | false | true | false | true | false | ||||||||
| 01a06d42-a21d-7251-bb9f-2a2c2e336258 | XOM | 2026-09-04 12:31 | put_vertical_spread | 2 | 4 | 92 | 49052.00 | short | bid | 160.1350 | 0.2700 | ["150","155"] | ["0.2795","0.2738"] | ["153.6"] | ["BATO","C2OX","EDGO","XBOX"] | 150.0000 | 155.0000 | 42 | 42 | false | true | false | true | false | ||||||||
| 01a06d42-a21d-7251-bb9f-2a1f3fef5a5a | XOM | 2026-09-04 12:31 | put_vertical_spread | 2 | 4 | 108 | 57832.00 | short | bid | 160.1350 | 0.3300 | ["150","155"] | ["0.2803","0.2744"] | ["153.6"] | ["ARCO","EMLD","SPHR"] | 150.0000 | 155.0000 | 42 | 42 | false | true | false | true | false | ||||||||
| 01a06d3b-b4ae-70b3-b17c-39f2fff29eb5 | XOM | 2026-09-04 12:23 | call_calendar | 2 | 1 | 30 | 183420.00 | short | ask | 160.1600 | 4.4000 | ["130"] | ["3.1490"] | [] | ["EDGO"] | 130.0000 | 130.0000 | 0 | 21 | false | false | true | false | false | mlet | |||||||
| 01a06d3b-acdd-77b2-815f-f03cae47fc10 | XOM | 2026-09-04 12:23 | call_calendar | 2 | 2 | 18 | 110070.00 | short | ask | 160.1600 | 4.4000 | ["130"] | ["3.1692"] | [] | ["C2OX","EDGO"] | 130.0000 | 130.0000 | 0 | 21 | false | false | true | false | false | mlet | |||||||
| 01a06d37-289d-7d63-bc4b-00adbc2a030b | XOM | 2026-09-04 12:18 | call_diagonal_spread_bearish | 2 | 1 | 15 | 47190.00 | short | bid | 160.0600 | 1.4000 | ["145","150"] | ["0.3437","0.2661"] | [] | ["XMIO"] | 145.0000 | 150.0000 | 14 | 105 | false | false | true | true | false | ||||||||
| 01a06d31-8b1d-77e2-8136-b0ee05fbc9f0 | XOM | 2026-09-04 12:12 | other | 2 | 7 | 20 | 26350.00 | unknown | — | 160.2300 | 0.7000 | ["140","170"] | ["0.3088","0.2634"] | [] | ["ARCO","C2OX","EDGO","EMLD","XCBO","XISX","XMIO"] | 140.0000 | 170.0000 | 286 | 286 | false | true | false | true | true | mlet | |||||||
| 01a06d30-bffd-70e2-9e25-103690ded5a0 | XOM | 2026-09-04 12:11 | call_calendar | 2 | 1 | 20 | 38200.00 | short | bid | 160.2200 | 1.8000 | ["155"] | ["0.2764"] | [] | ["XISX"] | 155.0000 | 155.0000 | 42 | 49 | false | false | true | false | false | mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:38:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:48:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:50:23Z"} |
| 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:49:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:31:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:31:42Z"} |
| 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:23:43Z"} |
| 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:23:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:19:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:12:46Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:12:10Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |