core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a0ca43-5206-75d3-b39f-ee74875431ed | XLK | 2026-09-22 13:56 | call_vertical_spread | 2 | 1 | 5 | 28140.00 | short | bid | 195.7100 | 1.6000 | ["167.5","168"] | ["0.8666","0.8522"] | ["168"] | ["XCBO"] | 167.5000 | 168.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:57:01Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9ca-0357-7053-bfc5-1805094ac03b | XLK | 2026-09-22 11:44 | call_vertical_spread | 2 | 4 | 25 | 30285.00 | short | bid | 195.0500 | 0.7500 | ["195","196"] | ["0.2348","0.2326"] | ["195.55"] | ["XCBO","XMIO"] | 195.0000 | 196.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a0c585-396f-7201-b137-fb3404b3b6ad | XLK | 2026-09-21 15:50 | call_calendar | 2 | 1 | 10 | 88420.00 | short | ask | 194.7300 | 6.8500 | ["170"] | ["0.2847"] | [] | ["XMIO"] | 170.0000 | 170.0000 | 452 | 487 | false | false | true | false | |||||||||
| 01a0c541-9cd7-73d2-9fc0-b6d11717fabd | XLK | 2026-09-21 14:36 | call_vertical_spread | 2 | 1 | 2 | 25956.00 | short | bid | 194.3150 | 4.1000 | ["130","140"] | ["0.3065","0.3045"] | ["138.90"] | ["XCBO"] | 130.0000 | 140.0000 | 269 | 269 | false | false | false | true | |||||||||
| 01a0c4f6-3427-72f3-8609-d85898ab4d3b | XLK | 2026-09-21 13:14 | call_butterfly_spread | 3 | 1 | 2 | 30951.00 | short | bid | 193.9499 | 9.4000 | ["112.5","127.5","135"] | ["0.3038","0.3090","0.3091"] | ["119.25"] | ["AMXO"] | 112.5000 | 135.0000 | 452 | 452 | false | false | false | ||||||||||
| 01a0c499-ef0f-70a3-bbf5-d84ba8eeeedd | XLK | 2026-09-21 11:33 | call_diagonal_spread | 2 | 1 | 20 | 161860.00 | short | ask | 193.4099 | 5.7500 | ["190","200"] | ["0.2773","0.2725"] | [] | ["XCBO"] | 190.0000 | 200.0000 | 816 | 851 | false | false | true | true | |||||||||
| 01a0c45b-d49f-79d1-9767-9ca08139ccbf | XLK | 2026-09-21 10:25 | call_vertical_spread | 2 | 1 | 400 | 70000.00 | short | bid | 192.7000 | 0.7500 | ["250","260"] | ["0.2323","0.2333"] | ["250.45"] | ["XCBO"] | 250.0000 | 260.0000 | 179 | 179 | true | true | false | true | |||||||||
| 01a0c43f-1d0f-75a0-a6a2-02192efe677e | XLK | 2026-09-21 09:54 | call_butterfly_spread | 3 | 1 | 2 | 34079.00 | short | bid | 192.3500 | 9.0000 | ["100","117.5","125"] | ["0.3280","0.3195","0.3150"] | ["109.15"] | ["AMXO"] | 100.0000 | 125.0000 | 452 | 452 | false | false | false | ||||||||||
| 01a0b5ee-3908-7192-91c9-0007976825de | XLK | 2026-09-18 15:11 | call_calendar | 2 | 1 | 2 | 45732.00 | short | bid | 188.5850 | 4.3000 | ["77.5"] | ["0.5338"] | [] | ["XMIO"] | 77.5000 | 77.5000 | 272 | 455 | false | false | true | false | |||||||||
| 01a0b5c1-2dc8-7fa2-a46b-4b8913147fe0 | XLK | 2026-09-18 14:22 | call_calendar | 2 | 1 | 19 | 167513.00 | short | ask | 188.2750 | 1.1500 | ["145"] | ["0.4190"] | [] | ["XMIO"] | 145.0000 | 145.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5a6-f6d8-7f70-b6c7-1d47520c578c | XLK | 2026-09-18 13:53 | call_calendar | 2 | 1 | 10 | 185830.00 | short | bid | 188.2650 | 2.9000 | ["96.5"] | ["0.5683"] | [] | ["XCBO"] | 96.5000 | 96.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b55c-d25f-7643-8790-b2bd671586bb | XLK | 2026-09-18 12:32 | call_calendar | 2 | 1 | 32 | 476182.00 | short | bid | 187.7200 | 2.2000 | ["115"] | ["6.0427"] | [] | ["XMIO"] | 115.0000 | 115.0000 | 0 | 182 | false | false | true | false | |||||||||
| 01a0afbc-39ab-7c21-b387-1750e915fe72 | XLK | 2026-09-17 10:19 | call_vertical_spread | 2 | 1 | 45 | 388125.00 | short | bid | 187.9900 | 2.1000 | ["144","145"] | ["2.4506","2.3949"] | ["144.99"] | ["AMXO"] | 144.0000 | 145.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0ab08-f29b-7142-b9f8-c0705e460829 | XLK | 2026-09-16 12:24 | call_calendar | 2 | 1 | 6 | 122070.00 | short | bid | 185.4801 | 5.4000 | ["95"] | ["0.3292"] | [] | ["XMIO"] | 95.0000 | 95.0000 | 821 | 856 | false | false | true | false | |||||||||
| 01a0a66c-0d2d-77a0-b87e-86026c2e614a | XLK | 2026-09-15 14:54 | call_vertical_spread | 2 | 1 | 3 | 61755.00 | short | bid | 183.6600 | 2.5000 | ["80","82.5"] | ["4.6899","4.5458"] | ["82.49"] | ["XMIO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a66a-7ebe-7a52-aa57-43da13fc5286 | XLK | 2026-09-15 14:53 | call_vertical_spread | 2 | 1 | 3 | 61755.00 | short | bid | 183.6300 | 2.5000 | ["80","82.5"] | ["4.7356","4.5897"] | ["82.49"] | ["XMIO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a66a-5b96-7d21-9e92-87e71e881f04 | XLK | 2026-09-15 14:53 | call_vertical_spread | 2 | 1 | 3 | 61755.00 | short | bid | 183.6001 | 2.5000 | ["80","82.5"] | ["4.7796","4.6319"] | ["82.49"] | ["XMIO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a66a-309e-73a0-be4f-dd7e50637905 | XLK | 2026-09-15 14:52 | call_vertical_spread | 2 | 1 | 3 | 61755.00 | short | bid | 183.6100 | 2.4500 | ["80","82.5"] | ["4.7652","4.6181"] | ["82.49"] | ["XCBO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a66a-192e-76a0-8119-1704befab803 | XLK | 2026-09-15 14:52 | call_vertical_spread | 2 | 1 | 2 | 41170.00 | short | bid | 183.6300 | 2.4500 | ["80","82.5"] | ["4.7356","4.5897"] | ["82.49"] | ["XCBO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a66a-115e-7ee3-accf-cb6a3ace080d | XLK | 2026-09-15 14:52 | call_vertical_spread | 2 | 1 | 2 | 41170.00 | short | bid | 183.6300 | 2.4500 | ["80","82.5"] | ["4.7356","4.5897"] | ["82.49"] | ["XCBO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a669-d2de-7130-8238-048584498135 | XLK | 2026-09-15 14:52 | call_vertical_spread | 2 | 1 | 2 | 41170.00 | short | bid | 183.6300 | 2.4500 | ["80","82.5"] | ["4.7356","4.5897"] | ["82.49"] | ["XCBO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a669-c33e-76f1-90a8-1284697e9fa6 | XLK | 2026-09-15 14:52 | call_vertical_spread | 2 | 1 | 2 | 41186.00 | short | bid | 183.6300 | 2.4500 | ["80","82.5"] | ["4.7951","4.6468"] | ["82.49"] | ["XMIO"] | 80.0000 | 82.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a5c3-3a6f-7960-986f-98ff70fa62ee | XLK | 2026-09-15 11:50 | call_vertical_spread | 2 | 3 | 3 | 26175.00 | short | bid | 184.2400 | 1.3500 | ["140","141"] | ["1.4865","1.5150"] | ["140.97"] | ["XCBO"] | 140.0000 | 141.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a5c3-3a6f-7960-986f-98e724ed0abc | XLK | 2026-09-15 11:50 | call_vertical_spread | 2 | 3 | 3 | 26175.00 | short | bid | 184.2400 | 1.3500 | ["140","141"] | ["1.4865","1.5150"] | ["140.97"] | ["XCBO"] | 140.0000 | 141.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a5c3-3a6f-7960-986f-988d4109bdb4 | XLK | 2026-09-15 11:50 | call_vertical_spread | 2 | 4 | 4 | 34900.00 | short | bid | 184.2200 | 1.3500 | ["140","141"] | ["1.5127","1.5368"] | ["140.97"] | ["XCBO"] | 140.0000 | 141.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a110-1f20-7963-8c58-7310a146f8ac | XLK | 2026-09-14 13:56 | call_calendar | 2 | 1 | 3 | 42072.00 | short | ask | 185.5199 | 3.0000 | ["115"] | ["1.3974"] | [] | ["AMXO"] | 115.0000 | 115.0000 | 4 | 32 | false | false | true | false | |||||||||
| 01a06dee-2c2d-76d0-bb3e-2e955f7d07cb | XLK | 2026-09-04 15:38 | call_diagonal_spread_bearish | 2 | 1 | 8 | 57114.00 | short | bid | 186.8600 | 3.1000 | ["160","170"] | ["0.3176","0.3011"] | [] | ["XCBO"] | 160.0000 | 170.0000 | 133 | 504 | false | false | true | true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:44:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:50:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:37:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:14:27Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:33:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:26:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:54:27Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:11:33Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:22:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:53:52Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:32:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:19:17Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:25:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:55:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:52:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:50:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:50:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:50:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:56:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:39:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |