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 |
|---|
| 01a0c567-ab06-7461-b400-a94ebf2fd1a2 | MPC | 2026-09-21 15:18 | call_diagonal_spread | 2 | 1 | 8 | 275456.00 | short | ask | 406.4100 | 7.7000 | ["210","350"] | ["0.4860","0.4240"] | [] | ["XISX"] | 210.0000 | 350.0000 | 116 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:18:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c443-820e-7340-9f00-c3a4dbb6494e | MPC | 2026-09-21 09:59 | call_diagonal_spread | 2 | 1 | 24 | 248376.00 | short | bid | 422.0101 | 3.0000 | ["420","450"] | ["0.5095","0.5066"] | [] | ["XPHO"] | 420.0000 | 450.0000 | 116 | 179 | false | false | true | ||||||||||
| 01a0b582-250f-7f80-922a-1d8ec61fff39 | MPC | 2026-09-18 13:13 | call_diagonal_spread | 2 | 1 | 232 | 382439.00 | unknown | ask | 422.2500 | 1.9000 | ["410","490"] | ["1.0019","0.5059"] | [] | ["XBOX"] | 410.0000 | 490.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b57d-c00f-7910-b949-1d5da36e1aa3 | MPC | 2026-09-18 13:08 | call_diagonal_spread | 2 | 1 | 10 | 217200.00 | unknown | — | 422.3100 | 5.8000 | ["310","320"] | ["8.8560","0.5862"] | [] | ["BATO"] | 310.0000 | 320.0000 | 0 | 28 | false | false | true | true | false | ||||||||
| 01a0b57d-3f27-7770-bc97-ea1a05b580c6 | MPC | 2026-09-18 13:07 | call_diagonal_spread | 2 | 2 | 10 | 217150.00 | unknown | — | 422.1301 | 5.9000 | ["310","320"] | ["9.2425","0.5993"] | [] | ["SPHR","XMIO"] | 310.0000 | 320.0000 | 0 | 28 | false | false | true | true | false | ||||||||
| 01a0b569-9bcf-77d1-a94a-11e9f9205f12 | MPC | 2026-09-18 12:46 | call_diagonal_spread | 2 | 1 | 10 | 199610.00 | short | ask | 423.6850 | 5.2000 | ["320","330"] | ["6.2335","0.5451"] | [] | ["XMIO"] | 320.0000 | 330.0000 | 0 | 28 | 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 | ||||||||||
| 01a0b4b6-16c8-7963-a664-7b44fe7caf39 | MPC | 2026-09-18 09:30 | call_diagonal_spread | 2 | 1 | 10 | 155160.00 | short | ask | 420.0150 | 5.9000 | ["340","350"] | ["4.2135","0.5669"] | [] | ["XPHO"] | 340.0000 | 350.0000 | 0 | 28 | 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 | ||||||||||
| 01a0b0ae-1b8b-7c33-ba76-f724710b8fb7 | MPC | 2026-09-17 14:43 | call_diagonal_spread | 2 | 1 | 10 | 256950.00 | unknown | — | 422.1100 | 4.9000 | ["290","300"] | ["3.7733","0.6830"] | [] | ["XMIO"] | 290.0000 | 300.0000 | 1 | 29 | false | false | true | true | false | ||||||||
| 01a0ab9e-7bdb-79f2-a3af-0bf058bffeab | MPC | 2026-09-16 15:08 | call_diagonal_spread | 2 | 3 | 24 | 120572.00 | unknown | — | 413.7500 | 4.5000 | ["360","450"] | ["1.4084","0.5180"] | [] | ["C2OX","XBOX","XCBO"] | 360.0000 | 450.0000 | 2 | 65 | false | false | true | true | false | ||||||||
| 01a0ab9e-77f2-7671-ac7e-27d6b2107e7c | MPC | 2026-09-16 15:08 | call_diagonal_spread | 2 | 4 | 26 | 133117.00 | unknown | — | 413.7500 | 4.5000 | ["360","450"] | ["1.2827","0.5250"] | [] | ["C2OX","SPHR","XCBO","XISX"] | 360.0000 | 450.0000 | 2 | 65 | false | false | true | true | false | ||||||||
| 01a0ab9a-e9cb-7b32-94a7-7afac4ea25bb | MPC | 2026-09-16 15:04 | call_diagonal_spread | 2 | 1 | 10 | 109810.00 | unknown | — | 415.0100 | 3.0000 | ["330","450"] | ["1.6289","0.5253"] | [] | ["ARCO"] | 330.0000 | 450.0000 | 2 | 65 | false | false | true | true | false | ||||||||
| 01a0ab9a-e9cb-7b32-94a7-7aef245baa97 | MPC | 2026-09-16 15:04 | call_diagonal_spread | 2 | 3 | 14 | 153192.00 | short | ask | 415.0100 | 3.0000 | ["330","450"] | ["1.5032","0.5225"] | [] | ["C2OX","XCBO","XISX"] | 330.0000 | 450.0000 | 2 | 65 | false | false | true | ||||||||||
| 01a0ab9a-e5e3-7c60-8247-c0bd814a0249 | MPC | 2026-09-16 15:04 | call_diagonal_spread | 2 | 3 | 18 | 195478.00 | unknown | — | 415.0100 | 2.9000 | ["330","450"] | ["1.7245","0.5164"] | [] | ["EDGO","XBOX","XCBO"] | 330.0000 | 450.0000 | 2 | 65 | false | false | true | true | false | ||||||||
| 01a0ab9a-de13-79c2-b590-052edd153490 | MPC | 2026-09-16 15:04 | call_diagonal_spread | 2 | 1 | 10 | 108960.00 | unknown | — | 415.0100 | 4.0000 | ["330","450"] | ["1.2417","0.5190"] | [] | ["ARCO"] | 330.0000 | 450.0000 | 2 | 65 | false | false | true | true | false | ||||||||
| 01a0ab9a-de13-79c2-b590-051da3f172ad | MPC | 2026-09-16 15:04 | call_diagonal_spread | 2 | 3 | 17 | 183804.00 | unknown | — | 415.0100 | 4.0294 | ["330","450"] | ["1.8402","0.5128"] | [] | ["EMLD","XBOX","XISX"] | 330.0000 | 450.0000 | 2 | 65 | false | false | true | true | false | ||||||||
| 01a0ab9a-da2b-7541-bb1c-7e082180d49d | MPC | 2026-09-16 15:04 | call_diagonal_spread | 2 | 4 | 23 | 249320.00 | unknown | — | 415.0100 | 4.1000 | ["330","450"] | ["1.7760","0.5153"] | [] | ["XBOX","XCBO","XISX","XPHO"] | 330.0000 | 450.0000 | 2 | 65 | false | false | true | true | false | ||||||||
| 01a0ab9a-d643-77d3-9c32-0ee640ff7f4b | MPC | 2026-09-16 15:04 | call_diagonal_spread | 2 | 4 | 21 | 228431.00 | short | ask | 415.0100 | 4.1000 | ["330","450"] | ["1.7004","0.5180"] | [] | ["ARCO","EDGO","XBOX","XISX"] | 330.0000 | 450.0000 | 2 | 65 | false | false | true | ||||||||||
| 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 | ||||||||||
| 01a0a668-34ce-7c92-8c6d-98961b5c09be | MPC | 2026-09-15 14:50 | call_diagonal_spread | 2 | 1 | 15 | 525390.00 | short | ask | 411.0300 | 7.3000 | ["220","320"] | ["0.4962","0.4310"] | [] | ["ARCO"] | 220.0000 | 320.0000 | 275 | 640 | false | false | true | ||||||||||
| 01a0a04e-e649-7363-bb97-24693ea33685 | MPC | 2026-09-14 10:25 | call_diagonal_spread | 2 | 1 | 6 | 105504.00 | short | ask | 405.1700 | 4.7000 | ["320","350"] | ["0.5617","0.4832"] | [] | ["XISX"] | 320.0000 | 350.0000 | 32 | 186 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:59:24Z"} |
| 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-18T17:13:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:08:44Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:08:07Z"} |
| 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:46:41Z"} |
| 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-18T13:30:31Z"} |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:43:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:08:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:08:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:23Z"} |
| 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-16T19:04:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:23Z"} |
| 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-16T19:04:23Z"} |
| 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-16T18:52:35Z"} |
| 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-15T18:50:47Z"} |
| 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-14T14:25:37Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |