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 |
|---|
| 01a0ce7e-6b77-73c1-8c9c-ee9ea5252e43 | AVGO | 2026-09-23 09:39 | call_vertical_spread | 2 | 1 | 110 | 100100.00 | short | bid | 357.7000 | 0.4000 | ["365","370"] | ["0.3652","0.3741"] | ["366.40"] | ["C2OX"] | 365.0000 | 370.0000 | 9 | 9 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T13:39:47Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0c97b-1837-71b3-bb8e-03b90bd1db4a | AVGO | 2026-09-22 10:18 | put_diagonal_spread | 2 | 1 | 10 | 136850.00 | long | ask | 362.5100 | 3.4000 | ["400","420"] | ["0.4485","0.4418"] | [] | ["C2OX"] | 400.0000 | 420.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c97a-398f-78d3-bb52-66e7d0696d7c | AVGO | 2026-09-22 10:17 | put_diagonal_spread | 2 | 1 | 10 | 151750.00 | short | bid | 362.2700 | 2.5000 | ["410","430"] | ["0.4513","0.4439"] | [] | ["XISX"] | 410.0000 | 430.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c588-3327-74f1-ad20-666ebe888a74 | AVGO | 2026-09-21 15:53 | call_vertical_spread | 2 | 1 | 20 | 125500.00 | short | bid | 363.6800 | 0.3250 | ["370","380"] | ["0.4174","0.4179"] | ["374.15"] | ["XISX"] | 370.0000 | 380.0000 | 116 | 116 | false | true | false | ||||||||||
| 01a0b0b6-494b-7173-ae21-bce15a63f724 | AVGO | 2026-09-17 14:52 | call_diagonal_spread | 2 | 2 | 24 | 110520.00 | long | ask | 348.0800 | 0.8000 | ["350","370"] | ["0.3964","0.3596"] | [] | ["C2OX"] | 350.0000 | 370.0000 | 64 | 120 | false | true | true | ||||||||||
| 01a0b079-1d23-7f22-9373-5324797f6534 | AVGO | 2026-09-17 13:45 | call_diagonal_spread | 2 | 1 | 8 | 150080.00 | unknown | — | 349.2400 | 1.6000 | ["290","300"] | ["0.4242","0.4186"] | [] | ["XISX"] | 290.0000 | 300.0000 | 273 | 491 | false | false | true | true | false | ||||||||
| 01a0b020-6a1b-78f1-b9da-9736bfc9b7e6 | AVGO | 2026-09-17 12:08 | put_vertical_spread | 2 | 1 | 24 | 135120.00 | unknown | — | 348.4700 | 0.7500 | ["340","350"] | ["0.4077","0.4078"] | [] | ["C2OX"] | 340.0000 | 350.0000 | 120 | 120 | false | false | false | true | false | ||||||||
| 01a0af8f-9fb3-7d72-a0b9-14c65d32e3c9 | AVGO | 2026-09-17 09:30 | put_vertical_spread | 2 | 1 | 80 | 706400.00 | long | ask | 346.0100 | 5.6500 | ["370","380"] | ["0.4102","0.4152"] | ["373"] | ["C2OX"] | 370.0000 | 380.0000 | 92 | 92 | false | false | false | ||||||||||
| 01a0a66d-97b5-7081-a2bd-c384b9bf44ea | AVGO | 2026-09-15 14:56 | risk_reversal | 2 | 1 | 26 | 161720.00 | short | bid | 340.4500 | 0.4500 | ["280","480"] | ["0.4351","0.4400"] | ["484.30"] | ["XISX"] | 280.0000 | 480.0000 | 458 | 458 | false | true | false | ||||||||||
| 01a0a62e-8b16-7883-84e6-3bb439c6c304 | AVGO | 2026-09-15 13:47 | call_diagonal_spread | 2 | 1 | 269 | 217890.00 | short | bid | 338.2300 | 0.1700 | ["365","385"] | ["0.3587","0.3743"] | [] | ["XISX"] | 365.0000 | 385.0000 | 24 | 38 | false | true | true | ||||||||||
| 01a0a611-5a6e-7c82-a301-490a4045a0d5 | AVGO | 2026-09-15 13:15 | put_calendar | 2 | 1 | 10 | 175550.00 | unknown | — | 338.1950 | 1.4000 | ["410"] | ["0.4324"] | [] | ["XISX"] | 410.0000 | 410.0000 | 122 | 367 | false | false | true | false | false | mesl | |||||||
| 01a0a067-4490-7b02-93fe-fcfc8d4c9852 | AVGO | 2026-09-14 10:51 | put_diagonal_spread | 2 | 1 | 19 | 118940.00 | unknown | — | 344.2800 | 1.5500 | ["350","375"] | ["0.4215","0.4329"] | [] | ["C2OX"] | 350.0000 | 375.0000 | 11 | 95 | false | false | true | true | false | ||||||||
| 01a0a056-8f38-7df0-abb2-812d4ec5b981 | AVGO | 2026-09-14 10:33 | put_vertical_spread | 2 | 1 | 10 | 109900.00 | unknown | — | 345.8000 | 1.7500 | ["350","420"] | ["0.4230","0.4471"] | [] | ["XISX"] | 350.0000 | 420.0000 | 95 | 95 | false | false | false | true | false | ||||||||
| 01a0a04a-9ca0-7082-8f98-2d8d1cd80ad6 | AVGO | 2026-09-14 10:20 | other | 4 | 1 | 57 | 112005.00 | unknown | — | 346.2300 | 1.6000 | ["335","340","345"] | ["0.3936","0.4070","0.4168"] | [] | ["C2OX"] | 335.0000 | 345.0000 | 4 | 11 | false | true | true | true | false | ||||||||
| 01a0a03e-e888-7392-8f6f-05326ea3b675 | AVGO | 2026-09-14 10:07 | put_vertical_spread | 2 | 1 | 100 | 503000.00 | unknown | — | 347.8410 | 0.8500 | ["330","340"] | ["0.4231","0.4219"] | [] | ["C2OX"] | 330.0000 | 340.0000 | 123 | 123 | false | true | false | true | false | ||||||||
| 01a090ec-f8e9-7213-b2dc-1f6a439f1f37 | AVGO | 2026-09-11 10:44 | call_vertical_spread | 2 | 1 | 10 | 123100.00 | unknown | — | 363.1605 | 2.9000 | ["400","450"] | ["0.4533","0.4547"] | [] | ["XISX"] | 400.0000 | 450.0000 | 497 | 497 | false | true | false | true | false | ||||||||
| 01a087b6-e4f0-72d2-88e0-13e32a23ad93 | AVGO | 2026-09-09 15:48 | call_vertical_spread | 2 | 1 | 25 | 200125.00 | long | ask | 364.3750 | 1.9500 | ["400","450"] | ["0.4497","0.4514"] | ["414.55"] | ["C2OX"] | 400.0000 | 450.0000 | 281 | 281 | false | true | false | ||||||||||
| 01a086f7-32b8-7870-986c-c377d06ecf37 | AVGO | 2026-09-09 12:19 | call_vertical_spread | 2 | 1 | 55 | 439450.00 | unknown | — | 359.5800 | 2.0000 | ["660","740"] | ["0.4790","0.4808"] | [] | ["C2OX"] | 660.0000 | 740.0000 | 828 | 828 | false | true | false | true | false | ||||||||
| 01a06d94-ec85-7ab2-b0de-70faba98461e | AVGO | 2026-09-04 14:01 | call_diagonal_spread_bearish | 2 | 2 | 5 | 118325.00 | short | bid | 354.6500 | 2.9500 | ["240","250"] | ["0.8478","0.4267"] | [] | ["C2OX"] | 240.0000 | 250.0000 | 14 | 286 | false | false | true | ||||||||||
| 01a06d8e-4d35-7a51-9496-455f41f622c7 | AVGO | 2026-09-04 13:53 | call_vertical_spread | 2 | 1 | 100 | 101500.00 | short | bid | 354.4750 | 0.5000 | ["500","510"] | ["0.4337","0.4362"] | ["500.65"] | ["XISX"] | 500.0000 | 510.0000 | 133 | 133 | false | true | false | ||||||||||
| 01a06d84-69f5-7313-acca-ddbf2099df6c | AVGO | 2026-09-04 13:43 | other | 2 | 2 | 12 | 113160.00 | unknown | — | 355.1832 | 2.9500 | ["300","320"] | ["0.3420","0.3922"] | [] | ["XCBO"] | 300.0000 | 320.0000 | 14 | 42 | false | false | true | true | false | mesl | |||||||
| 01a06d82-eb25-70d2-8983-8c5b4399cb66 | AVGO | 2026-09-04 13:41 | call_diagonal_spread_bullish | 2 | 2 | 12 | 107940.00 | short | bid | 355.3118 | 1.9500 | ["300","325"] | ["0.3474","0.3756"] | [] | ["XCBO"] | 300.0000 | 325.0000 | 14 | 42 | false | false | true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:18:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:17:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:54:04Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:52:35Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:45:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:08:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:30:17Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:56:47Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:47:55Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:16:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:52:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:33:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:20:54Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:07:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:44:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:48:40Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:19:37Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:01:15Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:54:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:41:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |