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 |
|---|
| 01a0d4d7-407f-7772-828a-ed84308767ae | MCD | 2026-09-24 15:14 | other | 4 | 1 | 72 | 507530.00 | unknown | bid | 238.1700 | 7.7000 | ["265","275","290","365"] | ["0.5374","0.4398","0.4690","3.4469"] | [] | ["XBOX"] | 265.0000 | 365.0000 | 1 | 22 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:15:11Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4ca-9267-7e40-81ba-5d3e1e9a709c | MCD | 2026-09-24 15:00 | put_diagonal_spread | 2 | 1 | 200 | 1165200.00 | short | bid | 238.3100 | 3.2500 | ["265","270"] | ["0.3814","0.3303"] | [] | ["XPHO"] | 265.0000 | 270.0000 | 8 | 22 | false | false | true | ||||||||||
| 01a0d3bf-489f-7d91-a5dd-8fdc97ca6180 | MCD | 2026-09-24 10:08 | other | 4 | 1 | 27 | 143775.00 | unknown | bid | 241.3700 | 3.5500 | ["235","245","255","265"] | ["0.2281","0.2148","0.2393","0.2870"] | [] | ["XMIO"] | 235.0000 | 265.0000 | 29 | 57 | false | false | true | true | |||||||||
| 01a0d3be-084f-7c03-8940-3715be99d440 | MCD | 2026-09-24 10:07 | put_vertical_spread | 2 | 1 | 60 | 195960.00 | short | bid | 241.8680 | 1.6000 | ["250","260"] | ["0.2340","0.2430"] | ["252.70"] | ["XISX"] | 250.0000 | 260.0000 | 57 | 57 | false | false | false | ||||||||||
| 01a0cf97-9407-7631-93d8-f8bed7dcafe0 | MCD | 2026-09-23 14:46 | put_diagonal_spread | 2 | 2 | 45 | 546782.00 | short | bid | 237.5800 | 4.8633 | ["275","320"] | ["0.3186","0.3710"] | [] | ["ARCO"] | 275.0000 | 320.0000 | 58 | 485 | false | false | true | ||||||||||
| 01a0cf0e-dfee-7593-a880-da891da332c6 | MCD | 2026-09-23 12:17 | call_vertical_spread | 2 | 1 | 50 | 341500.00 | unknown | bid | 235.8100 | 1.1500 | ["220","240"] | ["0.2122","0.2232"] | ["264.15"] | ["XISX"] | 220.0000 | 240.0000 | 485 | 485 | false | false | false | ||||||||||
| 01a0cf0e-2c3f-79c3-aaaf-ed65aafc1bbd | MCD | 2026-09-23 12:16 | put_vertical_spread | 2 | 1 | 25 | 117675.00 | short | bid | 235.7950 | 1.2000 | ["240","250"] | ["0.2804","0.2848"] | ["244.25"] | ["BATO"] | 240.0000 | 250.0000 | 267 | 267 | false | false | false | ||||||||||
| 01a0cef2-5b27-71a2-9851-7a20746695f8 | MCD | 2026-09-23 11:46 | call_vertical_spread | 2 | 1 | 60 | 104520.00 | unknown | bid | 236.0000 | 1.7600 | ["230","270"] | ["0.2335","0.2467"] | ["247.42"] | ["XPHO"] | 230.0000 | 270.0000 | 86 | 86 | false | false | false | ||||||||||
| 01a0cede-d70f-7f83-8946-d3bfbbc82c37 | MCD | 2026-09-23 11:25 | put_diagonal_spread | 2 | 1 | 61 | 753350.00 | short | bid | 237.3400 | 2.5000 | ["295","300"] | ["0.3691","0.3391"] | [] | ["XCBO"] | 295.0000 | 300.0000 | 86 | 450 | false | false | true | ||||||||||
| 01a0cebb-7477-7a93-aae6-cc759725e4db | MCD | 2026-09-23 10:46 | put_calendar | 2 | 2 | 50 | 340800.00 | short | bid | 239.9800 | 2.8000 | ["270"] | ["0.2944"] | [] | ["XMIO"] | 270.0000 | 270.0000 | 114 | 177 | false | false | true | false | |||||||||
| 01a0ceaf-7df7-75f2-912c-b28642f6f395 | MCD | 2026-09-23 10:33 | put_calendar | 2 | 1 | 50 | 340000.00 | short | bid | 240.1099 | 3.4000 | ["270"] | ["0.2946"] | [] | ["SPHR"] | 270.0000 | 270.0000 | 114 | 177 | false | false | true | false | |||||||||
| 01a0ce9d-bb16-7e32-8b27-bb4626faeb16 | MCD | 2026-09-23 10:13 | call_vertical_spread | 2 | 2 | 75 | 124125.00 | short | bid | 239.6700 | 0.8800 | ["300","350"] | ["0.2344","0.2383"] | ["307.05"] | ["XISX"] | 300.0000 | 350.0000 | 485 | 485 | false | true | false | ||||||||||
| 01a0ce96-a697-7541-9614-ca9ff5d7eea8 | MCD | 2026-09-23 10:06 | other | 6 | 3 | 50 | 250176.00 | unknown | bid | 239.3900 | 3.5100 | ["230","235","242.5","250","255","265"] | ["0.2610","0.2552","0.3745","0.4064","0.2841","0.2977"] | [] | ["XISX","XMIO"] | 230.0000 | 265.0000 | 2 | 86 | false | false | true | ||||||||||
| 01a0ce94-d5bf-7101-ae59-55993b9ea241 | MCD | 2026-09-23 10:04 | put_vertical_spread | 2 | 3 | 60 | 112048.00 | short | bid | 238.7300 | 0.8000 | ["240","250"] | ["0.2359","0.2414"] | ["243.30"] | ["C2OX","EDGO","SPHR"] | 240.0000 | 250.0000 | 23 | 23 | false | false | false | ||||||||||
| 01a0ce93-b4af-77b2-bee3-8415a65e3725 | MCD | 2026-09-23 10:02 | put_vertical_spread | 2 | 1 | 50 | 106974.00 | short | bid | 238.9100 | 1.7000 | ["245","250"] | ["0.2355","0.2410"] | ["246.31"] | ["XCBO"] | 245.0000 | 250.0000 | 23 | 23 | false | false | false | ||||||||||
| 01a0ce7e-1d57-7882-b30d-db5d0a81defb | MCD | 2026-09-23 09:39 | call_vertical_spread | 2 | 1 | 100 | 682800.00 | short | bid | 243.4500 | 3.9500 | ["230","250"] | ["0.2173","0.2243"] | ["240"] | ["XMIO"] | 230.0000 | 250.0000 | 485 | 485 | false | false | false | ||||||||||
| 01a0ca5e-5fcf-7c41-a95f-26519952dca0 | MCD | 2026-09-22 14:26 | put_vertical_spread | 2 | 1 | 6 | 116082.00 | short | bid | 251.0350 | 4.2500 | ["345","350"] | ["1.7528","1.7968"] | ["345.03"] | ["XISX"] | 345.0000 | 350.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0ca5e-5416-7270-9df9-d475d64fc53f | MCD | 2026-09-22 14:26 | put_vertical_spread | 2 | 1 | 10 | 193470.00 | short | bid | 251.0500 | 4.2500 | ["345","350"] | ["1.7628","1.8076"] | ["345.03"] | ["XISX"] | 345.0000 | 350.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c56d-3ccf-7072-bac1-46c1aac3d95c | MCD | 2026-09-21 15:24 | call_vertical_spread | 2 | 1 | 50 | 225700.00 | unknown | bid | 248.6700 | 1.7000 | ["240","260"] | ["0.2202","0.2234"] | ["272.57"] | ["XPHO"] | 240.0000 | 260.0000 | 269 | 269 | false | false | false | ||||||||||
| 01a0b60f-1717-7a90-8cd0-ed7f0dfeb714 | MCD | 2026-09-18 15:47 | put_vertical_spread | 2 | 1 | 15 | 218880.00 | short | bid | 249.3800 | 4.7500 | ["315","330"] | ["0.4118","0.4778"] | [] | ["AMXO"] | 315.0000 | 330.0000 | 63 | 63 | false | false | false | ||||||||||
| 01a0b56b-b6e0-7741-a228-0a96fd3e7874 | MCD | 2026-09-18 12:48 | put_vertical_spread | 2 | 4 | 34 | 133346.00 | short | bid | 249.6300 | 2.1000 | ["255","280"] | ["0.2195","0.2512"] | ["259.25"] | ["ARCO","EMLD","SPHR"] | 255.0000 | 280.0000 | 35 | 35 | false | false | false | ||||||||||
| 01a0ab5f-c912-7a53-b345-ac2f9d5febaf | MCD | 2026-09-16 13:59 | call_vertical_spread | 2 | 1 | 65 | 161525.00 | short | bid | 251.5100 | 1.5000 | ["250","255"] | ["0.2286","0.2280"] | ["252.51"] | ["XMIO"] | 250.0000 | 255.0000 | 93 | 93 | false | false | false | ||||||||||
| 01a0ab5f-c912-7a53-b345-ac11adaa68b7 | MCD | 2026-09-16 13:59 | call_vertical_spread | 2 | 1 | 133 | 330505.00 | short | bid | 251.5100 | 1.5000 | ["250","255"] | ["0.2286","0.2280"] | ["252.51"] | ["XMIO"] | 250.0000 | 255.0000 | 93 | 93 | false | false | false | ||||||||||
| 01a0ab48-264b-72f3-a498-d21c9a10a64c | MCD | 2026-09-16 13:33 | call_vertical_spread | 2 | 1 | 100 | 437000.00 | short | bid | 251.6400 | 1.3000 | ["250","260"] | ["0.2228","0.2237"] | ["254.78"] | ["SPHR"] | 250.0000 | 260.0000 | 274 | 274 | false | false | false | ||||||||||
| 01a0ab2d-c07b-70c2-9efb-5cf40c3e39b5 | MCD | 2026-09-16 13:04 | straddle | 2 | 1 | 50 | 284000.00 | short | bid | 251.7250 | 2.3000 | ["250"] | ["0.2456"] | ["193.20","306.80"] | ["SPHR"] | 250.0000 | 250.0000 | 492 | 492 | false | false | false | false | |||||||||
| 01a0aaaa-9273-7621-8618-058e05630440 | MCD | 2026-09-16 10:41 | call_vertical_spread | 2 | 1 | 70 | 136344.00 | short | bid | 249.1900 | 1.2500 | ["300","350"] | ["0.2214","0.2257"] | ["308.32"] | ["XCBO"] | 300.0000 | 350.0000 | 492 | 492 | false | true | false | ||||||||||
| 01a0aaa2-ddcb-7ab2-8342-9714138854a6 | MCD | 2026-09-16 10:33 | put_diagonal_spread | 2 | 1 | 30 | 115890.00 | short | bid | 248.5862 | 1.3000 | ["250","265"] | ["0.2674","0.2415"] | [] | ["EDGO"] | 250.0000 | 265.0000 | 65 | 274 | false | false | true | ||||||||||
| 01a0a668-fc06-78f3-a2ad-0a9366279a9f | MCD | 2026-09-15 14:51 | synthetic | 2 | 1 | 52 | 125996.00 | short | bid | 253.6550 | 0.7000 | ["255"] | ["0.2364"] | ["255.11"] | ["EDGO"] | 255.0000 | 255.0000 | 94 | 94 | false | false | false | false | |||||||||
| 01a0a647-3396-7aa0-be95-6c0ed9fb1997 | MCD | 2026-09-15 14:14 | risk_reversal | 2 | 1 | 22 | 111100.00 | long | bid | 253.7300 | 2.9500 | ["305","370"] | ["1.0829","2.1775"] | ["255.80"] | ["EMLD"] | 305.0000 | 370.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a08778-9ba0-70c3-afec-eac926d309f5 | MCD | 2026-09-09 14:40 | call_vertical_spread | 2 | 2 | 250 | 145250.00 | short | bid | 255.1800 | 0.4400 | ["290","310"] | ["0.2279","0.2344"] | ["292.29"] | ["XMIO"] | 290.0000 | 310.0000 | 128 | 128 | false | true | false | ||||||||||
| 01a086ac-04a1-7220-884b-3631ae51e90b | MCD | 2026-09-09 10:56 | put_diagonal_spread | 2 | 1 | 150 | 1050000.00 | short | bid | 254.1200 | 4.1500 | ["280","290"] | ["0.2322","0.2771"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 37 | 499 | false | false | true | ||||||||||
| 01a06d3f-eeb5-7162-819a-d58318d4a323 | MCD | 2026-09-04 12:28 | put_calendar | 2 | 1 | 20 | 141480.00 | short | bid | 256.7700 | 1.6500 | ["290"] | ["0.2592"] | [] | ["XPHO"] | 290.0000 | 290.0000 | 77 | 196 | false | false | true | false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:00:45Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:08:56Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:07:21Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:47:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:17:59Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:17:11Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:46:46Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:25:06Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:47:01Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:33:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:14:14Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:06:35Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:04:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:03:18Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:39:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:26:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:26:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:24:26Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:47:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:49:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:59:58Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:59:58Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:34:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:05:34Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:42:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:33:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:51:33Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:15:11Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:40:55Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:57:24Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| 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 |