core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d446-00e7-7f01-b540-2a8b78c426a6 | XLK | 2026-09-24 12:35 | call_diagonal_spread | 2 | 1 | 30 | 78180.00 | short | ask | 194.3307 | 3.0500 | ["179","190"] | ["1.2737","0.2593"] | [] | ["BATO"] | 179.0000 | 190.0000 | 1 | 57 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T16:35:56Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d436-8bdf-7391-b9d3-6a182f5e4ed6 | XLK | 2026-09-24 12:18 | call_diagonal_spread | 2 | 2 | 20 | 32500.00 | short | ask | 194.3400 | 2.2000 | ["186","188"] | ["0.6728","0.2515"] | [] | ["XISX"] | 186.0000 | 188.0000 | 1 | 15 | false | false | true | ||||||||||
| 01a0cf7c-f787-7513-83ee-21d93f9c33cf | XLK | 2026-09-23 14:17 | call_diagonal_spread | 2 | 1 | 2 | 27768.00 | unknown | ask | 195.1200 | 4.3500 | ["125","160"] | ["0.3659","0.3053"] | [] | ["XISX"] | 125.0000 | 160.0000 | 267 | 849 | false | false | true | ||||||||||
| 01a0cf10-bc7f-7a81-8e20-5d3a96c3d0f7 | XLK | 2026-09-23 12:19 | call_diagonal_spread | 2 | 1 | 304 | 810160.00 | short | ask | 194.8300 | 1.8500 | ["180","195"] | ["0.2936","0.2544"] | [] | ["XCBO"] | 180.0000 | 195.0000 | 23 | 86 | false | false | true | ||||||||||
| 01a0cef4-d3f6-71c3-af3e-708030569332 | XLK | 2026-09-23 11:49 | call_diagonal_spread | 2 | 1 | 40 | 176600.00 | short | ask | 194.8100 | 2.0000 | ["185","195"] | ["0.2717","0.2683"] | [] | ["XISX"] | 185.0000 | 195.0000 | 205 | 267 | false | false | true | ||||||||||
| 01a0ca90-cdf7-7393-a0a1-b66a81b8ec37 | XLK | 2026-09-22 15:21 | call_diagonal_spread | 2 | 1 | 4 | 69128.00 | long | ask | 196.1798 | 6.0500 | ["120","125"] | ["0.3196","0.3134"] | [] | ["XMIO"] | 120.0000 | 125.0000 | 486 | 815 | false | false | true | ||||||||||
| 01a0ca7b-a017-7a81-ac02-673876ae9764 | XLK | 2026-09-22 14:58 | call_diagonal_spread | 2 | 1 | 17 | 39831.00 | long | ask | 195.9100 | 2.6000 | ["187","192.5"] | ["0.2330","0.2454"] | [] | ["XISX"] | 187.0000 | 192.5000 | 31 | 87 | false | false | true | ||||||||||
| 01a0c983-885f-7972-84a0-2fc37211f871 | XLK | 2026-09-22 10:27 | call_diagonal_spread | 2 | 1 | 13 | 42250.00 | long | ask | 195.3900 | 1.9000 | ["195","215"] | ["0.2359","0.2610"] | [] | ["XCBO"] | 195.0000 | 215.0000 | 115 | 486 | false | false | true | ||||||||||
| 01a0c981-32b6-7e42-89d0-d62363fff65a | XLK | 2026-09-22 10:24 | call_diagonal_spread | 2 | 1 | 4 | 94380.00 | long | ask | 195.2000 | 6.9000 | ["55","100"] | ["1.5297","1.5386"] | [] | ["XMIO"] | 55.0000 | 100.0000 | 31 | 87 | false | false | true | ||||||||||
| 01a0c97b-ef0f-7eb3-a40c-6bf7522e7cab | XLK | 2026-09-22 10:18 | call_diagonal_spread | 2 | 1 | 10 | 32520.00 | long | ask | 195.2900 | 3.2500 | ["195","215"] | ["0.2363","0.2622"] | [] | ["XCBO"] | 195.0000 | 215.0000 | 115 | 486 | false | false | true | ||||||||||
| 01a0c544-c957-7a63-916a-66f5ebf13d50 | XLK | 2026-09-21 14:40 | call_diagonal_spread | 2 | 1 | 16 | 125472.00 | long | ask | 194.4300 | 2.4875 | ["155","165"] | ["0.3047","0.2850"] | [] | ["XISX"] | 155.0000 | 165.0000 | 116 | 179 | false | false | true | ||||||||||
| 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 | ||||||||||
| 01a0c498-a307-7213-8734-9b8f4b74b6ad | XLK | 2026-09-21 11:32 | call_diagonal_spread | 2 | 1 | 23 | 25622.00 | long | ask | 193.4499 | 0.3000 | ["195","200"] | ["0.2208","0.2418"] | [] | ["XISX"] | 195.0000 | 200.0000 | 25 | 88 | false | true | true | ||||||||||
| 01a0c435-aeff-7592-863a-45a01162f253 | XLK | 2026-09-21 09:44 | call_diagonal_spread | 2 | 1 | 4 | 50036.00 | unknown | ask | 191.7850 | 2.8000 | ["100","160"] | ["1.0356","0.4419"] | [] | ["XBOX"] | 100.0000 | 160.0000 | 25 | 32 | false | false | true | ||||||||||
| 01a0b611-ab41-7c52-8941-95e055863d94 | XLK | 2026-09-18 15:50 | call_diagonal_spread | 2 | 1 | 3 | 30885.00 | short | ask | 189.0350 | 6.7000 | ["117.5","230"] | ["0.3271","0.2665"] | [] | ["EMLD"] | 117.5000 | 230.0000 | 455 | 819 | false | false | true | ||||||||||
| 01a0b611-ab41-7c52-8941-95d85dc75679 | XLK | 2026-09-18 15:50 | call_diagonal_spread | 2 | 1 | 3 | 30885.00 | short | ask | 188.9800 | 6.7000 | ["117.5","230"] | ["0.3294","0.2667"] | [] | ["SPHR"] | 117.5000 | 230.0000 | 455 | 819 | false | false | true | ||||||||||
| 01a0b611-a75a-75c1-bc31-c8dba28b4686 | XLK | 2026-09-18 15:50 | call_diagonal_spread | 2 | 2 | 3 | 30899.00 | short | ask | 188.9800 | 6.7000 | ["117.5","230"] | ["0.3305","0.2669"] | [] | ["BATO","C2OX"] | 117.5000 | 230.0000 | 455 | 819 | false | false | true | ||||||||||
| 01a0b5dc-f328-7be1-b9ee-d0ca3a74d72a | XLK | 2026-09-18 14:52 | call_diagonal_spread | 2 | 1 | 20 | 113940.00 | short | ask | 188.5050 | 1.1500 | ["145","185"] | ["10.4923","0.2442"] | [] | ["XMIO"] | 145.0000 | 185.0000 | 0 | 119 | false | false | true | ||||||||||
| 01a0b50f-d757-78d1-b3bd-632a918f4462 | XLK | 2026-09-18 11:08 | call_diagonal_spread | 2 | 1 | 28 | 41236.00 | long | ask | 187.9950 | 0.6500 | ["190","205"] | ["0.2537","0.1982"] | [] | ["XCBO"] | 190.0000 | 205.0000 | 28 | 182 | false | true | true | ||||||||||
| 01a0b01a-6323-7323-b8c5-534a0d08e931 | XLK | 2026-09-17 12:01 | call_diagonal_spread | 2 | 1 | 8 | 33160.00 | short | ask | 188.0850 | 1.6000 | ["170","215"] | ["0.2803","0.2587"] | [] | ["XISX"] | 170.0000 | 215.0000 | 120 | 491 | false | false | true | ||||||||||
| 01a0afb0-23eb-7cf0-bfe4-dc3a2fcafb32 | XLK | 2026-09-17 10:05 | call_diagonal_spread | 2 | 3 | 11 | 39650.00 | long | ask | 187.5800 | 2.7818 | ["170","175"] | ["1.4666","0.2692"] | [] | ["AMXO","ARCO","MCRY"] | 170.0000 | 175.0000 | 1 | 92 | false | false | true | ||||||||||
| 01a0a618-18fe-7f91-9cd0-a57ba122c302 | XLK | 2026-09-15 13:23 | call_diagonal_spread | 2 | 1 | 40 | 137000.00 | long | ask | 183.8700 | 1.1000 | ["185","187.5"] | ["0.2582","0.2672"] | [] | ["XMIO"] | 185.0000 | 187.5000 | 213 | 275 | false | true | true | ||||||||||
| 01a0a5cf-f056-7fe0-96df-f7003ccb0497 | XLK | 2026-09-15 12:04 | call_diagonal_spread | 2 | 1 | 2 | 32906.00 | short | ask | 184.1200 | 3.8500 | ["97.5","112.5"] | ["0.6175","0.3951"] | [] | ["XMIO"] | 97.5000 | 112.5000 | 94 | 275 | false | false | true | ||||||||||
| 01a0a092-4c31-7361-839e-70c44eaa3ae6 | XLK | 2026-09-14 11:38 | call_diagonal_spread | 2 | 1 | 15 | 108060.00 | short | ask | 184.9000 | 3.8000 | ["145","155"] | ["1.2710","0.2891"] | [] | ["XISX"] | 145.0000 | 155.0000 | 4 | 95 | false | false | true | ||||||||||
| 01a0a060-d420-7362-bab7-4bc0c169ab10 | XLK | 2026-09-14 10:44 | call_diagonal_spread | 2 | 1 | 12 | 35028.00 | short | ask | 183.4600 | 2.6500 | ["165","185"] | ["0.8870","0.2529"] | [] | ["ARCO"] | 165.0000 | 185.0000 | 4 | 95 | false | false | true | ||||||||||
| 01a09122-7c20-71f3-8570-8c7dbedbc321 | XLK | 2026-09-11 11:42 | call_diagonal_spread | 2 | 1 | 40 | 190760.00 | long | ask | 188.3300 | 3.4500 | ["185","187.5"] | ["0.2780","0.2692"] | [] | ["XISX"] | 185.0000 | 187.5000 | 279 | 371 | false | false | true | ||||||||||
| 01a08bab-f899-7003-8ec1-54fdd73eea25 | XLK | 2026-09-10 10:14 | call_diagonal_spread | 2 | 1 | 60 | 26220.00 | long | ask | 185.1100 | 0.3700 | ["190","195"] | ["0.2519","0.2596"] | [] | ["XCBO"] | 190.0000 | 195.0000 | 8 | 36 | false | true | true | ||||||||||
| 01a081ba-ddb8-7cf1-a57a-9e2b07b88515 | XLK | 2026-09-08 11:54 | call_diagonal_spread | 2 | 1 | 14 | 191688.00 | long | ask | 188.5100 | 4.4500 | ["122.5","140"] | ["0.4476","0.3084"] | [] | ["XMIO"] | 122.5000 | 140.0000 | 129 | 829 | false | false | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:19:07Z"} |
| 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-23T18:18:19Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:19:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:21:34Z"} |
| 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-22T18:58:18Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:27:31Z"} |
| 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-22T14:25:03Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:19:20Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:40:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:32:29Z"} |
| 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:44:15Z"} |
| 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-18T19:50:07Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:50:07Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:50:03Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:52:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:08:47Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:02:05Z"} |
| 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-17T14:06:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:23:28Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:04:47Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:39:13Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:45:07Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:42:36Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:03Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:55:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |