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_side |
|---|
| 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 |
|---|
| 01a06d84-2f5d-7561-8492-2b7915fde7bc | SMCI | 2026-09-04 13:42 | call_diagonal_spread_bearish | 2 | 1 | 1000 | 867000.00 | short | ask | 40.7600 | 0.4500 | ["36","37"] | ["4.3101","0.5829"] | [] | ["XMIO"] | 36.0000 | 37.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:43:01Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d91-eee5-79c3-b86d-1e019d4c1eaa | SMCI | 2026-09-04 13:57 | call_calendar | 2 | 1 | 946 | 246906.00 | short | bid | 40.7222 | 0.1500 | ["40"] | ["0.6733"] | [] | ["BATO"] | 40.0000 | 40.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06dbf-b98d-7180-873f-b66db261ac99 | SMCI | 2026-09-04 14:47 | call_calendar | 2 | 1 | 1000 | 447000.00 | short | bid | 39.9300 | 0.2000 | ["38"] | ["1.1434"] | [] | ["XISX"] | 38.0000 | 38.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a08152-dcb8-7221-8bf4-14eaa581828a | SMCI | 2026-09-08 10:01 | put_calendar | 2 | 1 | 135 | 184950.00 | short | bid | 40.7900 | 0.6500 | ["40"] | ["0.7918"] | [] | ["BATO"] | 40.0000 | 40.0000 | 101 | 164 | false | true | true | false | |||||||||
| 01a08179-2198-7952-af5f-30edbc34341c | SMCI | 2026-09-08 10:43 | synthetic | 2 | 1 | 50 | 126206.00 | short | ask | 40.9402 | 1.0500 | ["50"] | ["0.7968"] | ["42.54"] | ["XCBO"] | 50.0000 | 50.0000 | 282 | 282 | false | false | false | false | |||||||||
| 01a0825e-bed8-7e82-bc29-722def1d94e5 | SMCI | 2026-09-08 14:54 | put_diagonal_spread | 2 | 1 | 600 | 227400.00 | short | bid | 40.5569 | 0.1700 | ["35","40"] | ["0.7940","0.7398"] | [] | ["XBOX"] | 35.0000 | 40.0000 | 10 | 38 | false | true | true | true | |||||||||
| 01a08bbc-7358-7e53-9590-63425c90096b | SMCI | 2026-09-10 10:32 | call_vertical_spread | 2 | 1 | 70 | 110460.00 | short | bid | 38.8950 | 0.3500 | ["27","37"] | ["0.8132","0.7101"] | ["35.30"] | ["XMIO"] | 27.0000 | 37.0000 | 22 | 22 | false | false | false | true | |||||||||
| 01a090e1-0650-7ef3-9a8c-90c00802583c | SMCI | 2026-09-11 10:30 | call_vertical_spread | 2 | 1 | 1000 | 1158000.00 | short | bid | 40.2870 | 0.4500 | ["40","45"] | ["0.7709","0.7809"] | ["41.80"] | ["SPHR"] | 40.0000 | 45.0000 | 98 | 98 | false | false | false | true | |||||||||
| 01a0afa5-0c14-7961-a440-80277891d9b9 | SMCI | 2026-09-17 09:53 | call_vertical_spread | 2 | 4 | 145 | 163937.00 | short | bid | 39.1000 | 0.4000 | ["37","39"] | ["0.7729","0.7671"] | ["37.99"] | ["AMXO","ARCO","XCBO","XISX"] | 37.0000 | 39.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0afa5-0c14-7961-a440-7f9df76f3ecb | SMCI | 2026-09-17 09:53 | call_vertical_spread | 2 | 5 | 323 | 365097.00 | short | bid | 39.1000 | 0.4000 | ["37","39"] | ["0.7727","0.7669"] | ["37.99"] | ["AMXO","ARCO","EDGO","XCBO","XISX"] | 37.0000 | 39.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0afa5-0c14-7961-a440-7f14ab4bb0b5 | SMCI | 2026-09-17 09:53 | call_vertical_spread | 2 | 4 | 269 | 304023.00 | short | bid | 39.0850 | 0.4000 | ["37","39"] | ["0.7742","0.7681"] | ["37.99"] | ["ARCO","EDGO","XCBO","XISX"] | 37.0000 | 39.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0afa5-082b-7222-8b67-8a553e665dab | SMCI | 2026-09-17 09:53 | call_vertical_spread | 2 | 2 | 161 | 181737.00 | short | bid | 39.0850 | 0.4000 | ["37","39"] | ["0.7727","0.7674"] | ["37.99"] | ["ARCO","XISX"] | 37.0000 | 39.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0b00d-8a13-7d93-af40-af0f800c14bd | SMCI | 2026-09-17 11:47 | call_diagonal_spread | 2 | 1 | 120 | 196680.00 | short | bid | 40.1200 | 0.6500 | ["45","47"] | ["0.7897","0.7952"] | [] | ["SPHR"] | 45.0000 | 47.0000 | 183 | 273 | false | true | true | true | |||||||||
| 01a0b064-6c43-79c2-9968-c6bfa062e955 | SMCI | 2026-09-17 13:22 | put_calendar | 2 | 1 | 50 | 222400.00 | short | ask | 40.6550 | 1.4000 | ["50"] | ["0.8143"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 820 | 855 | false | false | true | false | |||||||||
| 01a0b076-fa44-7d40-baa5-1d2e7bd65f0e | SMCI | 2026-09-17 13:43 | call_calendar | 2 | 1 | 134 | 194032.00 | short | bid | 40.6950 | 0.3500 | ["40"] | ["0.7781"] | [] | ["XMIO"] | 40.0000 | 40.0000 | 92 | 120 | false | false | true | false | |||||||||
| 01a0b077-c17a-77c1-b75f-9cfefd517607 | SMCI | 2026-09-17 13:43 | call_calendar | 2 | 1 | 100 | 105800.00 | short | ask | 40.7100 | 0.3500 | ["45"] | ["0.7738"] | [] | ["XMIO"] | 45.0000 | 45.0000 | 92 | 120 | false | true | true | false | |||||||||
| 01a0b4d6-0e60-7bd3-b37a-a130bbcea022 | SMCI | 2026-09-18 10:05 | call_calendar | 2 | 1 | 45 | 260190.00 | short | bid | 38.9000 | 0.4500 | ["10"] | ["14.0918"] | [] | ["XCBO"] | 10.0000 | 10.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b4e6-1bc0-7633-bc65-ab364a65a472 | SMCI | 2026-09-18 10:22 | call_diagonal_spread | 2 | 1 | 3000 | 1668000.00 | short | bid | 38.6655 | 0.3500 | ["36","37"] | ["1.8931","0.6533"] | [] | ["AMXO"] | 36.0000 | 37.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a0b53f-ad6f-7d31-9f9a-85b9cbedd191 | SMCI | 2026-09-18 12:00 | put_vertical_spread | 2 | 1 | 150 | 105300.00 | short | bid | 38.7451 | 0.2500 | ["34","35"] | ["0.7656","0.7627"] | ["34.58"] | ["XMIO"] | 34.0000 | 35.0000 | 91 | 91 | false | true | false | true | |||||||||
| 01a0b5fd-d520-7451-9c3a-5bf05322e8a4 | SMCI | 2026-09-18 15:28 | call_calendar | 2 | 1 | 400 | 104800.00 | short | bid | 38.8200 | 0.1400 | ["38"] | ["1.1405"] | [] | ["XCBO"] | 38.0000 | 38.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0c429-0bcb-7f33-b5c6-127b66b1718c | SMCI | 2026-09-21 09:30 | call_vertical_spread | 2 | 1 | 50 | 199450.00 | short | bid | 40.6300 | 1.3500 | ["20","22"] | ["0.9407","0.9222"] | ["21.89"] | ["XCBO"] | 20.0000 | 22.0000 | 60 | 60 | false | false | false | true | |||||||||
| 01a0c442-6cb7-78d0-8287-ced845947aa7 | SMCI | 2026-09-21 09:58 | call_calendar | 2 | 1 | 50 | 335650.00 | short | ask | 41.1600 | 1.0500 | ["8"] | ["1.1541"] | [] | ["XMIO"] | 8.0000 | 8.0000 | 179 | 269 | false | false | true | false | |||||||||
| 01a0ca8c-e20f-7f22-8d3e-fc79e1802cad | SMCI | 2026-09-22 15:17 | call_vertical_spread | 2 | 1 | 47 | 126947.00 | short | bid | 41.7350 | 0.3500 | ["25","38"] | ["0.8053","0.7673"] | ["33.85"] | ["XCBO"] | 25.0000 | 38.0000 | 115 | 115 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:57:53Z"} |
| 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-04T18:48:13Z"} |
| 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-08T14:01:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:43:19Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:54:21Z"} |
| 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-10T14:33:25Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:31:23Z"} |
| 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-17T13:53:42Z"} |
| 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-17T13:53:42Z"} |
| 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-17T13:53:42Z"} |
| 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-17T13:53:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:47:58Z"} |
| 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-17T17:23:17Z"} |
| 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-17T17:43:37Z"} |
| 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-17T17:44:31Z"} |
| 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-18T14:05:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:23:00Z"} |
| 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:01:05Z"} |
| 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-18T19:28:25Z"} |
| 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-21T13:30:06Z"} |
| 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-21T13:58:09Z"} |
| 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-22T19:17:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |