core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d92a-1427-7a61-b31a-bb4ecbe346c5 | C | 2026-09-25 11:23 | risk_reversal | 2 | 1 | 200 | 234000.00 | long | bid | 133.3700 | 0.4000 | ["135","145"] | ["0.3129","0.2868"] | ["130.40"] | ["XBOX"] | 135.0000 | 145.0000 | 84 | 84 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T15:24:09Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d905-7cf7-72c0-8e21-dca2144f9550 | C | 2026-09-25 10:43 | put_calendar | 2 | 1 | 50 | 169300.00 | long | bid | 133.3400 | 0.9000 | ["140"] | ["0.3344"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 175 | 483 | false | false | true | ||||||||||
| 01a0d900-0a6e-7d82-9c19-08ae2feaffee | C | 2026-09-25 10:37 | put_vertical_spread | 2 | 2 | 605 | 153440.00 | unknown | bid | 133.2550 | 1.1850 | ["119","125"] | ["0.3620","0.3463"] | ["122.46"] | ["XCBO","XISX"] | 119.0000 | 125.0000 | 28 | 28 | false | true | |||||||||||
| 01a0d426-b917-7583-9ac3-90ac0d14b3a8 | C | 2026-09-24 12:01 | call_diagonal_spread | 2 | 1 | 45 | 262800.00 | short | bid | 130.9500 | 2.9500 | ["120","125"] | ["0.2982","0.2828"] | [] | ["XISX"] | 120.0000 | 125.0000 | 484 | 813 | false | false | |||||||||||
| 01a0cf51-bd1e-76a1-ab3d-77f7ef6c1de1 | C | 2026-09-23 13:30 | call_diagonal_spread | 2 | 1 | 194 | 281300.00 | short | bid | 132.6400 | 0.3000 | ["150","160"] | ["0.2933","0.2869"] | [] | ["XISX"] | 150.0000 | 160.0000 | 114 | 485 | false | true | |||||||||||
| 01a0cf4b-e8ef-75d1-aa9f-7f1083c2017c | C | 2026-09-23 13:24 | call_diagonal_spread | 2 | 1 | 200 | 290800.00 | short | bid | 132.7050 | 0.4000 | ["150","160"] | ["0.2926","0.2871"] | [] | ["XCBO"] | 150.0000 | 160.0000 | 114 | 485 | false | true | |||||||||||
| 01a0cf4b-3927-7d10-b898-46eaf3be52d6 | C | 2026-09-23 13:23 | call_diagonal_spread | 2 | 1 | 200 | 290000.00 | short | bid | 132.6700 | 0.2000 | ["150","160"] | ["0.2930","0.2867"] | [] | ["XISX"] | 150.0000 | 160.0000 | 114 | 485 | false | true | |||||||||||
| 01a0cefd-9627-7fd3-8a5f-b1c553af66ad | C | 2026-09-23 11:58 | call_diagonal_spread | 2 | 1 | 10 | 121880.00 | long | bid | 132.5550 | 2.3500 | ["75","80"] | ["0.4658","0.1853"] | [] | ["XISX"] | 75.0000 | 80.0000 | 485 | 849 | false | false | |||||||||||
| 01a0c433-af47-7933-baae-990ffa1dd02f | C | 2026-09-21 09:41 | call_calendar | 2 | 1 | 34 | 372980.00 | short | bid | 133.5800 | 4.4000 | ["80"] | ["0.4341"] | [] | ["XISX"] | 80.0000 | 80.0000 | 116 | 179 | false | false | true | ||||||||||
| 01a0b541-c497-75a0-8d85-8648d7695e44 | C | 2026-09-18 12:02 | call_calendar | 2 | 2 | 115 | 1446125.00 | short | bid | 132.1450 | 5.3500 | ["70"] | ["0.7051"] | [] | ["AMXO"] | 70.0000 | 70.0000 | 91 | 182 | false | false | true | ||||||||||
| 01a0b50d-a8bf-76d0-bf5d-a4c6fe08ca6c | C | 2026-09-18 11:06 | call_diagonal_spread | 2 | 1 | 376 | 231992.00 | short | bid | 132.2200 | 0.5300 | ["130","140"] | ["0.9107","0.2864"] | [] | ["ARCO"] | 130.0000 | 140.0000 | 0 | 63 | false | false | |||||||||||
| 01a0b4f1-f2ff-7d42-a734-bb6c70b0c540 | C | 2026-09-18 10:35 | call_diagonal_spread | 2 | 1 | 20 | 255600.00 | long | bid | 132.0950 | 4.9000 | ["67.5","70"] | ["0.8598","0.7201"] | [] | ["BATO"] | 67.5000 | 70.0000 | 91 | 119 | false | false | |||||||||||
| 01a0b02d-8d63-7b60-83ea-2caf6d7d4e78 | C | 2026-09-17 12:22 | call_calendar | 2 | 1 | 16 | 236272.00 | short | bid | 133.7700 | 5.3000 | ["60"] | ["0.3478"] | [] | ["XISX"] | 60.0000 | 60.0000 | 120 | 491 | false | false | true | ||||||||||
| 01a0afa8-5bbb-7571-948e-492f7f567f07 | C | 2026-09-17 09:57 | call_diagonal_spread | 2 | 1 | 1000 | 4633000.00 | long | bid | 131.2500 | 5.2500 | ["120","150"] | ["0.3172","0.2913"] | [] | ["XMIO"] | 120.0000 | 150.0000 | 365 | 820 | false | false | |||||||||||
| 01a0afa5-a854-7180-b632-56343b66e4e1 | C | 2026-09-17 09:54 | call_diagonal_spread | 2 | 1 | 1050 | 4195800.00 | long | bid | 131.5800 | 4.2500 | ["130","160"] | ["0.2957","0.2827"] | [] | ["XISX"] | 130.0000 | 160.0000 | 491 | 820 | false | false | |||||||||||
| 01a0af9d-4f9b-7610-8a4b-448680e635c5 | C | 2026-09-17 09:45 | call_diagonal_spread | 2 | 1 | 250 | 999000.00 | long | bid | 131.6500 | 4.3500 | ["130","160"] | ["0.2949","0.2823"] | [] | ["XISX"] | 130.0000 | 160.0000 | 491 | 820 | false | false | |||||||||||
| 01a0af9d-3444-7620-b008-4ab890f9e486 | C | 2026-09-17 09:45 | call_diagonal_spread | 2 | 1 | 170 | 453050.00 | long | bid | 131.5000 | 0.4000 | ["135","180"] | ["0.2980","0.2805"] | [] | ["XMIO"] | 135.0000 | 180.0000 | 273 | 855 | false | true | |||||||||||
| 01a0af9d-094b-7092-9a19-a1235862fd68 | C | 2026-09-17 09:44 | call_diagonal_spread | 2 | 1 | 200 | 816800.00 | long | bid | 131.7400 | 5.5000 | ["130","160"] | ["0.3016","0.2873"] | [] | ["XISX"] | 130.0000 | 160.0000 | 491 | 820 | false | false | |||||||||||
| 01a0aad9-5eeb-7c02-a1cb-1ca6f4648937 | C | 2026-09-16 11:32 | call_diagonal_spread | 2 | 2 | 76 | 139062.00 | short | bid | 135.2000 | 2.0316 | ["125","133"] | ["0.3128","0.4544"] | [] | ["BATO","XPHO"] | 125.0000 | 133.0000 | 2 | 93 | false | false | |||||||||||
| 01a0a5da-cd96-7690-8022-e8c9eaac0dd4 | C | 2026-09-15 12:16 | synthetic | 2 | 3 | 117 | 121680.00 | long | bid | 134.4600 | 0.1000 | ["135"] | ["0.3327"] | ["134.96"] | ["ARCO","EDGO"] | 135.0000 | 135.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0a5c2-09be-7ab2-9a40-85ca42194b20 | C | 2026-09-15 11:49 | put_vertical_spread | 2 | 1 | 150 | 105000.00 | short | bid | 134.6950 | 0.6200 | ["124","133"] | ["0.3371","0.3251"] | ["130.06"] | ["AMXO"] | 124.0000 | 133.0000 | 45 | 45 | false | true | |||||||||||
| 01a091be-79b8-79d1-afed-f379b443667a | C | 2026-09-11 14:32 | call_vertical_spread | 2 | 2 | 100 | 503200.00 | short | bid | 139.0150 | 1.4000 | ["140","160"] | ["0.2812","0.2812"] | ["147.98"] | ["ARCO","XISX"] | 140.0000 | 160.0000 | 826 | 826 | false | true | |||||||||||
| 01a091be-79b8-79d1-afed-f36b74b2d07c | C | 2026-09-11 14:32 | call_vertical_spread | 2 | 1 | 116 | 584640.00 | short | bid | 139.0150 | 1.7000 | ["140","160"] | ["0.2818","0.2815"] | ["148"] | ["XISX"] | 140.0000 | 160.0000 | 826 | 826 | false | true | |||||||||||
| 01a090d2-3d28-7073-8f5f-a5fec905b31a | C | 2026-09-11 10:14 | call_vertical_spread | 2 | 1 | 450 | 1989450.00 | short | bid | 138.3450 | 3.6500 | ["140","180"] | ["0.2848","0.2848"] | ["153.75"] | ["XISX"] | 140.0000 | 180.0000 | 826 | 826 | false | true | |||||||||||
| 01a090cc-5d40-7cf2-b1d7-d98b06dd07b8 | C | 2026-09-11 10:08 | call_vertical_spread | 2 | 1 | 350 | 1566250.00 | short | bid | 139.2883 | 3.5500 | ["140","180"] | ["0.2801","0.2831"] | ["153.75"] | ["XISX"] | 140.0000 | 180.0000 | 826 | 826 | false | true | |||||||||||
| 01a090cc-2a78-7782-8c53-8e2440bee3eb | C | 2026-09-11 10:08 | call_vertical_spread | 2 | 1 | 200 | 905000.00 | short | bid | 139.3000 | 6.1500 | ["140","180"] | ["0.2833","0.2861"] | ["153.75"] | ["XISX"] | 140.0000 | 180.0000 | 826 | 826 | false | true | |||||||||||
| 01a08728-e948-77a0-a552-ad916cf48d9d | C | 2026-09-09 13:13 | call_diagonal_spread | 2 | 1 | 400 | 1495600.00 | long | bid | 138.0009 | 2.2000 | ["140","175"] | ["0.2894","0.2822"] | [] | ["SPHR"] | 140.0000 | 175.0000 | 499 | 828 | false | true | |||||||||||
| 01a0865d-cd30-7981-b0ad-09f52006bfaf | C | 2026-09-09 09:31 | call_diagonal_spread | 2 | 1 | 500 | 127000.00 | short | bid | 134.9650 | 0.9100 | ["140","165"] | ["0.3275","0.2760"] | [] | ["XCBO"] | 140.0000 | 165.0000 | 9 | 128 | false | true | |||||||||||
| 01a08211-0850-7ba1-846b-044a573f5fdd | C | 2026-09-08 13:29 | put_diagonal_spread | 2 | 1 | 1001 | 1885884.00 | short | bid | 137.4850 | 1.5500 | ["100","120"] | ["0.3628","0.3554"] | [] | ["XMIO"] | 100.0000 | 120.0000 | 500 | 829 | false | true | |||||||||||
| 01a08162-a7b0-7d01-a9e8-6fa3e55d5599 | C | 2026-09-08 10:18 | call_vertical_spread | 2 | 1 | 61 | 264374.00 | short | bid | 136.3400 | 3.6500 | ["150","160"] | ["0.2853","0.2856"] | ["153.50"] | ["XISX"] | 150.0000 | 160.0000 | 829 | 829 | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:43:41Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:37:43Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:02:03Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:30:39Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:24:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:23:52Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:59:20Z"} |
| 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-21T13:42:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:03:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:06:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:36:04Z"} |
| 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-17T16:23:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:57:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:54:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:45:31Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:45:14Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:44:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:33:01Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:16:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:49:36Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:33:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:33:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:15:10Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:08:27Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:08:27Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:14:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:31:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:29:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:18:54Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |