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 |
|---|
| 01a0c9f6-b8a6-7cf3-9463-c2f2d9707955 | MSFT | 2026-09-22 12:33 | call_diagonal_spread | 2 | 2 | 44 | 56936.00 | short | bid | 495.6650 | 0.1700 | ["525","530"] | ["0.3384","0.3080"] | [] | ["ARCO","C2OX"] | 525.0000 | 530.0000 | 3 | 59 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:33:28Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c983-038f-7092-b5a8-8574fd95f8a0 | MSFT | 2026-09-22 10:26 | call_diagonal_spread | 2 | 2 | 10 | 75300.00 | short | ask | 497.3900 | 0.8500 | ["460","500"] | ["0.2903","0.2900"] | [] | ["XCBO"] | 460.0000 | 500.0000 | 24 | 115 | false | false | true | ||||||||||
| 01a0c56c-814f-7cf3-a123-dd85d914e284 | MSFT | 2026-09-21 15:23 | call_diagonal_spread | 2 | 1 | 2 | 32720.00 | short | bid | 499.7800 | 2.7000 | ["430","440"] | ["0.3144","0.3143"] | [] | ["XCBO"] | 430.0000 | 440.0000 | 88 | 179 | false | false | true | ||||||||||
| 01a0c4d0-4d06-7911-b0db-039b7b601f02 | MSFT | 2026-09-21 12:32 | call_diagonal_spread | 2 | 2 | 6 | 38640.00 | short | bid | 495.3700 | 1.8500 | ["500","505"] | ["0.2912","0.3040"] | [] | ["XPHO"] | 500.0000 | 505.0000 | 60 | 179 | false | true | true | ||||||||||
| 01a0b5be-14cf-7430-8a09-5d3b192796e7 | MSFT | 2026-09-18 14:18 | call_diagonal_spread | 2 | 2 | 446 | 36126.00 | short | bid | 495.3500 | 0.0700 | ["540","570"] | ["0.2299","0.3598"] | [] | ["ARCO","C2OX"] | 540.0000 | 570.0000 | 7 | 21 | false | true | true | ||||||||||
| 01a0b54e-72af-7f21-b01a-316ce2cc73de | MSFT | 2026-09-18 12:16 | call_diagonal_spread | 2 | 1 | 3 | 39240.00 | short | bid | 493.4400 | 0.9000 | ["430","500"] | ["2.6832","0.3088"] | [] | ["XCBO"] | 430.0000 | 500.0000 | 0 | 364 | false | false | true | ||||||||||
| 01a0afdd-7d4b-7d02-8ee2-4afc2d7c35bd | MSFT | 2026-09-17 10:55 | call_diagonal_spread | 2 | 1 | 20 | 46100.00 | short | ask | 496.8500 | 1.0000 | ["480","520"] | ["0.4984","0.2412"] | [] | ["EDGO"] | 480.0000 | 520.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0abaa-b4c3-7b11-a22c-aae4b7bfe637 | MSFT | 2026-09-16 15:21 | call_diagonal_spread | 2 | 1 | 7 | 27160.00 | short | bid | 488.6400 | 2.2000 | ["472.5","475"] | ["0.3655","0.2738"] | [] | ["XISX"] | 472.5000 | 475.0000 | 2 | 23 | false | false | true | ||||||||||
| 01a0aabd-821b-7630-a925-62723787b542 | MSFT | 2026-09-16 11:02 | call_diagonal_spread | 2 | 1 | 3 | 48195.00 | short | ask | 492.7500 | 3.1000 | ["400","500"] | ["1.6318","0.3045"] | [] | ["EDGO"] | 400.0000 | 500.0000 | 2 | 366 | false | false | true | ||||||||||
| 01a0aa70-5c1b-7552-92cc-b34e37e5c0a0 | MSFT | 2026-09-16 09:38 | call_diagonal_spread | 2 | 1 | 6 | 48780.00 | unknown | — | 494.6400 | 6.1000 | ["455","460"] | ["0.5319","0.2882"] | [] | ["XISX"] | 455.0000 | 460.0000 | 2 | 37 | false | false | true | true | false | ||||||||
| 01a0a626-cab6-7b61-b452-6c1260e0e7a9 | MSFT | 2026-09-15 13:39 | call_diagonal_spread | 2 | 2 | 5 | 33625.00 | short | ask | 499.2850 | 1.2500 | ["460","550"] | ["0.5191","0.3002"] | [] | ["XCBO"] | 460.0000 | 550.0000 | 3 | 185 | false | false | true | ||||||||||
| 01a0a61d-879e-7fa1-83d2-2fc538cfec3d | MSFT | 2026-09-15 13:29 | call_diagonal_spread | 2 | 1 | 2 | 25870.00 | unknown | — | 499.2150 | 4.1000 | ["435","445"] | ["0.6929","0.3371"] | [] | ["XISX"] | 435.0000 | 445.0000 | 3 | 66 | false | false | true | true | false | ||||||||
| 01a0a610-b276-7cd2-b879-d210db22e47f | MSFT | 2026-09-15 13:15 | call_diagonal_spread | 2 | 2 | 7 | 44870.00 | short | bid | 499.8834 | 2.2000 | ["470","490"] | ["0.4689","0.3121"] | [] | ["XCBO"] | 470.0000 | 490.0000 | 3 | 66 | false | false | 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 | ||||||||||
| 01a0a5ad-222e-7263-a64b-fc39f8d79f45 | MSFT | 2026-09-15 11:26 | call_diagonal_spread | 2 | 1 | 4 | 57240.00 | long | bid | 500.0400 | 1.2500 | ["410","515"] | ["0.3254","0.3022"] | [] | ["XBOX"] | 410.0000 | 515.0000 | 94 | 213 | false | false | true | ||||||||||
| 01a0a5ad-222e-7263-a64b-fc29b572e2b8 | MSFT | 2026-09-15 11:26 | call_diagonal_spread | 2 | 1 | 2 | 28624.00 | long | bid | 500.0400 | 1.2500 | ["410","515"] | ["0.3259","0.3022"] | [] | ["BATO"] | 410.0000 | 515.0000 | 94 | 213 | false | false | true | ||||||||||
| 01a090e9-e3d8-7873-b3d3-bd14eddd37db | MSFT | 2026-09-11 10:40 | call_diagonal_spread | 2 | 2 | 8 | 79080.00 | short | bid | 494.8000 | 2.6000 | ["450","460"] | ["0.3512","0.2997"] | [] | ["XCBO"] | 450.0000 | 460.0000 | 7 | 98 | false | false | true | ||||||||||
| 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 | ||||||||||
| 01a08c8a-8540-74f3-8a09-857a1d340929 | MSFT | 2026-09-10 14:18 | call_diagonal_spread | 2 | 1 | 6 | 70920.00 | short | bid | 490.7200 | 1.8500 | ["450","470"] | ["0.3106","0.3132"] | [] | ["C2OX"] | 450.0000 | 470.0000 | 99 | 190 | false | false | true | ||||||||||
| 01a08755-9e99-73f3-afa1-91cd71617973 | MSFT | 2026-09-09 14:02 | call_diagonal_spread | 2 | 1 | 17 | 25840.00 | short | bid | 492.9201 | 0.3500 | ["485","487.5"] | ["0.3204","0.4581"] | [] | ["C2OX"] | 485.0000 | 487.5000 | 0 | 2 | false | false | true | ||||||||||
| 01a086bb-0c48-7b20-8ccc-341822805172 | MSFT | 2026-09-09 11:13 | call_diagonal_spread | 2 | 1 | 8 | 64440.00 | short | bid | 492.2050 | 1.3500 | ["480","500"] | ["0.3203","0.3088"] | [] | ["XISX"] | 480.0000 | 500.0000 | 72 | 191 | false | false | true | ||||||||||
| 01a0868b-c6b8-7b83-a6b2-d2749bdc26e2 | MSFT | 2026-09-09 10:21 | call_diagonal_spread | 2 | 1 | 14 | 87780.00 | short | bid | 490.6100 | 1.0000 | ["470","500"] | ["0.2743","0.2923"] | [] | ["XISX"] | 470.0000 | 500.0000 | 37 | 128 | false | false | true | ||||||||||
| 01a0867d-7a90-7d10-8295-eea7da80bae9 | MSFT | 2026-09-09 10:06 | call_diagonal_spread | 2 | 2 | 2 | 25800.00 | short | bid | 491.3350 | 2.5000 | ["440","445"] | ["0.3367","0.3068"] | [] | ["XCBO"] | 440.0000 | 445.0000 | 72 | 128 | 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 | ||||||||||
| 01a08145-e850-7903-b71c-e8559273c385 | MSFT | 2026-09-08 09:47 | call_diagonal_spread | 2 | 2 | 30 | 57900.00 | short | bid | 491.5100 | 0.5000 | ["485","490"] | ["0.3204","0.2672"] | [] | ["XCBO"] | 485.0000 | 490.0000 | 3 | 10 | false | false | true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:26:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:23:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:33:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:19:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:17:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:55:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:21:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:02:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:38:24Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:40:08Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:29:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:15:24Z"} |
| 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-15T15:28:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:26:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:26:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:41:04Z"} |
| 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-10T18:37:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:18:43Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:02:15Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:13:44Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:22:01Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:06:04Z"} |
| 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-08T18:21:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:47:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |