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 |
|---|
| 01a0c99f-c6d7-70a2-b7a9-326d1b21d78e | MPC | 2026-09-22 10:58 | put_frontspread | 2 | 4 | 116 | 160806.00 | long | ask | 398.2050 | 2.2000 | ["250","350"] | ["0.5589","0.5290"] | ["166.98","333.02"] | ["ARCO","XBOX","XISX"] | 250.0000 | 350.0000 | 115 | 115 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:58:20Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c972-2b0f-7492-82a1-9103051b3fdc | MPC | 2026-09-22 10:08 | put_vertical_spread | 2 | 1 | 61 | 284260.00 | long | ask | 392.3400 | 3.5000 | ["350","370"] | ["0.5317","0.5257"] | ["362.40"] | ["C2OX"] | 350.0000 | 370.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0c96c-667f-76d3-8212-b9b140a61142 | MPC | 2026-09-22 10:01 | put_frontspread | 2 | 1 | 751 | 796748.00 | long | ask | 389.7400 | 2.6000 | ["340","380"] | ["0.5214","0.4998"] | ["310.95","373.29"] | ["EDGO"] | 340.0000 | 380.0000 | 24 | 24 | false | true | false | ||||||||||
| 01a0c571-1cff-7340-a983-567385193125 | MPC | 2026-09-21 15:28 | strangle | 2 | 1 | 37 | 127761.00 | long | ask | 401.7300 | 1.9000 | ["310","560"] | ["0.5259","0.5164"] | ["275.47","594.53"] | ["ARCO"] | 310.0000 | 560.0000 | 179 | 179 | false | true | false | true | |||||||||
| 01a0c56d-255e-75c2-afda-7e36a3c094c5 | MPC | 2026-09-21 15:24 | put_vertical_spread | 2 | 1 | 48 | 181440.00 | long | ask | 401.9487 | 2.1000 | ["380","410"] | ["0.5294","0.5241"] | ["396.18"] | ["XPHO"] | 380.0000 | 410.0000 | 25 | 25 | false | false | false | ||||||||||
| 01a0c451-d9ef-7112-b28b-95bce1f2414b | MPC | 2026-09-21 10:14 | call_vertical_spread | 2 | 1 | 25 | 129300.00 | long | ask | 416.7250 | 5.3000 | ["440","450"] | ["0.5352","0.5354"] | ["443.48"] | ["XISX"] | 440.0000 | 450.0000 | 60 | 60 | false | true | false | ||||||||||
| 01a0c44c-01d7-7c23-a97b-93030aa618c9 | MPC | 2026-09-21 10:08 | put_diagonal_spread | 2 | 3 | 35 | 173894.00 | long | bid | 418.6500 | 3.4000 | ["300","400"] | ["0.5198","0.5312"] | [] | ["ARCO","XBOX","XMIO"] | 300.0000 | 400.0000 | 88 | 269 | false | true | true | ||||||||||
| 01a0c44b-dac7-71b2-882f-73f1f52d0d7f | MPC | 2026-09-21 10:08 | put_diagonal_spread | 2 | 2 | 35 | 173849.00 | long | bid | 418.6500 | 3.4000 | ["300","400"] | ["0.5197","0.5312"] | [] | ["ARCO","XBOX"] | 300.0000 | 400.0000 | 88 | 269 | false | true | true | ||||||||||
| 01a0b5c1-cdef-7c32-9ed8-335024cdaeb3 | MPC | 2026-09-18 14:22 | call_calendar | 2 | 1 | 4 | 116920.00 | long | bid | 422.3750 | 6.4000 | ["280"] | ["8.1388"] | [] | ["XMIO"] | 280.0000 | 280.0000 | 0 | 119 | false | false | true | false | |||||||||
| 01a0b593-4f97-75a2-8a2b-5a16cbaef657 | MPC | 2026-09-18 13:32 | call_diagonal_spread | 2 | 1 | 94 | 781519.00 | long | bid | 422.7600 | 2.8000 | ["370","440"] | ["3.7977","0.5182"] | [] | ["EDGO"] | 370.0000 | 440.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b581-4e37-7e31-b1bb-ba47b1868438 | MPC | 2026-09-18 13:12 | call_diagonal_spread | 2 | 1 | 10 | 249950.00 | long | ask | 422.2950 | 4.9000 | ["320","330"] | ["0.5162","0.5053"] | [] | ["XMIO"] | 320.0000 | 330.0000 | 182 | 272 | false | false | true | ||||||||||
| 01a0b50a-bac0-7c20-be7b-02aad06fc85f | MPC | 2026-09-18 11:02 | call_diagonal_spread | 2 | 1 | 30 | 164430.00 | long | ask | 426.7600 | 3.2000 | ["400","450"] | ["2.2599","0.5170"] | [] | ["XISX"] | 400.0000 | 450.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b4e0-f757-7d81-bcaa-b95a97487a52 | MPC | 2026-09-18 10:17 | call_diagonal_spread | 2 | 2 | 34 | 349520.00 | long | bid | 425.2200 | 4.7000 | ["370","420"] | ["3.1805","0.5123"] | [] | ["ARCO","XISX"] | 370.0000 | 420.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b0da-1173-7452-8b73-f22f11654a6d | MPC | 2026-09-17 15:31 | call_diagonal_spread | 2 | 1 | 10 | 236800.00 | long | bid | 422.7000 | 5.2000 | ["300","310"] | ["3.7709","0.5550"] | [] | ["XISX"] | 300.0000 | 310.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0afbd-146b-7721-87b5-6395f97005df | MPC | 2026-09-17 10:19 | risk_reversal | 2 | 1 | 17 | 184178.00 | long | ask | 413.8550 | 5.3000 | ["380","500"] | ["0.4964","0.4720"] | ["501.30"] | ["XMIO"] | 380.0000 | 500.0000 | 365 | 365 | false | true | false | ||||||||||
| 01a0afbc-8f9b-7552-9f95-41f30de04b89 | MPC | 2026-09-17 10:19 | risk_reversal | 2 | 1 | 19 | 205390.00 | long | ask | 414.1050 | 5.8000 | ["380","500"] | ["0.4957","0.4709"] | ["501.40"] | ["XMIO"] | 380.0000 | 500.0000 | 365 | 365 | false | true | false | ||||||||||
| 01a0ab90-27e3-70b3-b1ce-57e2dab5049b | MPC | 2026-09-16 14:52 | call_diagonal_spread | 2 | 1 | 10 | 175100.00 | long | bid | 414.4501 | 6.2000 | ["330","350"] | ["0.5946","0.5078"] | [] | ["XMIO"] | 330.0000 | 350.0000 | 30 | 121 | false | false | true | ||||||||||
| 01a0ab7f-c0ab-71c3-a4d0-1e0dcde56958 | MPC | 2026-09-16 14:34 | synthetic | 2 | 3 | 15 | 187140.00 | long | bid | 417.8300 | 0.8000 | ["450"] | ["0.5110"] | ["425.71"] | ["ARCO","XISX","XPHO"] | 450.0000 | 450.0000 | 184 | 184 | false | false | false | false | |||||||||
| 01a0aad2-13bb-7d70-aadb-e2d2adc7ac77 | MPC | 2026-09-16 11:24 | put_vertical_spread | 2 | 1 | 50 | 187550.00 | long | ask | 413.2100 | 2.0000 | ["350","370"] | ["0.5301","0.5313"] | ["363.25"] | ["BATO"] | 350.0000 | 370.0000 | 93 | 93 | false | true | false | ||||||||||
| 01a0a64e-4bfe-7a41-8b39-e17039dd57b5 | MPC | 2026-09-15 14:22 | strangle | 2 | 1 | 100 | 1310000.00 | long | ask | 411.3850 | 4.0000 | ["430","450"] | ["0.4866","0.4825"] | ["299","581.00"] | ["SPHR"] | 430.0000 | 450.0000 | 275 | 275 | true | false | false | true | |||||||||
| 01a0a606-ea8e-7651-9e31-37f57918135b | MPC | 2026-09-15 13:04 | straddle | 2 | 1 | 11 | 127864.00 | long | ask | 410.2882 | 1.0000 | ["430"] | ["0.4924"] | ["313.76","546.24"] | ["ARCO"] | 430.0000 | 430.0000 | 185 | 185 | false | false | false | false | |||||||||
| 01a0a5d7-7dee-74d0-9ce6-277cf7e8ddc3 | MPC | 2026-09-15 12:12 | put_vertical_spread | 2 | 1 | 50 | 189000.00 | long | ask | 407.3100 | 1.3000 | ["350","370"] | ["0.5067","0.5086"] | ["363"] | ["XISX"] | 350.0000 | 370.0000 | 94 | 94 | false | true | false | ||||||||||
| 01a0a5c9-166e-7590-85b9-d0cee1f69a8a | MPC | 2026-09-15 11:56 | put_vertical_spread | 2 | 1 | 50 | 189700.00 | long | ask | 408.0500 | 3.3000 | ["350","370"] | ["0.5089","0.5140"] | ["362.80"] | ["XMIO"] | 350.0000 | 370.0000 | 94 | 94 | false | true | false | ||||||||||
| 01a0a180-9c01-7a10-8a5e-23c1353d264c | MPC | 2026-09-14 15:59 | ratio_risk_reversal | 2 | 1 | 60 | 135540.00 | long | bid | 395.9200 | 1.3000 | ["310","560"] | ["0.4832","0.4847"] | ["302.05"] | ["ARCO"] | 310.0000 | 560.0000 | 186 | 186 | false | true | false | ||||||||||
| 01a0a130-0330-7d72-8494-99a0ace7a881 | MPC | 2026-09-14 14:31 | call_diagonal_spread | 2 | 1 | 10 | 166750.00 | long | bid | 394.3650 | 5.7000 | ["310","330"] | ["1.4358","0.4766"] | [] | ["XMIO"] | 310.0000 | 330.0000 | 4 | 123 | false | false | true | ||||||||||
| 01a0a0c2-f150-79e3-86bb-a6f403fecb34 | MPC | 2026-09-14 12:32 | put_vertical_spread | 2 | 1 | 314 | 344458.00 | long | ask | 398.1250 | 1.8500 | ["330","360"] | ["0.5112","0.5090"] | ["354.43"] | ["SPHR"] | 330.0000 | 360.0000 | 32 | 32 | false | true | false | ||||||||||
| 01a09160-8308-7272-8347-5bd6a6257d3b | MPC | 2026-09-11 12:50 | call_calendar | 2 | 1 | 30 | 699330.00 | long | bid | 403.0000 | 6.0000 | ["290"] | ["0.5000"] | [] | ["XMIO"] | 290.0000 | 290.0000 | 35 | 98 | false | false | true | false | |||||||||
| 01a08c67-edc8-7211-bb6a-a62c1145c0d4 | MPC | 2026-09-10 13:40 | call_vertical_spread | 2 | 4 | 16 | 148448.00 | long | ask | 399.3200 | 3.8000 | ["410","540"] | ["0.4578","0.4681"] | ["446.01"] | ["EDGO","XBOX","XISX","XMIO"] | 410.0000 | 540.0000 | 280 | 280 | false | true | false | ||||||||||
| 01a08c67-74b0-75b3-ace9-8ac45ad9ccbe | MPC | 2026-09-10 13:39 | call_vertical_spread | 2 | 4 | 66 | 668936.00 | long | ask | 399.1700 | 3.0242 | ["390","540"] | ["0.4572","0.4687"] | ["434.53"] | ["EDGO","XBOX","XISX","XMIO"] | 390.0000 | 540.0000 | 280 | 280 | false | false | false | ||||||||||
| 01a08c67-2e60-7ca2-92a5-c3529f1653d9 | MPC | 2026-09-10 13:39 | call_vertical_spread | 2 | 1 | 10 | 100850.00 | long | ask | 399.0800 | 3.9000 | ["390","540"] | ["0.4556","0.4670"] | ["434.51"] | ["XISX"] | 390.0000 | 540.0000 | 280 | 280 | false | false | false | ||||||||||
| 01a08c67-0b38-7d32-b607-ed05be6409b9 | MPC | 2026-09-10 13:39 | call_vertical_spread | 2 | 1 | 13 | 131079.00 | long | ask | 398.8100 | 4.2000 | ["390","540"] | ["0.4575","0.4669"] | ["434.69"] | ["XISX"] | 390.0000 | 540.0000 | 280 | 280 | false | false | false | ||||||||||
| 01a08680-7448-73a1-a4ec-7641601c4c1a | MPC | 2026-09-09 10:09 | risk_reversal | 2 | 1 | 19 | 179740.00 | long | ask | 394.7100 | 3.6000 | ["360","480"] | ["0.4723","0.4410"] | ["480.10"] | ["XMIO"] | 360.0000 | 480.0000 | 373 | 373 | true | true | false | ||||||||||
| 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 | true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:31Z"} |
| 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-22T14:02:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:28:50Z"} |
| 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: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-21T14:15:04Z"} |
| 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:08:35Z"} |
| 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:08:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:22:52Z"} |
| 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-18T17:32:20Z"} |
| 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-18T17:12:48Z"} |
| 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-18T15:02:59Z"} |
| 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-18T14:17:17Z"} |
| 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-17T19:31:25Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:20:12Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:19:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:52:35Z"} |
| 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-16T18:34:42Z"} |
| 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-16T15:25:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:22:41Z"} |
| 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-15T17:04:41Z"} |
| 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-15T16:13:16Z"} |
| 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-15T15:57:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:59:21Z"} |
| 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-14T18:31:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:32:11Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:51:04Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:40:44Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:40:07Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:39:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:39:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:09:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| 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 |