core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f3de-850f-7533-8353-e5adf0263ed4 | XLI | 2026-09-30 15:50 | call_calendar | 2 | 1 | 10 | 41040.00 | short | bid | 167.2700 | 1.4000 | ["150"] | ["0.2421"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 79 | 107 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T19:50:40Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0f364-6f27-7d22-a01e-9003d03b7564 | XLI | 2026-09-30 13:37 | call_diagonal_spread | 2 | 2 | 19 | 28508.00 | short | ask | 168.0000 | 1.0000 | ["167","175"] | ["0.2076","0.1921"] | [] | ["XISX"] | 167.0000 | 175.0000 | 79 | 170 | false | false | true | ||||||||||
| 01a0f282-2966-7b72-a075-f111a85ba66b | XLI | 2026-09-30 09:30 | call_calendar | 2 | 2 | 15 | 66420.00 | short | ask | 169.4250 | 3.9000 | ["150"] | ["0.2278"] | [] | ["XISX"] | 150.0000 | 150.0000 | 79 | 107 | false | false | true | false | |||||||||
| 01a0ed6a-63bf-7770-8287-26ff88b9c7dd | XLI | 2026-09-29 09:46 | put_vertical_spread | 2 | 1 | 1400 | 50400.00 | short | bid | 170.0950 | 0.2200 | ["160","165"] | ["0.4196","0.2754"] | ["164.92"] | ["AMXO"] | 160.0000 | 165.0000 | 3 | 3 | false | true | false | ||||||||||
| 01a0cf41-ee3e-7b32-b797-49e822350545 | XLI | 2026-09-23 13:13 | straddle | 2 | 2 | 33 | 42312.00 | short | bid | 170.4200 | 0.4045 | ["173"] | ["0.1935"] | ["160.18","185.82"] | ["ARCO","EDGO"] | 173.0000 | 173.0000 | 86 | 86 | false | false | false | false | |||||||||
| 01a0ca12-5adf-7c33-80a4-78d31203aeea | XLI | 2026-09-22 13:03 | put_diagonal_spread | 2 | 1 | 12 | 29484.00 | short | bid | 169.8650 | 0.3500 | ["173","190"] | ["0.1694","0.2227"] | [] | ["BATO"] | 173.0000 | 190.0000 | 24 | 87 | false | false | true | ||||||||||
| 01a0afb5-4083-7b81-bf7a-979091944c41 | XLI | 2026-09-17 10:11 | call_diagonal_spread | 2 | 1 | 10 | 56260.00 | short | bid | 169.0675 | 5.3000 | ["160","170"] | ["0.2102","0.2040"] | [] | ["XISX"] | 160.0000 | 170.0000 | 491 | 855 | false | false | true | ||||||||||
| 01a0abc8-b08b-7b70-b6a6-6f9bbb616422 | XLI | 2026-09-16 15:54 | put_vertical_spread | 2 | 2 | 50 | 35850.00 | short | bid | 168.4100 | 0.3000 | ["166","170"] | ["0.2096","0.2033"] | ["168.23"] | ["MCRY","XPHO"] | 166.0000 | 170.0000 | 30 | 30 | false | false | false | ||||||||||
| 01a0abc8-b08b-7b70-b6a6-6f89c2589b4a | XLI | 2026-09-16 15:54 | put_vertical_spread | 2 | 5 | 124 | 88860.00 | short | bid | 168.4100 | 0.3000 | ["166","170"] | ["0.2095","0.2032"] | ["168.23"] | ["AMXO","EMLD","MCRY","XMIO","XPHO"] | 166.0000 | 170.0000 | 30 | 30 | false | false | false | ||||||||||
| 01a0a0a0-03e9-70e3-82b4-181ff7b2e424 | XLI | 2026-09-14 11:53 | put_diagonal_spread | 2 | 1 | 28 | 44884.00 | short | bid | 169.7200 | 1.0000 | ["175","177.5"] | ["0.2039","0.2810"] | [] | ["XCBO"] | 175.0000 | 177.5000 | 4 | 67 | false | false | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T17:37:58Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T13:30:09Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:46:10Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:13:26Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:04:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:11:40Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:54:14Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:54:14Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:53:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |