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 |
|---|
| 01a06e0c-1c3d-7611-956a-b772b6de6b66 | SPY | 2026-09-04 16:11 | call_diagonal_spread_bullish | 2 | 1 | 10 | 471320.00 | long | ask | 769.7400 | 6.3800 | ["350","750"] | ["0.4848","0.1246"] | [] | ["XMIO"] | 350.0000 | 750.0000 | 28 | 833 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:11:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfe-5cb5-7d53-a780-f51d662d7b23 | HOOD | 2026-09-04 15:56 | call_diagonal_spread_bullish | 2 | 1 | 300 | 1331700.00 | long | ask | 121.9800 | 1.1000 | ["90","110"] | ["0.8227","22.2393"] | [] | ["XCBO"] | 90.0000 | 110.0000 | 0 | 14 | false | false | |||||||||||
| 01a06dfa-f985-78f0-a82a-0ffb3c2d3ebf | DELL | 2026-09-04 15:52 | call_diagonal_spread_bullish | 2 | 1 | 5 | 53405.00 | long | ask | 523.7000 | 5.5000 | ["470","472.5"] | ["0.5733","10.5822"] | [] | ["XCBO"] | 470.0000 | 472.5000 | 0 | 7 | false | false | |||||||||||
| 01a06ded-97be-7003-b207-092d708e47df | MSFT | 2026-09-04 15:37 | call_diagonal_spread_bullish | 2 | 1 | 6 | 49110.00 | long | ask | 499.6900 | 1.2500 | ["460","465"] | ["0.2677","0.2584"] | [] | ["XCBO"] | 460.0000 | 465.0000 | 21 | 35 | false | false | true | ||||||||||
| 01a06de9-f9f5-7d13-81ca-3b5f0765a390 | SPY | 2026-09-04 15:34 | call_diagonal_spread_bullish | 2 | 1 | 42 | 86730.00 | long | ask | 770.0500 | 0.0600 | ["775","780"] | ["0.1263","0.0902"] | [] | ["XBOX"] | 775.0000 | 780.0000 | 14 | 77 | false | true | true | ||||||||||
| 01a06de4-970d-7283-b98a-eb85301c1f22 | ASTS | 2026-09-04 15:28 | call_diagonal_spread_bullish | 2 | 1 | 80 | 119120.00 | long | ask | 62.3600 | 0.6000 | ["55","60"] | ["0.7188","0.6811"] | [] | ["XMIO"] | 55.0000 | 60.0000 | 14 | 42 | false | false | true | ||||||||||
| 01a06de3-df76-7191-ac8a-3afc311eb7a3 | ORCL | 2026-09-04 15:27 | call_diagonal_spread_bullish | 2 | 1 | 5 | 33005.00 | long | ask | 156.9100 | 1.5500 | ["100","160"] | ["0.5909","1.0407"] | [] | ["XCBO"] | 100.0000 | 160.0000 | 7 | 77 | false | false | true | ||||||||||
| 01a06dcf-c6ed-7970-9698-51d1e87e855b | BRUN | 2026-09-04 15:05 | call_diagonal_spread_bullish | 2 | 1 | 2000 | 369844.00 | long | ask | 17.4700 | 0.3500 | ["20","22.5"] | ["1.0946","0.9506"] | [] | ["XMIO"] | 20.0000 | 22.5000 | 14 | 42 | false | true | true | ||||||||||
| 01a06dce-2cc6-7e22-aab5-321397dd40f7 | MU | 2026-09-04 15:03 | call_diagonal_spread_bullish | 2 | 1 | 10 | 139676.00 | long | ask | 1004.2600 | 4.4000 | ["900","1000"] | ["0.6438","0.7525"] | [] | ["XMIO"] | 900.0000 | 1000.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a06dc3-0d1e-72a1-be5d-25da814c956c | PANW | 2026-09-04 14:51 | call_diagonal_spread_bullish | 2 | 1 | 150 | 31049.00 | long | ask | 335.2500 | 0.7600 | ["430","440"] | ["0.4851","0.6116"] | [] | ["XCBO"] | 430.0000 | 440.0000 | 14 | 42 | false | true | |||||||||||
| 01a06d87-ec65-7de1-ad15-7d5f0e1684ca | AVGO | 2026-09-04 13:46 | call_diagonal_spread_bullish | 2 | 1 | 129 | 197756.00 | long | ask | 354.7900 | 0.4100 | ["360","370"] | ["0.3537","1.0318"] | [] | ["XCBO"] | 360.0000 | 370.0000 | 0 | 42 | false | true | |||||||||||
| 01a06d83-aa8d-7361-88a6-ae4340b67332 | WDC | 2026-09-04 13:42 | call_diagonal_spread_bullish | 2 | 1 | 5 | 26760.00 | long | ask | 461.3950 | 4.2500 | ["440","460"] | ["0.6673","0.6499"] | [] | ["XMIO"] | 440.0000 | 460.0000 | 7 | 14 | false | false | true | ||||||||||
| 01a06d77-42c5-79e3-811a-c0677148c8d6 | AVGO | 2026-09-04 13:28 | call_diagonal_spread_bullish | 2 | 1 | 20 | 35260.00 | long | ask | 354.9450 | 0.6500 | ["350","360"] | ["0.3395","0.3107"] | [] | ["XMIO"] | 350.0000 | 360.0000 | 5 | 21 | false | false | |||||||||||
| 01a06d74-8f5d-78a2-86ec-9b4760db6b0f | MU | 2026-09-04 13:25 | call_diagonal_spread_bullish | 2 | 1 | 7 | 80962.00 | long | ask | 1000.3400 | 5.9000 | ["940","960"] | ["0.5234","1.2780"] | [] | ["XMIO"] | 940.0000 | 960.0000 | 0 | 12 | false | false | true | ||||||||||
| 01a06d59-3375-7a31-98b7-709d655b8107 | JPM | 2026-09-04 12:55 | call_diagonal_spread_bullish | 2 | 1 | 395 | 185255.00 | long | ask | 358.6900 | 1.0200 | ["370","380"] | ["0.1869","0.1842"] | [] | ["XISX"] | 370.0000 | 380.0000 | 14 | 35 | false | true | true | ||||||||||
| 01a06d4c-42f5-7c81-a468-8ce78016cc3d | MPC | 2026-09-04 12:41 | call_diagonal_spread_bullish | 2 | 1 | 15 | 197400.00 | long | ask | 389.9400 | 4.0000 | ["310","350"] | ["0.4450","0.3888"] | [] | ["XMIO"] | 310.0000 | 350.0000 | 14 | 105 | false | false | |||||||||||
| 01a06d43-80c5-7ce0-a4d5-c25dfbccf711 | CRDO | 2026-09-04 12:32 | call_diagonal_spread_bullish | 2 | 1 | 25 | 194725.00 | long | ask | 170.0000 | 3.0000 | ["170","250"] | ["0.8210","0.7817"] | [] | ["XMIO"] | 170.0000 | 250.0000 | 133 | 504 | false | false | |||||||||||
| 01a06d3c-31ad-7c03-8351-6b4e3df9eb79 | GLD | 2026-09-04 12:24 | call_diagonal_spread_bullish | 2 | 1 | 84 | 213612.00 | long | ask | 406.7600 | 1.3500 | ["394","395"] | ["0.2153","0.9600"] | [] | ["XCBO"] | 394.0000 | 395.0000 | 0 | 5 | false | false | true | ||||||||||
| 01a06d37-9dce-73d0-8623-5c6f7c11ac6d | AMD | 2026-09-04 12:19 | call_diagonal_spread_bullish | 2 | 1 | 16 | 96560.00 | long | ask | 472.1301 | 1.5500 | ["450","455"] | ["0.4790","0.3757"] | [] | ["EDGO"] | 450.0000 | 455.0000 | 5 | 35 | false | false | true | ||||||||||
| 01a06d37-671e-7ac3-bf4e-db7e2410dabb | AMD | 2026-09-04 12:19 | call_diagonal_spread_bullish | 2 | 2 | 40 | 114240.00 | long | ask | 472.2900 | 1.1500 | ["650","700"] | ["0.5494","0.5672"] | [] | ["XMIO"] | 650.0000 | 700.0000 | 77 | 168 | false | true | true | ||||||||||
| 01a06d32-c785-7673-ab83-05745538094f | MSTR | 2026-09-04 12:13 | call_diagonal_spread_bullish | 2 | 1 | 44 | 400356.00 | long | ask | 142.2000 | 4.0000 | ["120","175"] | ["0.8415","0.7808"] | [] | ["XMIO"] | 120.0000 | 175.0000 | 105 | 833 | false | false |
| true |
| false |
| mlat |
| 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 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:52:44Z"} |
| 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:38:12Z"} |
| 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:34:13Z"} |
| 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: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-04T19:27:33Z"} |
| 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:05:59Z"} |
| 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:03:44Z"} |
| 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:52:02Z"} |
| 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:47:13Z"} |
| 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:42:25Z"} |
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:25: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-04T16:56:20Z"} |
| 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-04T16:41:49Z"} |
| 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-04T16:32:18Z"} |
| 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-04T16:24:23Z"} |
| 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:19:53Z"} |
| 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-04T16:19: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-04T16:14:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |