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 |
|---|
| 01a0e958-d707-7ff3-9faa-1c5dfd0b6085 | SKHY | 2026-09-28 14:48 | call_calendar | 2 | 1 | 29 | 104255.00 | short | ask | 182.2300 | 0.7500 | ["195"] | ["0.6039"] | [] | ["XPHO"] | 195.0000 | 195.0000 | 81 | 109 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T18:48:48Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0d8df-a577-7112-bb96-0277e8469812 | SKHY | 2026-09-25 10:02 | call_calendar | 2 | 2 | 57 | 221644.00 | short | ask | 190.9300 | 6.2500 | ["172.5"] | ["1.8957"] | [] | ["EDGO","XCBO"] | 172.5000 | 172.5000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d8df-a577-7112-bb96-02645cef21b3 | SKHY | 2026-09-25 10:02 | call_calendar | 2 | 1 | 28 | 108864.00 | short | ask | 190.9300 | 6.2500 | ["172.5"] | ["1.8953"] | [] | ["BATO"] | 172.5000 | 172.5000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0ce82-110f-7092-91fe-a548db984b7f | SKHY | 2026-09-23 09:43 | call_calendar | 2 | 1 | 10 | 120780.00 | short | ask | 190.5000 | 6.6500 | ["240"] | ["0.6669"] | [] | ["XMIO"] | 240.0000 | 240.0000 | 632 | 814 | false | true | true | false | |||||||||
| 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 | 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 | ||||||||||
| 01a0b517-7877-7453-9ffd-a6b84236fa69 | SKHY | 2026-09-18 11:16 | call_calendar | 2 | 1 | 100 | 325400.00 | short | ask | 183.2250 | 0.7000 | ["170"] | ["1.0548"] | [] | ["XISX"] | 170.0000 | 170.0000 | 0 | 28 | false | false | true | false | |||||||||
| 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 | true | |||||||||
| 01a0aabc-8c03-73a0-9f5c-f20439a8e7ee | SKHY | 2026-09-16 11:01 | risk_reversal | 2 | 3 | 750 | 102500.00 | short | ask | 179.4450 | 0.0600 | ["170","197.5"] | ["0.8357","0.7911"] | ["169.11"] | ["AMXO","XCBO","XISX"] | 170.0000 | 197.5000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0aabc-6cc3-7a40-83bd-1ac31be51df3 | SKHY | 2026-09-16 11:01 | risk_reversal | 2 | 4 | 751 | 102658.00 | short | ask | 179.3400 | 0.0600 | ["170","197.5"] | ["0.8283","0.7997"] | ["169.12"] | ["AMXO","C2OX","XCBO","XISX"] | 170.0000 | 197.5000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0aabc-228b-72b3-a020-22e2df520520 | SKHY | 2026-09-16 11:00 | risk_reversal | 2 | 7 | 1000 | 135992.00 | short | ask | 179.2850 | 0.0263 | ["170","197.5"] | ["0.8202","0.8094"] | ["169.15"] | ["AMXO","C2OX","XCBO","XISX"] | 170.0000 | 197.5000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0a626-cab6-7b61-b452-6b674b753371 | SKHY | 2026-09-15 13:39 | risk_reversal | 2 | 5 | 916 | 155884.00 | short | ask | 173.7000 | 0.1525 | ["165","192.5"] | ["0.7208","0.7467"] | ["164.00"] | ["AMXO","C2OX","XCBO","XISX"] | 165.0000 | 192.5000 | 3 | 3 | false | true | false | true | |||||||||
| 01a0a044-7280-7bc0-b333-0ccede13175f | SKHY | 2026-09-14 10:13 | call_calendar | 2 | 1 | 55 | 153945.00 | short | ask | 179.1650 | 1.4000 | ["170"] | ["0.6781"] | [] | ["MCRY"] | 170.0000 | 170.0000 | 4 | 25 | false | false | true | false | |||||||||
| 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 | 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 | 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 | 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 | 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 | 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 | true | |||||||||
| 01a08707-4fb8-7311-92b7-814917d978f6 | SKHY | 2026-09-09 12:36 | call_calendar | 2 | 1 | 10 | 207720.00 | short | ask | 193.6400 | 8.2500 | ["90"] | ["1.5419"] | [] | ["EDGO"] | 90.0000 | 90.0000 | 9 | 23 | false | false | true | false | |||||||||
| 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 | true | |||||||||
| 01a08184-8790-7913-9c1b-64f716a8cce0 | SKHY | 2026-09-08 10:55 | put_calendar | 2 | 5 | 118 | 106866.00 | short | ask | 187.5600 | 0.6700 | ["120"] | ["0.6788"] | [] | ["AMXO","ARCO","XBOX","XMIO","XPHO"] | 120.0000 | 120.0000 | 101 | 192 | false | true | true | false | |||||||||
| 01a08184-8790-7913-9c1b-64e3987ed0a0 | SKHY | 2026-09-08 10:55 | put_calendar | 2 | 6 | 140 | 126864.00 | short | ask | 187.5600 | 0.6621 | ["120"] | ["0.6790"] | [] | ["AMXO","ARCO","EMLD","XBOX","XMIO","XPHO"] | 120.0000 | 120.0000 | 101 | 192 | false | true | true | false | |||||||||
| 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 | true | |||||||||
| 01a08144-7538-7f70-97e5-337928b937df | SKHY | 2026-09-08 09:45 | risk_reversal | 2 | 1 | 18 | 151218.00 | short | ask | 185.5400 | 0.5000 | ["205","235"] | ["0.6913","0.6927"] | ["182.51"] | ["XCBO"] | 205.0000 | 235.0000 | 282 | 282 | false | false | false | true | |||||||||
| 01a06d4b-c9dd-7ca0-beb7-3baea1bbf2c1 | SKHY | 2026-09-04 12:41 | call_diagonal_spread_bearish | 2 | 3 | 328 | 782204.00 | short | ask | 172.0300 | 1.1500 | ["180","200"] | ["0.6178","0.6519"] | [] | ["EDGO","XCBO","XISX"] | 180.0000 | 200.0000 | 49 | 77 | false | true | true | ||||||||||
| 01a06d26-3c95-7a23-9725-903bc372e8d2 | SKHY | 2026-09-04 12:00 | call_diagonal_spread_bearish | 2 | 1 | 30 | 298920.00 | short | ask | 170.9150 | 8.4500 | ["119","130"] | ["12.0899","0.5819"] | [] | ["SPHR"] | 119.0000 | 130.0000 | 0 | 133 | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:02:14Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:02:14Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:44:01Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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-18T19:29:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:16:56Z"} |
| 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-17T16:18:10Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:01:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:01:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:00:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:40:08Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:13:56Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:37:18Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:55:39Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:55:39Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:46:00Z"} |
| 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-04T16:41:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:00:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |