core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0ee13-caef-7b42-a2e0-d47445876bcb | XLY | 2026-09-29 12:51 | put_diagonal_spread | 2 | 1 | 160 | 26800.00 | unknown | ask | 108.8800 | 0.3500 | ["106","108"] | ["0.2143","0.2045"] | [] | ["EDGO"] | 106.0000 | 108.0000 | 17 | 24 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T16:51:54Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0e90a-e9ce-7d83-9727-a54d8bf65849 | XLY | 2026-09-28 13:23 | put_diagonal_spread | 2 | 3 | 36 | 46312.00 | unknown | ask | 109.4600 | 2.6000 | ["108","112.5"] | ["0.2223","0.2500"] | [] | ["ARCO","EDGO","XISX"] | 108.0000 | 112.5000 | 172 | 480 | false | false | true | ||||||||||
| 01a0e90a-e5e6-7311-9ecf-53510cb8f016 | XLY | 2026-09-28 13:23 | put_diagonal_spread | 2 | 3 | 32 | 41192.00 | unknown | ask | 109.4600 | 2.6000 | ["108","112.5"] | ["0.2216","0.2503"] | [] | ["ARCO","EDGO","XISX"] | 108.0000 | 112.5000 | 172 | 480 | false | false | true | ||||||||||
| 01a0e90a-e5e6-7311-9ecf-532c2b335c89 | XLY | 2026-09-28 13:23 | put_diagonal_spread | 2 | 3 | 28 | 36039.00 | unknown | ask | 109.4750 | 2.6000 | ["108","112.5"] | ["0.2210","0.2506"] | [] | ["ARCO","EDGO","XISX"] | 108.0000 | 112.5000 | 172 | 480 | false | false | true | ||||||||||
| 01a0d4b6-991f-71e3-ab14-0cf128a064ff | XLY | 2026-09-24 14:38 | put_vertical_spread | 2 | 1 | 22 | 83600.00 | unknown | ask | 110.5800 | 7.7000 | ["125","130"] | ["0.6430","0.7551"] | ["108.50"] | ["XBOX"] | 125.0000 | 130.0000 | 22 | 22 | false | false | false | ||||||||||
| 01a0d416-3a6e-7d20-a956-aeb1fc1e1331 | XLY | 2026-09-24 11:43 | other | 4 | 1 | 136 | 32368.00 | unknown | — | 109.7900 | 0.9000 | ["108","110","112"] | ["0.2097","0.1972","0.1952"] | [] | ["ARCO"] | 108.0000 | 112.0000 | 8 | 8 | true | false | false | true | true | mlet | |||||||
| 01a0d40c-3fbe-70b0-849f-02af4774de9d | XLY | 2026-09-24 11:32 | put_calendar | 2 | 1 | 40 | 25560.00 | unknown | bid | 109.7500 | 0.9000 | ["111"] | ["0.1764"] | [] | ["XBOX"] | 111.0000 | 111.0000 | 22 | 85 | false | false | true | false | |||||||||
| 01a0c49a-6057-7da0-8208-ff5e98716009 | XLY | 2026-09-21 11:34 | call_vertical_spread | 2 | 1 | 133 | 40432.00 | unknown | bid | 111.7050 | 0.5500 | ["116","120"] | ["0.1938","0.1884"] | ["119.04"] | ["BATO"] | 116.0000 | 120.0000 | 60 | 60 | false | true | false | ||||||||||
| 01a0c49a-6057-7da0-8208-ff4c3a73beac | XLY | 2026-09-21 11:34 | call_vertical_spread | 2 | 1 | 133 | 37240.00 | unknown | bid | 111.7050 | 0.5500 | ["116","120"] | ["0.1867","0.1790"] | ["118.80"] | ["XBOX"] | 116.0000 | 120.0000 | 60 | 60 | true | true | false | ||||||||||
| 01a0a637-60ce-7ba0-b427-5a9668e58838 | XLY | 2026-09-15 13:57 | call_diagonal_spread | 2 | 3 | 28 | 35252.00 | unknown | — | 111.1750 | 1.7000 | ["137.5","140"] | ["0.1953","0.2015"] | [] | ["ARCO","EDGO","XISX"] | 137.5000 | 140.0000 | 493 | 857 | false | true | true | true | false | ||||||||
| 01a0a622-f256-7852-af47-5f3b2850ce17 | XLY | 2026-09-15 13:35 | call_diagonal_spread | 2 | 3 | 20 | 31210.00 | unknown | — | 111.1200 | 1.2000 | ["130","135"] | ["0.1941","0.2001"] | [] | ["ARCO","EDGO","XISX"] | 130.0000 | 135.0000 | 493 | 857 | false | true | true | true | false | ||||||||
| 01a0a622-ee6d-7a01-9ebc-432af6b7b142 | XLY | 2026-09-15 13:35 | call_diagonal_spread | 2 | 3 | 21 | 32777.00 | unknown | — | 111.1200 | 1.2000 | ["130","135"] | ["0.1940","0.2002"] | [] | ["ARCO","XBOX"] | 130.0000 | 135.0000 | 493 | 857 | false | true | true | true | false | ||||||||
| 01a0a622-ee6d-7a01-9ebc-42c2d6bd2222 | XLY | 2026-09-15 13:34 | call_diagonal_spread | 2 | 5 | 28 | 44206.00 | unknown | — | 111.1200 | 1.0857 | ["130","135"] | ["0.1968","0.2008"] | [] | ["ARCO","EDGO","XISX"] | 130.0000 | 135.0000 | 493 | 857 | false | true | true | true | false | ||||||||
| 01a0a622-ee6d-7a01-9ebc-42b5be8a6b08 | XLY | 2026-09-15 13:34 | call_diagonal_spread | 2 | 3 | 28 | 44198.00 | unknown | — | 111.1200 | 1.3000 | ["130","135"] | ["0.1959","0.2014"] | [] | ["ARCO","XBOX"] | 130.0000 | 135.0000 | 493 | 857 | false | true | true | true | false | ||||||||
| 01a0a622-ea86-7b82-b03b-274af96bd418 | XLY | 2026-09-15 13:34 | call_diagonal_spread | 2 | 2 | 18 | 28368.00 | unknown | — | 111.1200 | 4.3000 | ["130","135"] | ["0.1949","0.2018"] | [] | ["ARCO","XBOX"] | 130.0000 | 135.0000 | 493 | 857 | false | true | true | true | false | ||||||||
| 01a08216-3870-7c83-815c-d2ff7cf0b5f4 | XLY | 2026-09-08 13:34 | other | 2 | 1 | 24 | 26088.00 | unknown | — | 114.2750 | 2.4000 | ["108","112.5"] | ["0.2325","0.2472"] | [] | ["AMXO"] | 108.0000 | 112.5000 | 192 | 500 | false | true | true | true | false | mlet | |||||||
| 01a08216-3870-7c83-815c-d2cebbfcb2d7 | XLY | 2026-09-08 13:34 | other | 2 | 1 | 34 | 36856.00 | unknown | — | 114.2750 | 2.5000 | ["108","112.5"] | ["0.2314","0.2469"] | [] | ["AMXO"] | 108.0000 | 112.5000 | 192 | 500 | true | true | true | true | false | mlet |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:23:20Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:23:20Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:23:20Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:39:01Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:44:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:32:49Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:34:16Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:34:16Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:58:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:35:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:35:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |