core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg473,794 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 |
|---|
| 01a0821e-9510-7351-8525-25139a0c8670 | CLS | 2026-09-08 13:43 | call_backspread | 2 | 1 | 18 | 189981.00 | long | bid | 333.3238 | 4.3000 | ["230","320"] | ["0.7474","0.7229"] | ["240.71","399.29"] | ["XCBO"] | 230.0000 | 320.0000 | 73 | 73 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:44:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d8-8f48-7210-897a-d172d18f0ccf | CLS | 2026-09-08 12:27 | other | 3 | 3 | 400 | 930600.00 | unknown | — | 331.0400 | 8.3000 | ["320","325","345"] | ["0.6834","0.7245","0.7158"] | [] | ["XCBO"] | 320.0000 | 345.0000 | 3 | 10 | false | false | true | true | false | mfsl | |||||||
| 01a081c9-1658-7091-ae23-4aa8535b6c6f | CLS | 2026-09-08 12:10 | put_vertical_spread | 2 | 1 | 30 | 153690.00 | long | ask | 331.2100 | 6.4000 | ["330","340"] | ["0.6256","0.6264"] | ["334.45"] | ["XCBO"] | 330.0000 | 340.0000 | 31 | 31 | true | false | false | true | |||||||||
| 01a08188-d138-7e53-9992-09794a4871a4 | CLS | 2026-09-08 11:00 | call_vertical_spread | 2 | 1 | 10 | 109800.00 | short | bid | 327.5500 | 7.0000 | ["340","370"] | ["0.6648","0.6609"] | ["350.90"] | ["AMXO"] | 340.0000 | 370.0000 | 192 | 192 | false | true | false | true | |||||||||
| 01a0815a-eb39-7160-b01a-2e6fe38a5ee1 | CLS | 2026-09-08 10:10 | call_backspread | 2 | 1 | 600 | 2018600.00 | long | bid | 319.5200 | 9.7000 | ["400","600"] | ["0.6730","0.6760"] | ["702.04"] | ["XBOX"] | 400.0000 | 600.0000 | 255 | 255 | true | true | false | true | |||||||||
| 01a0814b-3f82-7453-80fb-d0153ea5412c | CLS | 2026-09-08 09:53 | call_vertical_spread | 2 | 1 | 10 | 100810.00 | short | bid | 319.4300 | 9.2000 | ["340","370"] | ["0.6629","0.6599"] | ["350.25"] | ["XMIO"] | 340.0000 | 370.0000 | 192 | 192 | false | true | false | true | |||||||||
| 01a0813f-8b68-75c2-9769-08f200266a4d | CLS | 2026-09-08 09:40 | call_vertical_spread | 2 | 1 | 10 | 100660.00 | short | bid | 320.5000 | 9.4000 | ["340","370"] | ["0.6563","0.6526"] | ["350.40"] | ["EDGO"] | 340.0000 | 370.0000 | 192 | 192 | false | true | false | true | |||||||||
| 01a0813f-21f0-79a3-a938-acadd28e5493 | CLS | 2026-09-08 09:39 | call_vertical_spread | 2 | 1 | 10 | 100710.00 | short | bid | 320.0000 | 9.4000 | ["340","370"] | ["0.6599","0.6552"] | ["350.45"] | ["XMIO"] | 340.0000 | 370.0000 | 192 | 192 | false | true | false | true | |||||||||
| 01a06dfd-ef55-7fc3-96b7-48c198d29f63 | CLS | 2026-09-04 15:55 | call_vertical_spread | 2 | 1 | 313 | 144293.00 | unknown | — | 312.5600 | 1.5000 | ["330","360"] | ["0.5944","0.5978"] | [] | ["AMXO"] | 330.0000 | 360.0000 | 7 | 7 | false | true | false | true | false | mlat | |||||||
| 01a06da6-a795-7fc2-b240-b2d6c5f26b2d | CLS | 2026-09-04 14:20 | call_diagonal_spread_bearish | 2 | 1 | 12 | 108792.00 | long | bid | 308.9299 | 9.6000 | ["262.5","265"] | ["10.3780","0.5510"] | [] | ["XISX"] | 262.5000 | 265.0000 | 0 | 7 | false | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:28:11Z"} |
| 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-08T16:10:48Z"} |
| 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-08T15:00:46Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:10:13Z"} |
| 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-08T13:53:05Z"} |
| 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-08T13:40:19Z"} |
| 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-08T13:39:51Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:56:00Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:20:35Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |