core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0ce93-08cf-71c3-b236-1d2ffa839528 | SKHY | 2026-09-23 10:02 | call_diagonal_spread | 2 | 1 | 14 | 118552.00 | long | ask | 190.1400 | 3.0000 | ["170","175"] | ["0.6450","0.6473"] | [] | ["XPHO"] | 170.0000 | 175.0000 | 86 | 267 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T14:02:33Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0ce83-0727-79a3-9957-a1ea0fa19357 | SKHY | 2026-09-23 09:44 | call_diagonal_spread | 2 | 2 | 20 | 192460.00 | unknown | ask | 191.0400 | 4.5250 | ["150","155"] | ["2.2605","0.6514"] | [] | ["XBOX","XPHO"] | 150.0000 | 155.0000 | 2 | 177 | false | false | true | ||||||||||
| 01a0ce80-efff-7260-a707-0181b29566c1 | SKHY | 2026-09-23 09:42 | call_diagonal_spread | 2 | 1 | 40 | 121480.00 | long | ask | 190.8895 | 2.1500 | ["185","205"] | ["0.6209","0.6728"] | [] | ["XMIO"] | 185.0000 | 205.0000 | 23 | 58 | false | false | true | ||||||||||
| 01a0ca39-66f7-70b3-826a-ad21f7016859 | SKHY | 2026-09-22 13:45 | call_diagonal_spread | 2 | 1 | 100 | 145400.00 | long | ask | 193.8400 | 0.6500 | ["190","195"] | ["0.6596","0.6406"] | [] | ["XCBO"] | 190.0000 | 195.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0c99c-e48e-7c53-9286-e94dadee7e96 | SKHY | 2026-09-22 10:54 | call_diagonal_spread | 2 | 1 | 8 | 105008.00 | short | ask | 194.5500 | 7.2000 | ["110","160"] | ["1.5872","0.6215"] | [] | ["XMIO"] | 110.0000 | 160.0000 | 24 | 115 | false | false | true | ||||||||||
| 01a0c959-828f-7360-a7fc-e6e7b192cdca | SKHY | 2026-09-22 09:41 | call_diagonal_spread | 2 | 2 | 14 | 113510.00 | unknown | ask | 191.4550 | 4.2500 | ["170","175"] | ["0.6262","0.6296"] | [] | ["XMIO","XPHO"] | 170.0000 | 175.0000 | 59 | 268 | false | false | true | ||||||||||
| 01a0c956-d30f-7771-aa38-082894fc724c | SKHY | 2026-09-22 09:38 | call_diagonal_spread | 2 | 2 | 14 | 112714.00 | long | ask | 190.7750 | 3.2000 | ["170","175"] | ["0.6308","0.6343"] | [] | ["XPHO"] | 170.0000 | 175.0000 | 59 | 268 | false | false | true | ||||||||||
| 01a0c956-c756-75c2-a250-2019be05e972 | SKHY | 2026-09-22 09:38 | call_diagonal_spread | 2 | 2 | 13 | 104650.00 | long | ask | 190.6100 | 2.9500 | ["170","175"] | ["0.6331","0.6377"] | [] | ["EMLD","XMIO"] | 170.0000 | 175.0000 | 59 | 268 | false | false | true | ||||||||||
| 01a0c956-c36e-7772-91ef-17bd58949ed4 | SKHY | 2026-09-22 09:38 | call_diagonal_spread | 2 | 3 | 30 | 237536.00 | long | ask | 190.6100 | 4.3000 | ["170","175"] | ["0.6213","0.6133"] | [] | ["XBOX","XMIO","XPHO"] | 170.0000 | 175.0000 | 59 | 268 | false | false | true | ||||||||||
| 01a0c956-8cbf-7713-aa0a-f2a06fcf7475 | SKHY | 2026-09-22 09:38 | call_diagonal_spread | 2 | 1 | 13 | 103818.00 | unknown | ask | 190.6450 | 4.6500 | ["170","175"] | ["0.6275","0.6239"] | [] | ["XISX"] | 170.0000 | 175.0000 | 59 | 268 | false | false | true | ||||||||||
| 01a0c956-7166-7b70-bfe7-a04b61feb314 | SKHY | 2026-09-22 09:37 | call_diagonal_spread | 2 | 1 | 13 | 103181.00 | long | ask | 190.2100 | 4.9500 | ["170","175"] | ["0.6286","0.6257"] | [] | ["XISX"] | 170.0000 | 175.0000 | 59 | 268 | false | false | true | ||||||||||
| 01a0c956-560f-7d00-ab19-c3cd9096cf19 | SKHY | 2026-09-22 09:37 | call_diagonal_spread | 2 | 2 | 27 | 212598.00 | long | ask | 189.6850 | 4.1000 | ["170","175"] | ["0.6299","0.6268"] | [] | ["XISX","XPHO"] | 170.0000 | 175.0000 | 59 | 268 | false | false | true | ||||||||||
| 01a0b5fe-ee5f-7192-ae42-b726daca07f4 | SKHY | 2026-09-18 15:29 | call_diagonal_spread | 2 | 6 | 176 | 661696.00 | short | ask | 189.6600 | 1.2000 | ["170","195"] | ["7.8372","0.6280"] | [] | ["AMXO","EDGO","XCBO","XMIO","XPHO"] | 170.0000 | 195.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b5fb-0277-7cd0-9245-bf5215d1eb06 | SKHY | 2026-09-18 15:25 | call_diagonal_spread | 2 | 1 | 96 | 273984.00 | long | ask | 189.3607 | 1.1500 | ["180","182.5"] | ["0.5767","0.5915"] | [] | ["XCBO"] | 180.0000 | 182.5000 | 14 | 21 | false | false | true | ||||||||||
| 01a0b523-76c7-7b01-b2f0-14dcfe646667 | SKHY | 2026-09-18 11:29 | call_diagonal_spread | 2 | 1 | 7 | 101227.00 | long | ask | 183.3100 | 2.4500 | ["160","170"] | ["0.6279","0.6349"] | [] | ["BATO"] | 160.0000 | 170.0000 | 490 | 854 | false | false | true | ||||||||||
| 01a0b028-b71b-7180-99b0-35eb013a5f4b | SKHY | 2026-09-17 12:17 | call_diagonal_spread | 2 | 1 | 25 | 109575.00 | short | ask | 182.5350 | 1.0500 | ["150","185"] | ["2.0718","0.5939"] | [] | ["XCBO"] | 150.0000 | 185.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0abc5-d9fb-70e0-a828-aa55a1228c4c | SKHY | 2026-09-16 15:51 | call_diagonal_spread | 2 | 1 | 100 | 133300.00 | long | ask | 174.3200 | 1.0000 | ["175","180"] | ["0.6301","0.6077"] | [] | ["ARCO"] | 175.0000 | 180.0000 | 9 | 16 | false | true | true | ||||||||||
| 01a0a170-82e9-7602-b907-09045102e8b7 | SKHY | 2026-09-14 15:41 | call_diagonal_spread | 2 | 1 | 10 | 109940.00 | long | ask | 175.8000 | 3.3000 | ["90","165"] | ["0.6191","0.5860"] | [] | ["XMIO"] | 90.0000 | 165.0000 | 32 | 276 | false | false | true | ||||||||||
| 01a09202-f4f8-7be1-afaf-c925afd7ec9e | SKHY | 2026-09-11 15:47 | call_diagonal_spread | 2 | 1 | 30 | 119790.00 | short | ask | 190.1700 | 2.4500 | ["170","172.5"] | ["16.1461","0.5529"] | [] | ["XMIO"] | 170.0000 | 172.5000 | 0 | 14 | false | false | true | ||||||||||
| 01a091c6-a390-7982-9d3d-f3be9017c1e6 | SKHY | 2026-09-11 14:41 | call_diagonal_spread | 2 | 1 | 50 | 125400.00 | short | ask | 190.8900 | 0.7500 | ["170","195"] | ["5.7494","0.5647"] | [] | ["XMIO"] | 170.0000 | 195.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a091a4-a858-7622-b449-ae63f1cb2f8c | SKHY | 2026-09-11 14:04 | call_diagonal_spread | 2 | 2 | 46 | 170660.00 | short | ask | 191.4500 | 1.3000 | ["170","190"] | ["0.5602","0.5976"] | [] | ["XISX"] | 170.0000 | 190.0000 | 7 | 35 | false | false | true | ||||||||||
| 01a08b86-fbd8-7471-ac9c-f87acdf1782a | SKHY | 2026-09-10 09:34 | call_diagonal_spread | 2 | 1 | 100 | 188400.00 | short | ask | 190.2785 | 1.5500 | ["180","190"] | ["0.9425","0.6889"] | [] | ["XCBO"] | 180.0000 | 190.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a087b0-f569-7f83-a898-a1dc50c98a57 | SKHY | 2026-09-09 15:41 | call_diagonal_spread | 2 | 4 | 38 | 145990.00 | short | ask | 199.0650 | 1.5500 | ["195","200"] | ["0.6853","0.6837"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 195.0000 | 200.0000 | 37 | 44 | false | false | true | ||||||||||
| 01a08783-aba9-7c52-817c-c60c3725720a | SKHY | 2026-09-09 14:52 | call_diagonal_spread | 2 | 1 | 50 | 259750.00 | short | ask | 198.5299 | 3.0000 | ["195","220"] | ["0.7069","0.6835"] | [] | ["XMIO"] | 195.0000 | 220.0000 | 72 | 128 | false | false | true | ||||||||||
| 01a0870f-6220-71c2-a27a-65df68c62129 | SKHY | 2026-09-09 12:45 | call_diagonal_spread | 2 | 1 | 10 | 133120.00 | short | ask | 194.0800 | 5.0500 | ["120","150"] | ["0.6653","0.6681"] | [] | ["XMIO"] | 120.0000 | 150.0000 | 100 | 128 | false | false | true | ||||||||||
| 01a08668-6808-7133-a046-d803044f62f3 | SKHY | 2026-09-09 09:43 | call_diagonal_spread | 2 | 1 | 67 | 166361.00 | long | ask | 191.9700 | 1.8500 | ["195","240"] | ["0.7059","0.7109"] | [] | ["ARCO"] | 195.0000 | 240.0000 | 9 | 128 | false | true | true | ||||||||||
| 01a081f3-81b8-71f1-8ccc-ac75f5b90759 | SKHY | 2026-09-08 12:56 | call_diagonal_spread | 2 | 1 | 30 | 138360.00 | long | ask | 186.5700 | 3.8500 | ["180","200"] | ["0.7094","0.7320"] | [] | ["XMIO"] | 180.0000 | 200.0000 | 45 | 101 | false | false | true | ||||||||||
| 01a081f2-f130-7d33-b90a-4e4cb1e3633c | SKHY | 2026-09-08 12:56 | call_diagonal_spread | 2 | 2 | 40 | 140920.00 | long | ask | 186.7300 | 1.5500 | ["170","175"] | ["0.8730","0.6787"] | [] | ["XMIO"] | 170.0000 | 175.0000 | 3 | 17 | false | false | true | ||||||||||
| 01a081db-0c00-7bb2-9a62-fbfef2920849 | SKHY | 2026-09-08 12:30 | call_diagonal_spread | 2 | 2 | 49 | 244405.00 | long | ask | 188.1350 | 1.5000 | ["250","390"] | ["0.7128","0.7854"] | [] | ["AMXO","ARCO"] | 250.0000 | 390.0000 | 129 | 500 | false | true | true | ||||||||||
| 01a081db-0c00-7bb2-9a62-fbe10e4f41f8 | SKHY | 2026-09-08 12:30 | call_diagonal_spread | 2 | 3 | 75 | 373378.00 | long | ask | 188.1350 | 1.8293 | ["250","390"] | ["0.7123","0.7828"] | [] | ["AMXO","ARCO","XBOX"] | 250.0000 | 390.0000 | 129 | 500 | false | true | true | ||||||||||
| 01a081cd-19b1-74e1-a92d-12683bcbb7cf | SKHY | 2026-09-08 12:14 | call_diagonal_spread | 2 | 1 | 80 | 321920.00 | long | ask | 188.9600 | 1.9000 | ["170","200"] | ["0.8785","0.7290"] | [] | ["XISX"] | 170.0000 | 200.0000 | 3 | 73 | false | false | true | ||||||||||
| 01a081b3-4080-7782-90b8-8f18b94c8991 | SKHY | 2026-09-08 11:46 | call_diagonal_spread | 2 | 1 | 100 | 216200.00 | short | ask | 189.6000 | 1.1500 | ["187.5","200"] | ["0.6790","0.6918"] | [] | ["ARCO"] | 187.5000 | 200.0000 | 17 | 24 | false | false | true | ||||||||||
| 01a08180-3a00-7ef1-b035-610960bf738d | SKHY | 2026-09-08 10:50 | call_diagonal_spread | 2 | 1 | 90 | 502740.00 | long | ask | 187.8400 | 2.3000 | ["165","185"] | ["0.8940","0.6871"] | [] | ["XCBO"] | 165.0000 | 185.0000 | 3 | 129 | false | false | true | ||||||||||
| 01a08158-cc40-7943-9d46-75b60cf6b644 | SKHY | 2026-09-08 10:07 | call_diagonal_spread | 2 | 1 | 141 | 357012.00 | short | ask | 186.6950 | 1.4500 | ["170","190"] | ["0.9041","0.7349"] | [] | ["BATO"] | 170.0000 | 190.0000 | 3 | 10 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:44: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-23T13:42:37Z"} |
| 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-22T17:46:29Z"} |
| 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-22T14:55:18Z"} |
| 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-22T13:41:37Z"} |
| 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-22T13:38:35Z"} |
| 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-22T13:38:35Z"} |
| 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-22T13:38:35Z"} |
| 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-22T13:38:14Z"} |
| 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-22T13:38:14Z"} |
| 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-22T13:37:53Z"} |
| 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-18T19:29:40Z"} |
| 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-18T19:25:34Z"} |
| 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-18T15:30:10Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:18:10Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:51:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:41:58Z"} |
| 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-11T19:48:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:42:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:05:16Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:34:44Z"} |
| 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-09T19:42:18Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:53:11Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:45:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:43:14Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:57:32Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:56:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:30:34Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:30:34Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:15:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:46:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:51:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:08:00Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |