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 | 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 |
|---|
| 01a06d22-c9c5-7660-8a36-865818ebd6a3 | AVGO | 2026-09-04 11:56 | call_diagonal_spread_bearish | 2 | 1 | 275 | 62425.00 | long | bid | 356.0550 | 0.1700 | ["450","520"] | ["0.4114","0.4385"] | [] | ["XCBO"] | 450.0000 | 520.0000 | 42 | 77 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:56:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d43-78f5-7400-b270-42f6be05eaf3 | AVGO | 2026-09-04 12:32 | call_diagonal_spread_bearish | 2 | 1 | 25 | 45150.00 | short | ask | 355.2400 | 0.7000 | ["360","370"] | ["0.3432","0.3500"] | [] | ["XMIO"] | 360.0000 | 370.0000 | 21 | 28 | false | true | true | ||||||||||
| 01a06d4c-4ac5-7c40-94bc-563cebecae7d | AVGO | 2026-09-04 12:41 | call_diagonal_spread_bearish | 2 | 1 | 15 | 91185.00 | short | bid | 355.1300 | 0.8000 | ["370","440"] | ["0.4043","0.4334"] | [] | ["XCBO"] | 370.0000 | 440.0000 | 133 | 286 | false | true | true | ||||||||||
| 01a06d57-2035-7ad1-8589-10729a3a6622 | AVGO | 2026-09-04 12:53 | call_diagonal_spread_bearish | 2 | 2 | 48 | 49440.00 | short | bid | 356.5200 | 0.3500 | ["352.5","355"] | ["0.4923","0.3133"] | [] | ["C2OX","EDGO"] | 352.5000 | 355.0000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d57-2035-7ad1-8589-106f833d417c | AVGO | 2026-09-04 12:53 | call_diagonal_spread_bearish | 2 | 3 | 27 | 27892.00 | short | bid | 356.5200 | 0.4000 | ["352.5","355"] | ["0.5032","0.3142"] | [] | ["ARCO","EMLD","XBOX"] | 352.5000 | 355.0000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d67-682d-74d1-b6b6-d4dbda8bd786 | AVGO | 2026-09-04 13:11 | call_diagonal_spread_bearish | 2 | 5 | 35 | 30454.00 | long | ask | 355.5250 | 0.5314 | ["352.5","355"] | ["0.4286","0.3092"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 352.5000 | 355.0000 | 0 | 5 | false | false | |||||||||||
| 01a06d78-2d25-7ce0-b6d3-02af8e43e629 | AVGO | 2026-09-04 13:29 | call_diagonal_spread_bearish | 2 | 8 | 45 | 34947.00 | long | ask | 354.8150 | 0.4000 | ["352.5","355"] | ["0.4965","0.3065"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 352.5000 | 355.0000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d78-2d25-7ce0-b6d3-0294d8c565c8 | AVGO | 2026-09-04 13:29 | call_diagonal_spread_bearish | 2 | 4 | 72 | 55912.00 | long | ask | 354.8150 | 0.4000 | ["352.5","355"] | ["0.4964","0.3065"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 352.5000 | 355.0000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d7a-5fa5-79e1-be8c-da52ce3ec1c6 | AVGO | 2026-09-04 13:32 | call_diagonal_spread_bearish | 2 | 4 | 72 | 51150.00 | long | ask | 354.2100 | 0.4500 | ["352.5","355"] | ["0.4927","0.3132"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 352.5000 | 355.0000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d8b-bcf5-7713-a8c0-e80e650d255c | AVGO | 2026-09-04 13:51 | call_diagonal_spread_bearish | 2 | 1 | 103 | 84254.00 | short | bid | 354.7618 | 0.2164 | ["362.5","365"] | ["0.3153","0.3541"] | [] | ["XISX"] | 362.5000 | 365.0000 | 5 | 14 | false | true | true | ||||||||||
| 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 | ||||||||||
| 01a06d99-1306-7a23-8a0c-121622d5d14b | AVGO | 2026-09-04 14:05 | call_diagonal_spread_bearish | 2 | 1 | 131 | 133358.00 | long | bid | 355.0600 | 0.5500 | ["367.5","375"] | ["0.3524","0.3543"] | [] | ["XCBO"] | 367.5000 | 375.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d99-d655-75e1-b531-7afbddf482a4 | AVGO | 2026-09-04 14:06 | call_diagonal_spread_bearish | 2 | 4 | 72 | 56226.00 | short | bid | 355.0100 | 0.6800 | ["352.5","355"] | ["0.5187","0.2982"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 352.5000 | 355.0000 | 0 | 5 | false | false | |||||||||||
| 01a06da8-16c5-73f3-baeb-9a8a1a717acd | AVGO | 2026-09-04 14:22 | call_diagonal_spread_bearish | 2 | 5 | 53 | 51413.00 | long | ask | 356.3900 | 0.3500 | ["352.5","355"] | ["0.5405","0.2949"] | [] | ["ARCO","BATO","C2OX","EDGO","XBOX"] | 352.5000 | 355.0000 | 0 | 5 | false | false | |||||||||||
| 01a06da8-1e95-78f3-80ea-dc7e9852c9c3 | AVGO | 2026-09-04 14:22 | call_diagonal_spread_bearish | 2 | 2 | 36 | 34812.00 | short | bid | 356.3450 | 0.4500 | ["352.5","355"] | ["0.5840","0.2955"] | [] | ["EMLD","SPHR"] | 352.5000 | 355.0000 | 0 | 5 | false | false | true | ||||||||||
| 01a06db5-0f15-7821-9911-67640b24691d | AVGO | 2026-09-04 14:36 | call_diagonal_spread_bearish | 2 | 1 | 20 | 405040.00 | long | bid | 356.4750 | 3.5500 | ["280","380"] | ["0.4357","0.4484"] | [] | ["XMIO"] | 280.0000 | 380.0000 | 469 | 651 | false | false | true | ||||||||||
| 01a06dc7-f305-7e52-8806-247ca5fb794b | AVGO | 2026-09-04 14:56 | call_diagonal_spread_bearish | 2 | 1 | 49 | 41013.00 | long | ask | 356.8800 | 0.6500 | ["365","380"] | ["0.3543","0.3609"] | [] | ["XMIO"] | 365.0000 | 380.0000 | 7 | 21 | false | true | true | ||||||||||
| 01a06dda-36cd-7a70-a5a9-97940ee1e903 | AVGO | 2026-09-04 15:16 | call_diagonal_spread_bearish | 2 | 1 | 4 | 43264.00 | long | ask | 355.9500 | 3.8000 | ["340","350"] | ["0.4118","0.4284"] | [] | ["EMLD"] | 340.0000 | 350.0000 | 196 | 224 | false | false | true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:32:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:54:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:54:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:11:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:29:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:29:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:32:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:51:28Z"} |
| 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-04T18:01:15Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:06:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:06:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:22:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:22:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:36:37Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:57:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:17:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |