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 |
|---|
| 01a06dfe-7fdd-7cd3-ace4-633c8f087bba | MSFT | 2026-09-04 15:56 | call_diagonal_spread_bearish | 2 | 1 | 8 | 238728.00 | long | bid | 500.1750 | 5.9000 | ["350","400"] | ["0.3470","0.3216"] | [] | ["BATO"] | 350.0000 | 400.0000 | 133 | 469 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 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 | |||||||||||
| 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 | true | ||||||||||
| 01a06de1-d7ee-72d2-947e-32675afb2a18 | MSFT | 2026-09-04 15:25 | call_diagonal_spread_bearish | 2 | 1 | 5 | 79950.00 | long | bid | 500.1050 | 2.2500 | ["540","600"] | ["0.3125","0.3122"] | [] | ["XCBO"] | 540.0000 | 600.0000 | 651 | 833 | false | true | true | ||||||||||
| 01a06ddf-cc7e-72f0-8db8-5c47ab4401fa | MSFT | 2026-09-04 15:22 | call_diagonal_spread_bearish | 2 | 1 | 10 | 68940.00 | long | bid | 499.9300 | 3.0000 | ["465","470"] | ["5.2312","0.2675"] | [] | ["XMIO"] | 465.0000 | 470.0000 | 0 | 21 | false | false | true | ||||||||||
| 01a06dde-651d-7bb3-b050-60fcad594a72 | MSFT | 2026-09-04 15:21 | call_diagonal_spread_bearish | 2 | 1 | 3 | 172269.00 | long | bid | 500.1000 | 8.4000 | ["220","230"] | ["0.3722","0.3915"] | [] | ["XCBO"] | 220.0000 | 230.0000 | 469 | 504 | false | false | true | ||||||||||
| 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 | true | ||||||||||
| 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 | true | ||||||||||
| 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 | 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 | |||||||||||
| 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 | |||||||||||
| 01a06d9d-f506-7be0-ad00-605cce8cea17 | MSFT | 2026-09-04 14:11 | call_diagonal_spread_bearish | 2 | 1 | 27 | 161325.00 | long | bid | 500.1993 | 1.4500 | ["470","500"] | ["2.0724","0.2989"] | [] | ["XCBO"] | 470.0000 | 500.0000 | 0 | 77 | false | false | true | ||||||||||
| 01a06d9a-91d5-7901-99d0-e67e26be4867 | MSFT | 2026-09-04 14:07 | call_diagonal_spread_bearish | 2 | 1 | 21 | 201306.00 | long | bid | 499.9200 | 1.4000 | ["450","480"] | ["0.3419","0.2895"] | [] | ["BATO"] | 450.0000 | 480.0000 | 14 | 105 | false | false | true | ||||||||||
| 01a06d98-4bcd-7000-a7a6-e9060be1b07a | MSFT | 2026-09-04 14:04 | call_diagonal_spread_bearish | 2 | 1 | 6 | 30114.00 | long | bid | 500.1300 | 1.7500 | ["470","500"] | ["2.1196","0.2540"] | [] | ["XMIO"] | 470.0000 | 500.0000 | 0 | 49 | false | false | true | ||||||||||
| 01a06d95-1395-70e2-935b-7b217bb43a00 | MSFT | 2026-09-04 14:01 | call_diagonal_spread_bearish | 2 | 1 | 24 | 209640.00 | long | bid | 500.4900 | 2.2500 | ["455","480"] | ["0.2668","0.3013"] | [] | ["XISX"] | 455.0000 | 480.0000 | 14 | 77 | false | false | true | ||||||||||
| 01a06d95-0bc5-70a1-8851-c759562960c6 | MSFT | 2026-09-04 14:01 | call_diagonal_spread_bearish | 2 | 1 | 24 | 209424.00 | long | bid | 500.5900 | 2.4500 | ["455","480"] | ["0.2425","0.2999"] | [] | ["XISX"] | 455.0000 | 480.0000 | 14 | 77 | false | false | true | ||||||||||
| 01a06d95-0bc5-70a1-8851-c74f0fd06498 | MSFT | 2026-09-04 14:01 | call_diagonal_spread_bearish | 2 | 1 | 24 | 209424.00 | long | bid | 500.5900 | 2.4000 | ["455","480"] | ["0.2425","0.2999"] | [] | ["XISX"] | 455.0000 | 480.0000 | 14 | 77 | false | false | true | ||||||||||
| 01a06d95-0bc5-70a1-8851-c73589f2d933 | MSFT | 2026-09-04 14:01 | call_diagonal_spread_bearish | 2 | 1 | 24 | 211200.00 | long | bid | 500.5900 | 3.1000 | ["455","480"] | ["0.2962","0.3043"] | [] | ["XISX"] | 455.0000 | 480.0000 | 14 | 77 | false | false | true | ||||||||||
| 01a06d85-fc4e-7642-abec-d9573293441c | MSFT | 2026-09-04 13:44 | call_diagonal_spread_bearish | 2 | 1 | 4 | 63736.00 | long | bid | 500.2800 | 1.2500 | ["400","500"] | ["0.3206","0.2979"] | [] | ["XISX"] | 400.0000 | 500.0000 | 133 | 196 | false | false | true | ||||||||||
| 01a06d76-f4a6-7991-a036-8a795c910055 | MSFT | 2026-09-04 13:28 | call_diagonal_spread_bearish | 2 | 2 | 5 | 82200.00 | long | bid | 501.0600 | 2.6500 | ["500","510"] | ["0.3092","0.3095"] | [] | ["XCBO"] | 500.0000 | 510.0000 | 469 | 504 | false | false | true | ||||||||||
| 01a06d6a-e6b5-78d0-a2c7-3951170ea85e | MSFT | 2026-09-04 13:15 | call_diagonal_spread_bearish | 2 | 1 | 140 | 1232000.00 | long | bid | 500.9200 | 3.3000 | ["450","475"] | ["0.2869","0.2616"] | [] | ["XMIO"] | 450.0000 | 475.0000 | 14 | 49 | false | false | |||||||||||
| 01a06d60-e435-7330-a7da-c2369f3a762c | MSFT | 2026-09-04 13:04 | call_diagonal_spread_bearish | 2 | 2 | 10 | 27324.00 | long | bid | 500.0050 | 1.8300 | ["485","495"] | ["0.9667","0.2319"] | [] | ["XMIO"] | 485.0000 | 495.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a06d5f-fdbd-7050-ae68-80c2d25d2bf1 | MSFT | 2026-09-04 13:03 | call_diagonal_spread_bearish | 2 | 1 | 5 | 60880.00 | long | bid | 500.0700 | 3.7500 | ["460","480"] | ["0.2951","0.3015"] | [] | ["XISX"] | 460.0000 | 480.0000 | 133 | 196 | false | false | true | ||||||||||
| 01a06d59-cfb6-7920-a332-6fe3cabd4425 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 2 | 46 | 106904.00 | long | bid | 500.7200 | 1.9000 | ["487.5","492.5"] | ["0.8871","0.1870"] | [] | ["C2OX","XCBO"] | 487.5000 | 492.5000 | 0 | 5 | false | false | |||||||||||
| 01a06d59-cfb6-7920-a332-6fdcf1845da3 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 2 | 34 | 78778.00 | long | bid | 500.8598 | 1.9000 | ["487.5","492.5"] | ["0.9805","0.1786"] | [] | ["C2OX","XISX"] | 487.5000 | 492.5000 | 0 | 5 | false | false | |||||||||||
| 01a06d59-cbcd-7c11-8fc9-e2040adeaab1 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 1 | 25 | 58100.00 | long | bid | 500.8598 | 1.9000 | ["487.5","492.5"] | ["0.6956","0.1804"] | [] | ["C2OX"] | 487.5000 | 492.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d59-cbcd-7c11-8fc9-e1fa4f5257c9 | MSFT | 2026-09-04 12:56 | call_diagonal_spread_bearish | 2 | 1 | 12 | 27732.00 | long | bid | 500.8000 | 1.9000 | ["487.5","492.5"] | ["0.6667","0.1796"] | [] | ["XISX"] | 487.5000 | 492.5000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d52-8485-7582-bd40-cbc1e4e69774 | MSFT | 2026-09-04 12:48 | call_diagonal_spread_bearish | 2 | 1 | 4 | 30780.00 | long | bid | 500.7300 | 1.8000 | ["490","500"] | ["0.2863","0.2834"] | [] | ["XMIO"] | 490.0000 | 500.0000 | 105 | 133 | false | false | true | ||||||||||
| 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 | |||||||||||
| 01a06d3f-94dd-7e21-93d2-4e122da3e525 | MSFT | 2026-09-04 12:27 | call_diagonal_spread_bearish | 2 | 1 | 2 | 33860.00 | long | bid | 501.2750 | 2.1000 | ["410","435"] | ["0.3322","0.3240"] | [] | ["XCBO"] | 410.0000 | 435.0000 | 42 | 77 | false | false | true | ||||||||||
| 01a06d2f-21ee-76f3-92c6-00c282049271 | MSFT | 2026-09-04 12:09 | call_diagonal_spread_bearish | 2 | 1 | 7 | 78337.00 | long | bid | 500.8540 | 3.4500 | ["445","450"] | ["0.4179","0.2800"] | [] | ["MCRY"] | 445.0000 | 450.0000 | 7 | 42 | 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 |
| 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 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:25:21Z"} |
| 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-04T19:23:12Z"} |
| 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-04T19:21: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-04T19:11:41Z"} |
| 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 |
| 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:12:52Z"} |
| 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:11:24Z"} |
| 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:07:43Z"} |
| 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:05:06Z"} |
| 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:01:50Z"} |
| 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:01:50Z"} |
| 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:01:50Z"} |
| 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:01:50Z"} |
| 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:45:08Z"} |
| 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:29:00Z"} |
| 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-04T17:15: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-04T17:04:36Z"} |
| 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:03:31Z"} |
| 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-04T16:56:58Z"} |
| 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:56:58Z"} |
| 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:56:58Z"} |
| 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: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:48:56Z"} |
| 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 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:28:31Z"} |
| 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:10:26Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |