core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a06df8-d6a6-79c3-99e3-33e32317ea1c | MSFT | 2026-09-04 15:50 | call_diagonal_spread_bearish | 2 | 1 | 20 | 220000.00 | short | bid | 499.8200 | 4.0000 | ["450","460"] | ["0.2915","0.3199"] | [] | ["XMIO"] | 450.0000 | 460.0000 | 42 | 77 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:50:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df0-3f6d-7981-82af-ce36f82de6ea | MSFT | 2026-09-04 15:40 | call_diagonal_spread_bearish | 2 | 1 | 4 | 63640.00 | short | bid | 499.6900 | 4.2000 | ["550","590"] | ["0.3133","0.3125"] | [] | ["XCBO"] | 550.0000 | 590.0000 | 651 | 833 | false | true | |||||||||||
| 01a06de3-00cd-7c92-82c0-792a6b882ed7 | MSFT | 2026-09-04 15:26 | call_diagonal_spread_bearish | 2 | 2 | 7 | 54586.00 | short | ask | 500.1101 | 2.5500 | ["460","465"] | ["5.0127","0.2569"] | [] | ["SPHR"] | 460.0000 | 465.0000 | 0 | 21 | false | false | |||||||||||
| 01a06dd7-6fde-7710-aee9-c0ec100a28f1 | MSFT | 2026-09-04 15:13 | call_diagonal_spread_bearish | 2 | 1 | 3 | 50700.00 | short | ask | 500.1800 | 2.2000 | ["415","420"] | ["0.4269","0.3177"] | [] | ["XCBO"] | 415.0000 | 420.0000 | 14 | 42 | false | false | |||||||||||
| 01a06dd4-e76d-77e0-a353-2a7805c928d4 | MSFT | 2026-09-04 15:11 | call_diagonal_spread_bearish | 2 | 1 | 3 | 74289.00 | short | bid | 500.2000 | 6.3500 | ["380","390"] | ["0.4636","0.3155"] | [] | ["XMIO"] | 380.0000 | 390.0000 | 42 | 196 | false | false | |||||||||||
| 01a06dcf-f1e5-7720-84ff-6710a1dca551 | MSFT | 2026-09-04 15:05 | call_diagonal_spread_bearish | 2 | 3 | 27 | 336446.00 | short | ask | 500.5000 | 4.0500 | ["437.5","440"] | ["7.0615","0.4971"] | [] | ["EDGO","XCBO","XISX"] | 437.5000 | 440.0000 | 0 | 7 | false | false | |||||||||||
| 01a06dcf-6546-7891-876e-60e362bce210 | MSFT | 2026-09-04 15:05 | call_diagonal_spread_bearish | 2 | 1 | 4 | 68472.00 | short | bid | 500.5050 | 4.5500 | ["500","565"] | ["0.3101","0.3113"] | [] | ["EMLD"] | 500.0000 | 565.0000 | 469 | 833 | false | false | |||||||||||
| 01a06dcd-464d-7582-9155-1b1c4a24606f | MSFT | 2026-09-04 15:02 | call_diagonal_spread_bearish | 2 | 1 | 3 | 36168.00 | short | bid | 500.6001 | 2.0000 | ["535","545"] | ["0.3058","0.3082"] | [] | ["XMIO"] | 535.0000 | 545.0000 | 378 | 469 | false | true | |||||||||||
| 01a06dcc-b9ae-79f3-af08-f369181ec641 | MSFT | 2026-09-04 15:02 | call_diagonal_spread_bearish | 2 | 1 | 3 | 27462.00 | short | ask | 500.5506 | 2.4000 | ["450","520"] | ["0.3817","0.2926"] | [] | ["ARCO"] | 450.0000 | 520.0000 | 14 | 196 | false | false | |||||||||||
| 01a06dc4-a35d-7543-9a8d-f35cb7ea5092 | MSFT | 2026-09-04 14:53 | call_diagonal_spread_bearish | 2 | 1 | 39 | 412503.00 | short | bid | 500.7200 | 1.7500 | ["475","585"] | ["0.2925","0.3081"] | [] | ["XMIO"] | 475.0000 | 585.0000 | 133 | 504 | false | false | |||||||||||
| 01a06dba-52bd-7961-b4cf-7e26952d08ba | MSFT | 2026-09-04 14:42 | call_diagonal_spread_bearish | 2 | 2 | 12 | 31984.00 | short | bid | 500.2304 | 0.5667 | ["510","540"] | ["0.2456","0.2903"] | [] | ["XPHO"] | 510.0000 | 540.0000 | 42 | 77 | false | true | |||||||||||
| 01a06db8-280d-7ea3-bca4-2fee83e0499d | MSFT | 2026-09-04 14:39 | call_diagonal_spread_bearish | 2 | 1 | 50 | 147550.00 | short | bid | 500.0050 | 1.1000 | ["500","625"] | ["0.2292","0.3006"] | [] | ["XCBO"] | 500.0000 | 625.0000 | 14 | 286 | false | false | |||||||||||
| 01a06db4-5395-74b0-9dd6-869abaa56876 | MSFT | 2026-09-04 14:35 | call_diagonal_spread_bearish | 2 | 1 | 5 | 30465.00 | short | ask | 499.8950 | 2.1500 | ["470","475"] | ["3.5260","0.2429"] | [] | ["AMXO"] | 470.0000 | 475.0000 | 0 | 28 | false | false | |||||||||||
| 01a06db2-637d-7652-a074-16b510932b0e | MSFT | 2026-09-04 14:33 | call_diagonal_spread_bearish | 2 | 1 | 2 | 34260.00 | short | ask | 499.9451 | 4.5000 | ["415","430"] | ["0.5598","0.3081"] | [] | ["XMIO"] | 415.0000 | 430.0000 | 14 | 133 | false | false | |||||||||||
| 01a06da0-d74d-7261-adbc-e94831de383d | MSFT | 2026-09-04 14:14 | call_diagonal_spread_bearish | 2 | 1 | 4 | 26392.00 | short | ask | 500.3350 | 1.2500 | ["475","495"] | ["0.2550","0.2982"] | [] | ["XCBO"] | 475.0000 | 495.0000 | 42 | 77 | false | false | |||||||||||
| 01a06da0-0845-7291-8e33-58845bdaf06c | MSFT | 2026-09-04 14:13 | call_diagonal_spread_bearish | 2 | 1 | 4 | 64420.00 | short | ask | 500.2800 | 2.6000 | ["500","515"] | ["0.3089","0.3091"] | [] | ["XCBO"] | 500.0000 | 515.0000 | 469 | 504 | false | false | |||||||||||
| 01a06d9e-fabd-7990-8d51-abaf1dd01893 | MSFT | 2026-09-04 14:12 | call_diagonal_spread_bearish | 2 | 1 | 3 | 35190.00 | short | bid | 500.0850 | 1.9500 | ["500","530"] | ["0.2975","0.3073"] | [] | ["XPHO"] | 500.0000 | 530.0000 | 196 | 469 | false | false | |||||||||||
| 01a06d7f-9795-7590-b874-1811b81f24d8 | MSFT | 2026-09-04 13:37 | call_diagonal_spread_bearish | 2 | 1 | 2 | 33020.00 | short | ask | 500.3400 | 2.4500 | ["470","520"] | ["0.3091","0.3095"] | [] | ["XCBO"] | 470.0000 | 520.0000 | 378 | 504 | false | false | |||||||||||
| 01a06d75-f2d6-7662-be32-60d29ef8f34d | MSFT | 2026-09-04 13:27 | call_diagonal_spread_bearish | 2 | 1 | 7 | 38500.00 | short | ask | 500.8400 | 0.9000 | ["500","540"] | ["0.2883","0.2770"] | [] | ["XISX"] | 500.0000 | 540.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d73-27fe-7611-b305-7e7282f35595 | MSFT | 2026-09-04 13:24 | call_diagonal_spread_bearish | 2 | 1 | 15 | 173460.00 | short | ask | 500.8000 | 3.0500 | ["435","455"] | ["0.3974","0.2717"] | [] | ["XMIO"] | 435.0000 | 455.0000 | 14 | 28 | false | false | |||||||||||
| 01a06d59-d39e-7b81-9294-76c05c504d20 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 1 | 19 | 43605.00 | short | ask | 500.7200 | 0.7000 | ["487.5","492.5"] | ["0.7485","0.1762"] | [] | ["EDGO"] | 487.5000 | 492.5000 | 0 | 5 | false | false | |||||||||||
| 01a06d46-3fe5-7ab1-84f5-dc2bdbc6b4a6 | MSFT | 2026-09-04 12:35 | call_diagonal_spread_bearish | 2 | 1 | 2 | 36406.00 | short | bid | 501.3300 | 1.8000 | ["420","430"] | ["0.3325","0.3064"] | [] | ["XCBO"] | 420.0000 | 430.0000 | 77 | 196 | false | false | |||||||||||
| 01a06d3b-c44d-7a92-a554-bdc37b48efb1 | MSFT | 2026-09-04 12:23 | call_diagonal_spread_bearish | 2 | 1 | 3 | 51618.00 | short | ask | 501.4350 | 3.4000 | ["415","500"] | ["5.0002","0.3067"] | [] | ["XPHO"] | 415.0000 | 500.0000 | 0 | 504 | false | false |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:41:10Z"} |
| 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-04T19:26:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:14:13Z"} |
| 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-04T19:11:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:05:59Z"} |
| 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-04T19:05:17Z"} |
| 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-04T19:03:14Z"} |
| 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-04T19:02:08Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:53:23Z"} |
| 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:42:17Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:39:57Z"} |
| 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:35:51Z"} |
| 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:33:34Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:14:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:13:45Z"} |
| 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:12:52Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:37:52Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:27:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:24:30Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:35:27Z"} |
| 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-04T16:24:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |