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 | 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 |
|---|
| 01a08b91-96b0-73a0-a6bf-53bdfb57bec8 | XLY | 2026-09-10 09:46 | strangle | 2 | 7 | 197 | 220639.00 | long | ask | 111.9800 | 0.4939 | ["112","118"] | ["0.2302","0.2017"] | ["100.80","129.20"] | ["AMXO","BATO","EMLD","XBOX","XCBO","XISX","XPHO"] | 112.0000 | 118.0000 | 190 | 190 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:46:30Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba8-5300-7d21-832b-d66309e11079 | XLY | 2026-09-10 10:10 | put_vertical_spread | 2 | 1 | 44500 | 33686501.00 | long | ask | 112.0500 | 0.9000 | ["107.5","112.5"] | ["0.2328","0.2179"] | ["110.73"] | ["XCBO"] | 107.5000 | 112.5000 | 99 | 99 | false | false | false | ||||||||||
| 01a08cb7-84c8-79d1-ab62-cd77e268366a | XLY | 2026-09-10 15:07 | put_vertical_spread | 2 | 1 | 372 | 814680.00 | unknown | — | 111.9617 | 3.9000 | ["121","122.5"] | ["0.6325","0.6904"] | [] | ["XBOX"] | 121.0000 | 122.5000 | 8 | 8 | false | false | false | true | false | ||||||||
| 01a090ea-68a8-7223-a001-60ce9a111f03 | XLY | 2026-09-11 10:41 | strangle | 2 | 1 | 2500 | 1377500.00 | unknown | — | 112.5650 | 1.3000 | ["105","120"] | ["0.2408","0.1956"] | [] | ["AMXO"] | 105.0000 | 120.0000 | 126 | 126 | false | true | false | true | true | mlct | |||||||
| 01a090ed-04a0-7703-8a51-1180665531c3 | XLY | 2026-09-11 10:44 | strangle | 2 | 1 | 2500 | 1375000.00 | unknown | — | 112.6800 | 1.3000 | ["105","120"] | ["0.2417","0.1939"] | [] | ["AMXO"] | 105.0000 | 120.0000 | 126 | 126 | false | true | false | true | true | mlct | |||||||
| 01a0a042-ff68-7160-a36d-fc9535a050b0 | XLY | 2026-09-14 10:12 | put_calendar | 2 | 1 | 5000 | 7250000.00 | short | ask | 112.5300 | 3.4000 | ["115"] | ["0.2181"] | [] | ["XPHO"] | 115.0000 | 115.0000 | 123 | 276 | true | false | true | false | |||||||||
| 01a0a652-a546-7f42-800c-b4862e52a61a | XLY | 2026-09-15 14:27 | straddle | 2 | 1 | 555 | 361998.00 | long | ask | 111.0950 | 0.8000 | ["117.5"] | ["0.3690"] | ["110.98","124.02"] | ["SPHR"] | 117.5000 | 117.5000 | 3 | 3 | false | false | false | false | |||||||||
| 01a0a66f-c64e-7eb3-8c82-35db98cd1435 | XLY | 2026-09-15 14:58 | straddle | 2 | 1 | 435 | 215760.00 | short | bid | 110.9600 | 0.6000 | ["111"] | ["0.1923"] | ["106.04","115.96"] | ["EDGO"] | 111.0000 | 111.0000 | 31 | 31 | true | false | false | false | |||||||||
| 01a0abd0-5d63-7183-a6eb-268307e11178 | XLY | 2026-09-16 16:02 | other | 4 | 3 | 1252 | 379235.00 | unknown | — | 110.1700 | 4.6500 | ["114","117.5","119","122.5"] | ["0.1730","1.3910","1.6154","1.9079"] | [] | ["ARCO"] | 114.0000 | 122.5000 | 2 | 30 | false | true | true | true | false | ||||||||
| 01a0b014-f86b-7020-8e97-8458f6dd5bdc | XLY | 2026-09-17 11:55 | other | 4 | 4 | 678 | 325040.00 | unknown | — | 111.7750 | 16.8000 | ["80","85","90","95"] | ["0.2947","0.2855","0.2727","0.2616"] | [] | ["AMXO"] | 80.0000 | 95.0000 | 365 | 365 | true | true | false | true | false | mlft | |||||||
| 01a0b0ab-e90b-7a33-a853-c136043ac027 | XLY | 2026-09-17 14:40 | put_ladder | 6 | 1 | 220 | 286200.00 | unknown | — | 111.5400 | 8.2000 | ["116","118","118.5","119","119.5","121"] | ["0.5715","0.7486","1.0643","1.1138","1.1625","1.3814"] | [] | ["XBOX"] | 116.0000 | 121.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0af-ec63-7df3-b5d6-8cd04c604659 | XLY | 2026-09-17 14:45 | put_ladder | 3 | 1 | 1990 | 2539940.00 | unknown | — | 111.5350 | 2.7000 | ["116","117.5","120"] | ["0.4860","0.9596","1.0208"] | [] | ["XBOX"] | 116.0000 | 120.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0cef4-eb67-7472-ae39-1d6b762a474b | XLY | 2026-09-23 11:49 | straddle | 2 | 1 | 2000 | 2104000.00 | short | bid | 110.7100 | 1.5000 | ["110"] | ["0.2124"] | ["99.48","120.52"] | ["ARCO"] | 110.0000 | 110.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0d4bc-6197-79c3-889c-dd961ae5946a | XLY | 2026-09-24 14:45 | put_vertical_spread | 2 | 2 | 250 | 218750.00 | unknown | — | 110.5400 | 1.3000 | ["90","100"] | ["0.2742","0.2576"] | [] | ["XCBO"] | 90.0000 | 100.0000 | 484 | 484 | false | true | false | true | false | ||||||||
| 01a0d8d1-de1e-7f43-8da0-ee3eb59128d8 | XLY | 2026-09-25 09:47 | call_diagonal_spread | 2 | 1 | 40 | 190040.00 | short | bid | 110.0600 | 5.2000 | ["85","90"] | ["0.4214","0.6043"] | [] | ["XMIO"] | 85.0000 | 90.0000 | 21 | 84 | false | false | true | true | |||||||||
| 01a0e87f-4b9f-7d01-ad3e-3823643180f4 | XLY | 2026-09-28 10:50 | put_diagonal_spread | 2 | 1 | 4000 | 2300000.00 | long | ask | 109.3700 | 1.0500 | ["100","102.5"] | ["0.2409","0.2321"] | [] | ["XBOX"] | 100.0000 | 102.5000 | 109 | 262 | false | true | true | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:11:08Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:07:20Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:41:37Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:44:31Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:12:21Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:27:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:59:15Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T20:03:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:56:20Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:41:00Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:45:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:49:14Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:45:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:47:27Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:51:03Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |