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 |
|---|
| 01a0ca9e-db9f-7a30-b13f-db3493094d1e | SHOP | 2026-09-22 15:36 | put_diagonal_spread | 2 | 2 | 24 | 100712.00 | unknown | bid | 148.9100 | 3.4000 | ["160","180"] | ["0.6029","0.5345"] | [] | ["XISX"] | 160.0000 | 180.0000 | 38 | 59 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:36:51Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca7c-a5cf-7e92-aa08-1322bdc6e4a0 | SHOP | 2026-09-22 14:59 | call_vertical_spread | 2 | 1 | 10 | 140000.00 | short | bid | 147.7000 | 2.1000 | ["90","140"] | ["0.6152","0.5952"] | ["112.80"] | ["XISX"] | 90.0000 | 140.0000 | 815 | 815 | false | false | false | true | |||||||||
| 01a0c95a-4daf-7640-8f6d-f490f4a5f03e | SHOP | 2026-09-22 09:42 | call_diagonal_spread | 2 | 2 | 74 | 127650.00 | short | bid | 148.1950 | 1.4500 | ["141","150"] | ["0.7261","0.5445"] | [] | ["C2OX","EDGO"] | 141.0000 | 150.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0c94f-33d8-7193-b0b9-a56f4b0d24a7 | SHOP | 2026-09-22 09:30 | other | 5 | 2 | 84 | 131718.00 | unknown | bid | 144.3700 | 9.0000 | ["136","143","144","145","160"] | ["0.5649","0.6284","0.5287","0.6741","0.5745"] | [] | ["XISX"] | 136.0000 | 160.0000 | 10 | 38 | false | false | true | true | |||||||||
| 01a0c57a-9e97-7be2-97e8-3a2d4ae6368a | SHOP | 2026-09-21 15:38 | call_diagonal_spread | 2 | 2 | 98 | 204232.00 | unknown | bid | 137.5700 | 0.7000 | ["137","145"] | ["0.5061","0.5808"] | [] | ["C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | false | true | true | |||||||||
| 01a0c57a-7f56-7232-b230-d5bbbda8a05a | SHOP | 2026-09-21 15:38 | call_diagonal_spread | 2 | 1 | 100 | 206400.00 | unknown | bid | 137.4050 | 0.7000 | ["137","145"] | ["0.5054","0.5801"] | [] | ["C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | false | true | true | |||||||||
| 01a0c578-5c77-72a1-92b8-60d5362a238b | SHOP | 2026-09-21 15:36 | call_diagonal_spread | 2 | 1 | 100 | 203200.00 | short | bid | 137.1184 | 1.2000 | ["137","145"] | ["0.5050","0.5795"] | [] | ["C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | false | true | true | |||||||||
| 01a0c578-5c77-72a1-92b8-60cf4cc1c0a5 | SHOP | 2026-09-21 15:36 | call_diagonal_spread | 2 | 1 | 100 | 203200.00 | short | bid | 137.1850 | 1.2000 | ["137","145"] | ["0.5025","0.5782"] | [] | ["C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | false | true | true | |||||||||
| 01a0c558-7867-7ad3-9599-aca679136266 | SHOP | 2026-09-21 15:01 | call_backspread | 2 | 1 | 500 | 168558.00 | long | bid | 136.2800 | 0.5000 | ["135","143"] | ["0.5953","0.6447"] | ["136.42","149.58"] | ["EDGO"] | 135.0000 | 143.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c524-dd77-7282-bfef-bcea56e750c9 | SHOP | 2026-09-21 14:05 | risk_reversal | 2 | 5 | 315 | 181377.00 | long | bid | 134.5100 | 0.5700 | ["125","150"] | ["0.5192","0.5380"] | ["124.43"] | ["ARCO","C2OX","EMLD","XBOX","XISX"] | 125.0000 | 150.0000 | 25 | 25 | false | true | false | true | |||||||||
| 01a0c4be-8e0f-7353-ab1c-a1b9afeda11a | SHOP | 2026-09-21 12:13 | call_calendar | 2 | 1 | 55 | 280445.00 | short | bid | 130.6800 | 3.8000 | ["160"] | ["0.5523"] | [] | ["AMXO"] | 160.0000 | 160.0000 | 452 | 487 | false | true | true | false | |||||||||
| 01a0b5b6-4c9f-73c0-b4e0-786a0dd5b83a | SHOP | 2026-09-18 14:10 | put_calendar | 2 | 1 | 20 | 110440.00 | long | bid | 127.1700 | 2.2000 | ["150"] | ["0.5743"] | [] | ["BATO"] | 150.0000 | 150.0000 | 63 | 91 | false | false | true | false | |||||||||
| 01a0b59f-f5e0-7413-8c5c-c977cd3fa134 | SHOP | 2026-09-18 13:45 | call_diagonal_spread | 2 | 1 | 23 | 178480.00 | short | bid | 127.3350 | 5.2000 | ["90","155"] | ["11.6076","0.5801"] | [] | ["ARCO"] | 90.0000 | 155.0000 | 0 | 854 | false | false | true | true | |||||||||
| 01a0b59c-ae07-7720-9c2a-03d3437a30bb | SHOP | 2026-09-18 13:42 | call_diagonal_spread | 2 | 1 | 10 | 104250.00 | unknown | bid | 127.2911 | 4.3000 | ["75","80"] | ["16.7892","0.6052"] | [] | ["ARCO"] | 75.0000 | 80.0000 | 0 | 182 | false | false | true | true | |||||||||
| 01a0a585-6e1e-7061-ba3e-b191e2ee2768 | SHOP | 2026-09-15 10:42 | put_diagonal_spread | 2 | 1 | 60 | 207120.00 | short | bid | 130.7500 | 1.5500 | ["142","145"] | ["0.5375","0.5889"] | [] | ["BATO"] | 142.0000 | 145.0000 | 17 | 66 | false | false | true | true | |||||||||
| 01a0a181-0579-79c0-88ac-5c77705da8c9 | SHOP | 2026-09-14 15:59 | call_vertical_spread | 2 | 2 | 88 | 339504.00 | short | bid | 133.8200 | 5.4500 | ["110","120"] | ["1.1568","0.8189"] | ["119.80"] | ["SPHR","XMIO"] | 110.0000 | 120.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a08c36-d378-7861-87d4-b09d7e34cc3b | SHOP | 2026-09-10 12:46 | put_diagonal_spread | 2 | 2 | 60 | 133170.00 | short | bid | 126.6900 | 3.0500 | ["80","85"] | ["0.5917","0.5803"] | [] | ["EDGO","XISX"] | 80.0000 | 85.0000 | 463 | 827 | false | true | true | true | |||||||||
| 01a08c0c-b639-7ba3-8c81-23a9a72c9566 | SHOP | 2026-09-10 12:00 | call_diagonal_spread | 2 | 1 | 25 | 183475.00 | short | bid | 126.8350 | 2.6000 | ["120","130"] | ["0.5825","0.5819"] | [] | ["ARCO"] | 120.0000 | 130.0000 | 463 | 498 | false | false | true | true | |||||||||
| 01a0872e-f040-7dd1-8991-201fe3053d59 | SHOP | 2026-09-09 13:19 | call_frontspread | 2 | 1 | 70 | 195200.00 | long | bid | 129.5350 | 1.2000 | ["125","130"] | ["0.5972","0.5972"] | ["125.08","159.54"] | ["XCBO"] | 125.0000 | 130.0000 | 72 | 72 | false | false | false | true | |||||||||
| 01a081dc-86e9-7a91-b9f8-a5f37eed4674 | SHOP | 2026-09-08 12:31 | call_frontspread | 2 | 1 | 45 | 167890.00 | long | bid | 134.5200 | 1.9000 | ["125","130"] | ["0.5581","0.5589"] | ["125.28","167.76"] | ["XMIO"] | 125.0000 | 130.0000 | 101 | 101 | false | false | false | true | |||||||||
| 01a06dd1-c6a5-7233-9cc2-964a3df16e06 | SHOP | 2026-09-04 15:07 | call_calendar | 2 | 1 | 45 | 144720.00 | short | bid | 145.3700 | 3.5000 | ["130"] | ["4.6948"] | [] | ["XMIO"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06dca-b60d-7461-81e0-3678ac42bcfb | SHOP | 2026-09-04 14:59 | call_calendar | 2 | 1 | 45 | 233550.00 | short | bid | 145.3300 | 5.7000 | ["120"] | ["6.7653"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06d8d-189d-7523-90a1-cf8ec1b7634f | SHOP | 2026-09-04 13:52 | call_vertical_spread | 2 | 1 | 32 | 117280.00 | short | bid | 145.9650 | 2.0000 | ["165","200"] | ["0.5494","0.5432"] | ["174.27"] | ["AMXO"] | 165.0000 | 200.0000 | 286 | 286 | false | true | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:59:44Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:42:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:39:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:39:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:36:46Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:36:46Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:01:54Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:05:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:13:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:10:48Z"} |
| 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-18T17:46:22Z"} |
| 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-18T17:42:21Z"} |
| 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-15T14:43:10Z"} |
| 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-14T19:59:58Z"} |
| 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-10T16:46:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:00:56Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:20:12Z"} |
| 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-08T16:32:13Z"} |
| 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-04T19:07:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:00:17Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:53:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |