core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0e984-3497-7bc2-8a1f-64709baa877b | COHR | 2026-09-28 15:35 | call_vertical_spread | 2 | 2 | 200 | 766000.00 | unknown | bid | 282.0700 | 4.6000 | ["265","267.5"] | ["0.7901","0.7862"] | ["285.40"] | ["C2OX"] | 265.0000 | 267.5000 | 4 | 4 | true | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T19:35:53Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e866-aaef-7cf2-ad69-99265d5a94da | COHR | 2026-09-28 10:23 | call_vertical_spread | 2 | 1 | 6 | 192264.00 | short | bid | 280.9200 | 17.1000 | ["150","155"] | ["0.7872","0.7848"] | ["153.04"] | ["XCBO"] | 150.0000 | 155.0000 | 480 | 480 | false | false | false | ||||||||||
| 01a0da25-873f-7820-90c7-2d6ae8def019 | COHR | 2026-09-25 15:58 | call_vertical_spread | 2 | 1 | 113 | 152211.00 | short | bid | 295.7900 | 3.8000 | ["287.5","290"] | ["18.3867","8.0378"] | ["289.97"] | ["XCBO"] | 287.5000 | 290.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0cf2d-be47-70f0-9767-fb9f0c712aef | COHR | 2026-09-23 12:51 | call_vertical_spread | 2 | 1 | 150 | 468000.00 | unknown | bid | 301.6250 | 6.9000 | ["287.5","290"] | ["0.8574","0.8381"] | ["304.35"] | ["XISX"] | 287.5000 | 290.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0ce84-c08e-7e81-b296-c79b1c9ff601 | COHR | 2026-09-23 09:46 | call_vertical_spread | 2 | 1 | 10 | 142310.00 | unknown | bid | 304.3650 | 12.3000 | ["240","260"] | ["0.8397","0.8258"] | ["321.16"] | ["XISX"] | 240.0000 | 260.0000 | 58 | 58 | false | false | false | ||||||||||
| 01a0caab-d7d6-7b22-912e-110a64a2df7f | COHR | 2026-09-22 15:50 | call_vertical_spread | 2 | 1 | 25 | 173650.00 | short | bid | 309.6600 | 3.8000 | ["330","360"] | ["0.7735","0.7736"] | ["339.72"] | ["XCBO"] | 330.0000 | 360.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0caaa-939f-7613-b953-a0cf34058174 | COHR | 2026-09-22 15:49 | call_vertical_spread | 2 | 1 | 30 | 110850.00 | short | bid | 310.0300 | 2.1000 | ["400","420"] | ["0.7714","0.7710"] | ["403.65"] | ["XMIO"] | 400.0000 | 420.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0ca14-a8b7-7903-acc8-8a9a5ef47520 | COHR | 2026-09-22 13:05 | call_vertical_spread | 2 | 1 | 5 | 105170.00 | short | bid | 309.5250 | 10.7000 | ["250","450"] | ["0.7685","0.7652"] | ["309.30"] | ["XCBO"] | 250.0000 | 450.0000 | 486 | 486 | false | false | false | ||||||||||
| 01a0c9e8-0ad7-7990-a6f4-802803e04e32 | COHR | 2026-09-22 12:17 | call_vertical_spread | 2 | 2 | 18 | 194022.00 | short | bid | 308.6350 | 9.8000 | ["265","270"] | ["0.7549","0.7524"] | ["268.49"] | ["C2OX"] | 265.0000 | 270.0000 | 38 | 38 | false | false | false | ||||||||||
| 01a0c57e-57b7-7851-8046-6c33847c3b77 | COHR | 2026-09-21 15:43 | call_vertical_spread | 2 | 1 | 3 | 122652.00 | short | bid | 323.2400 | 12.3000 | ["140","150"] | ["0.8053","0.8015"] | ["146.60"] | ["BATO"] | 140.0000 | 150.0000 | 487 | 487 | false | false | false | ||||||||||
| 01a0c57d-0f97-7223-b1fe-c908c4d811fb | COHR | 2026-09-21 15:41 | call_vertical_spread | 2 | 1 | 3 | 122658.00 | short | bid | 323.6550 | 12.3000 | ["140","150"] | ["0.7983","0.7952"] | ["146.60"] | ["XMIO"] | 140.0000 | 150.0000 | 487 | 487 | false | false | false | ||||||||||
| 01a0c572-3e0f-7712-88a2-531e3d47a67f | COHR | 2026-09-21 15:29 | call_vertical_spread | 2 | 1 | 20 | 560200.00 | short | bid | 323.0850 | 11.0000 | ["350","400"] | ["0.7692","0.7709"] | ["361.70"] | ["XPHO"] | 350.0000 | 400.0000 | 851 | 851 | false | true | false | ||||||||||
| 01a0c52e-ff37-7813-87a0-8c101391b83c | COHR | 2026-09-21 14:16 | call_vertical_spread | 2 | 1 | 10 | 109530.00 | short | bid | 321.6400 | 3.1000 | ["320","330"] | ["0.7575","0.7557"] | ["324.25"] | ["BATO"] | 320.0000 | 330.0000 | 116 | 116 | false | false | false | ||||||||||
| 01a0c4cc-2a6f-78e2-9dd2-670bf62991d7 | COHR | 2026-09-21 12:28 | call_vertical_spread | 2 | 1 | 50 | 452290.00 | short | bid | 329.4400 | 2.8000 | ["330","360"] | ["0.7776","0.7761"] | ["341.63"] | ["XPHO"] | 330.0000 | 360.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c475-1d47-74f2-b7ba-7744b328e17f | COHR | 2026-09-21 10:53 | call_vertical_spread | 2 | 1 | 29 | 134096.00 | unknown | bid | 326.4500 | 3.8000 | ["320","350"] | ["0.7577","0.7590"] | ["358.12"] | ["XISX"] | 320.0000 | 350.0000 | 25 | 25 | false | false | false | ||||||||||
| 01a0b4c1-e250-7763-8791-d5e8284df0e1 | COHR | 2026-09-18 09:43 | call_vertical_spread | 2 | 1 | 33 | 175073.00 | short | bid | 313.6600 | 3.4000 | ["300","320"] | ["0.6968","0.6911"] | ["310.01"] | ["XCBO"] | 300.0000 | 320.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0b4c1-e250-7763-8791-d5d5b13ab2ec | COHR | 2026-09-18 09:43 | call_vertical_spread | 2 | 3 | 54 | 286460.00 | short | bid | 313.1900 | 3.4000 | ["300","320"] | ["0.7056","0.6981"] | ["310"] | ["XMIO","XPHO"] | 300.0000 | 320.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0b4c1-e250-7763-8791-d5c557bc8f09 | COHR | 2026-09-18 09:43 | call_vertical_spread | 2 | 1 | 31 | 163990.00 | short | bid | 313.1900 | 3.4000 | ["300","320"] | ["0.7034","0.6959"] | ["310"] | ["MCRY"] | 300.0000 | 320.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0a0fd-7d98-71b3-a789-ef08b1e11112 | COHR | 2026-09-14 13:35 | call_vertical_spread | 2 | 1 | 8 | 107520.00 | short | bid | 272.0501 | 8.6000 | ["240","300"] | ["0.7675","0.7615"] | ["264.36"] | ["XMIO"] | 240.0000 | 300.0000 | 214 | 214 | false | false | false | ||||||||||
| 01a0a0f7-6ed0-7c10-ba11-eb973cb98b8b | COHR | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 4 | 127852.00 | short | bid | 272.6900 | 11.1000 | ["140","145"] | ["0.7944","0.7922"] | ["143.05"] | ["BATO"] | 140.0000 | 145.0000 | 494 | 494 | false | false | false | ||||||||||
| 01a0a0c7-4a98-7341-9975-f3db92a2c5bf | COHR | 2026-09-14 12:36 | call_vertical_spread | 2 | 1 | 9 | 170937.00 | short | bid | 272.2900 | 12.1000 | ["420","450"] | ["0.7740","0.7722"] | ["425.27"] | ["XCBO"] | 420.0000 | 450.0000 | 858 | 858 | false | true | false | ||||||||||
| 01a0a082-3700-7792-87c9-6407efa798b5 | COHR | 2026-09-14 11:21 | call_vertical_spread | 2 | 1 | 10 | 110860.00 | short | bid | 273.6000 | 4.5000 | ["250","270"] | ["0.7604","0.7566"] | ["259.52"] | ["XMIO"] | 250.0000 | 270.0000 | 123 | 123 | false | false | false | ||||||||||
| 01a08189-5221-7451-856a-b834079bd7b4 | COHR | 2026-09-08 11:00 | call_vertical_spread | 2 | 1 | 28 | 120624.00 | short | bid | 313.0936 | 7.0000 | ["300","310"] | ["0.8361","0.8215"] | ["305.80"] | ["BATO"] | 300.0000 | 310.0000 | 10 | 10 | false | false | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:24:19Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:58:14Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:51:19Z"} |
| 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:46:43Z"} |
| 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-22T19:51:06Z"} |
| 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-22T19:49:51Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:06:23Z"} |
| 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-22T16:17:16Z"} |
| 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:43:07Z"} |
| 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-21T19:41:56Z"} |
| 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-21T19:29:56Z"} |
| 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-21T18:16:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:28:36Z"} |
| 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-21T14:53:34Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:43: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-18T13:43: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-18T13:43:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:36:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:29:47Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:36:54Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:21:35Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:01:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |