core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a0816c-a648-70e0-af7e-a9109b371f1a | XOM | 2026-09-08 10:29 | call_condor | 4 | 1 | 6 | 32436.00 | short | bid | 161.3400 | 7.1000 | ["150","170","180","185"] | ["0.2488","0.2567","0.2629","0.2637"] | ["158.40"] | ["XMIO"] | 150.0000 | 185.0000 | 282 | 282 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:29:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08165-ef88-7d02-bde3-182b8a118029 | XOM | 2026-09-08 10:22 | call_calendar | 2 | 1 | 8 | 69080.00 | short | bid | 161.2350 | 5.0000 | ["120"] | ["0.3371"] | [] | ["XMIO"] | 120.0000 | 120.0000 | 129 | 192 | false | false | true | false | false | ||||||||
| 01a08154-9238-7610-80b7-54bc3c45e28b | XOM | 2026-09-08 10:03 | call_vertical_spread | 2 | 7 | 50 | 27004.00 | short | bid | 161.2750 | 0.4300 | ["165","180"] | ["0.2798","0.2824"] | ["168.52"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"] | 165.0000 | 180.0000 | 38 | 38 | false | true | false | true | |||||||||
| 01a0814c-3980-75c1-82a0-7d5b5c2aa570 | XOM | 2026-09-08 09:54 | call_vertical_spread | 2 | 1 | 99 | 81180.00 | short | bid | 160.7300 | 0.5400 | ["160","175"] | ["0.2858","0.2850"] | ["165"] | ["C2OX"] | 160.0000 | 175.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a0813a-7a88-7aa2-9476-c1ed87f1ea1d | XOM | 2026-09-08 09:34 | call_diagonal_spread | 2 | 1 | 100 | 115300.00 | short | bid | 162.4150 | 1.8500 | ["170","175"] | ["0.2779","0.2614"] | [] | ["XMIO"] | 170.0000 | 175.0000 | 73 | 129 | false | true | true | true | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | |||||||||
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:22:33Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:03:24Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:54:31Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:34:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| 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 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| 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:10Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |