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 | 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 |
|---|
| 01a0cf58-837e-7580-95df-b6be9b35f695 | MSFT | 2026-09-23 13:37 | call_ratio_spread | 2 | 1 | 150 | 175750.00 | long | ask | 499.6300 | 0.7500 | ["480","625"] | ["0.2948","0.2873"] | ["502.90","649.42"] | ["EDGO"] | 480.0000 | 625.0000 | 114 | 114 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T17:38:33Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0ca6c-84e7-70b3-9903-edbb2ff2817a | MSFT | 2026-09-22 14:41 | call_vertical_spread | 2 | 1 | 500 | 105000.00 | long | ask | 498.4400 | 0.0600 | ["502.5","505"] | ["0.2779","0.2815"] | ["503.06"] | ["XISX"] | 502.5000 | 505.0000 | 1 | 1 | false | true | false | ||||||||||
| 01a0c983-bf0e-7f20-82c9-c051151d0b70 | MSFT | 2026-09-22 10:27 | put_calendar | 2 | 1 | 51 | 134130.00 | unknown | ask | 497.3350 | 2.8000 | ["505"] | ["0.2606"] | [] | ["XISX"] | 505.0000 | 505.0000 | 10 | 13 | false | false | true | false | |||||||||
| 01a0c955-2947-7ce2-a31c-d5faf67edac9 | MSFT | 2026-09-22 09:36 | put_butterfly_spread | 3 | 1 | 20 | 691100.00 | unknown | ask | 501.4950 | 10.0000 | ["550","650","750"] | ["0.3545","0.3838","0.4379"] | ["477.22"] | ["XISX"] | 550.0000 | 750.0000 | 850 | 850 | true | false | false | ||||||||||
| 01a0c561-bf66-7793-a742-a513a039b1e6 | MSFT | 2026-09-21 15:11 | strangle_swap | 4 | 1 | 20 | 181200.00 | unknown | bid | 499.1050 | 2.4500 | ["500","510","520","530"] | ["0.3223","0.2916","0.3227","0.2838"] | [] | ["XISX"] | 500.0000 | 530.0000 | 39 | 116 | false | false | true | ||||||||||
| 01a0c4c9-09a6-7120-a5b4-af8e94ca4581 | MSFT | 2026-09-21 12:25 | call_calendar | 2 | 2 | 10 | 109700.00 | long | bid | 493.4450 | 2.0500 | ["440"] | ["0.4260"] | [] | ["XCBO"] | 440.0000 | 440.0000 | 4 | 25 | false | false | true | false | |||||||||
| 01a0c4c3-ba46-77d3-844e-f4279e3b0403 | MSFT | 2026-09-21 12:19 | call_vertical_spread | 2 | 1 | 3 | 119895.00 | short | bid | 493.8081 | 6.3000 | ["340","350"] | ["0.3079","0.3310"] | ["343.65"] | ["AMXO"] | 340.0000 | 350.0000 | 816 | 816 | false | false | false | ||||||||||
| 01a0b4e1-c65f-7c00-b53c-a7542f6d8638 | MSFT | 2026-09-18 10:18 | call_calendar | 2 | 1 | 20 | 216400.00 | short | bid | 492.6625 | 2.9500 | ["440"] | ["1.1677"] | [] | ["XCBO"] | 440.0000 | 440.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0afc6-e423-74a3-bb6a-9d97428a351f | MSFT | 2026-09-17 10:30 | call_vertical_spread | 2 | 1 | 22 | 127820.00 | long | ask | 498.3200 | 0.9000 | ["500","530"] | ["0.2910","0.2848"] | ["513.20"] | ["XISX"] | 500.0000 | 530.0000 | 120 | 120 | false | true | false | ||||||||||
| 01a0aacd-06c3-71d2-8d09-dddb6e9f5a25 | MSFT | 2026-09-16 11:19 | call_calendar | 2 | 1 | 28 | 232120.00 | long | bid | 494.2200 | 2.4000 | ["455"] | ["0.4101"] | [] | ["XCBO"] | 455.0000 | 455.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aac0-9efa-7082-bb0c-3e8dd7e92e8c | MSFT | 2026-09-16 11:05 | strangle_swap | 4 | 1 | 148 | 589040.00 | unknown | — | 493.3200 | 1.8000 | ["490","495","505"] | ["0.3230","0.2513","0.2829"] | [] | ["XISX"] | 490.0000 | 505.0000 | 2 | 23 | false | false | true | true | true | ||||||||
| 01a0a5ae-c426-7ed1-a239-d75af69b2440 | MSFT | 2026-09-15 11:28 | call_diagonal_spread | 2 | 2 | 4 | 101380.00 | short | bid | 500.0080 | 2.3000 | ["375","380"] | ["1.2990","0.3470"] | [] | ["XCBO"] | 375.0000 | 380.0000 | 3 | 122 | false | false | true | ||||||||||
| 01a0a04e-7500-73c3-b64a-0eb06bef4ebc | MSFT | 2026-09-14 10:24 | other | 4 | 1 | 12 | 190500.00 | unknown | — | 499.7550 | 5.4500 | ["440","460","465","490"] | ["0.6134","0.3922","0.2830","0.2579"] | [] | ["XCBO"] | 440.0000 | 490.0000 | 4 | 25 | false | false | true | true | false | ||||||||
| 01a08cc2-0830-70f2-88c0-3ecef62e2d11 | MSFT | 2026-09-10 15:18 | call_vertical_spread | 2 | 1 | 30 | 145350.00 | long | ask | 491.0150 | 0.5500 | ["500","550"] | ["0.2955","0.2899"] | ["517.85"] | ["XCBO"] | 500.0000 | 550.0000 | 127 | 127 | false | true | false | ||||||||||
| 01a08c9b-dac0-7701-b880-e03b60eb33bb | MSFT | 2026-09-10 14:36 | call_diagonal_spread | 2 | 2 | 25 | 273875.00 | short | ask | 490.8301 | 3.5000 | ["435","475"] | ["0.3653","0.2985"] | [] | ["EDGO"] | 435.0000 | 475.0000 | 71 | 99 | false | false | true | ||||||||||
| 01a0823f-dc98-7153-bb6e-651b1ffa179e | MSFT | 2026-09-08 14:20 | call_diagonal_spread | 2 | 1 | 16 | 146560.00 | short | bid | 491.9500 | 1.5000 | ["450","460"] | ["0.3636","0.3188"] | [] | ["XCBO"] | 450.0000 | 460.0000 | 10 | 73 | false | false | true | ||||||||||
| 01a06df1-29cd-7823-aaca-b377b24e6382 | MSFT | 2026-09-04 15:41 | call_calendar | 2 | 1 | 10 | 114550.00 | long | bid | 499.6450 | 2.2000 | ["445"] | ["0.2981"] | [] | ["XCBO"] | 445.0000 | 445.0000 | 14 | 42 | false | false | true | false |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:41:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:27:31Z"} |
| 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-22T13:36:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:11:58Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:25:37Z"} |
| 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-21T16:19:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:18:17Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:30:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:20:01Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:05:53Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:28:32Z"} |
| 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:24:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:19:06Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:37:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:21:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:42:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |