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 |
|---|
| 01a0c9b7-d317-7040-8d7b-18152082cfed | MPC | 2026-09-22 11:24 | put_ratio_spread | 2 | 3 | 118 | 152160.00 | unknown | bid | 399.2900 | 1.0000 | ["250","350"] | ["0.5382","0.5193"] | ["166.93","333.07"] | ["XBOX","XCBO","XISX"] | 250.0000 | 350.0000 | 115 | 115 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:25:13Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c96c-761f-7b70-b0ff-69cc10159b58 | MPC | 2026-09-22 10:02 | put_vertical_spread | 2 | 1 | 25 | 121325.00 | short | bid | 389.7400 | 3.8000 | ["350","370"] | ["0.5319","0.5297"] | ["361.93"] | ["XCBO"] | 350.0000 | 370.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0b5e8-0ee7-76b1-9af6-409adef4b881 | MPC | 2026-09-18 15:04 | call_butterfly_spread | 3 | 1 | 78 | 604656.00 | short | bid | 423.3100 | 9.8000 | ["360","390","400"] | ["8.5604","4.9342","3.6468"] | ["379.96"] | ["XCBO"] | 360.0000 | 400.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5c9-6f10-7d81-84c3-01e6e1c02656 | MPC | 2026-09-18 14:31 | call_diagonal_spread | 2 | 1 | 36 | 319355.00 | short | ask | 423.0050 | 1.8000 | ["360","420"] | ["5.5412","0.5031"] | [] | ["XMIO"] | 360.0000 | 420.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b5c9-6f10-7d81-84c3-01d3ff05aa96 | MPC | 2026-09-18 14:31 | call_diagonal_spread | 2 | 1 | 36 | 319356.00 | short | ask | 423.0050 | 1.8000 | ["360","420"] | ["5.5396","0.5031"] | [] | ["XMIO"] | 360.0000 | 420.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b5c9-6f10-7d81-84c3-01c0f1df1d7a | MPC | 2026-09-18 14:31 | call_diagonal_spread | 2 | 1 | 36 | 319356.00 | short | ask | 422.9650 | 1.8000 | ["360","420"] | ["5.7565","0.5036"] | [] | ["XMIO"] | 360.0000 | 420.0000 | 0 | 28 | false | false | true | ||||||||||
| 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 | ||||||||||
| 01a0b557-1d6f-7723-acaa-42ff81142fb3 | MPC | 2026-09-18 12:26 | call_diagonal_spread | 2 | 1 | 70 | 921900.00 | short | ask | 424.3700 | 6.0000 | ["350","450"] | ["0.5459","0.5114"] | [] | ["XMIO"] | 350.0000 | 450.0000 | 28 | 182 | false | false | true | ||||||||||
| 01a0b4ed-18cf-76d1-be38-9d088b7cb775 | MPC | 2026-09-18 10:30 | call_diagonal_spread | 2 | 1 | 14 | 188160.00 | short | bid | 424.0100 | 6.4000 | ["400","440"] | ["0.5173","0.5000"] | [] | ["XMIO"] | 400.0000 | 440.0000 | 119 | 272 | false | false | true | ||||||||||
| 01a0b4c2-efd7-7ae3-bf4b-55a036c17980 | MPC | 2026-09-18 09:44 | call_calendar | 2 | 1 | 5 | 204445.00 | short | bid | 422.2100 | 6.0000 | ["220"] | ["6.4910"] | [] | ["EDGO"] | 220.0000 | 220.0000 | 0 | 182 | false | false | true | false | |||||||||
| 01a0b01d-be83-75c1-981c-0093fb3207f5 | MPC | 2026-09-17 12:05 | call_calendar | 2 | 1 | 10 | 112250.00 | unknown | — | 419.6700 | 5.3000 | ["470"] | ["0.4834"] | [] | ["XMIO"] | 470.0000 | 470.0000 | 120 | 491 | false | true | true | false | false | mlat | |||||||
| 01a0af95-77cb-77b1-8174-e91b7b179a45 | MPC | 2026-09-17 09:36 | put_vertical_spread | 2 | 1 | 219 | 283824.00 | short | bid | 413.2800 | 3.1500 | ["340","380"] | ["0.5460","0.5313"] | ["372.40"] | ["XISX"] | 340.0000 | 380.0000 | 29 | 29 | false | true | false | ||||||||||
| 01a0aa8c-5ffb-7710-af74-39da98b925db | MPC | 2026-09-16 10:08 | call_diagonal_spread | 2 | 1 | 15 | 568185.00 | short | ask | 409.5500 | 7.7000 | ["200","250"] | ["0.6783","0.4409"] | [] | ["XCBO"] | 200.0000 | 250.0000 | 121 | 184 | false | false | true | ||||||||||
| 01a0a581-1ca6-7ee3-816a-4f4408b24924 | MPC | 2026-09-15 10:38 | other | 6 | 1 | 802 | 3319478.00 | unknown | — | 400.5450 | 9.2500 | ["340","360","370","380","390","410"] | ["1.0521","0.7161","0.5094","0.6761","0.4991","0.5027"] | [] | ["AMXO"] | 340.0000 | 410.0000 | 3 | 31 | false | false | true | true | true | ||||||||
| 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 | ||||||||||
| 01a09102-26c8-7313-9d89-aa36b3290492 | MPC | 2026-09-11 11:07 | call_diagonal_spread | 2 | 1 | 24 | 166128.00 | short | ask | 402.8901 | 3.8000 | ["440","560"] | ["0.4784","0.4700"] | [] | ["XCBO"] | 440.0000 | 560.0000 | 189 | 279 | false | true | true | ||||||||||
| 01a08cbd-e980-7750-b4a2-623f10d34c2c | MPC | 2026-09-10 15:14 | call_diagonal_spread | 2 | 1 | 15 | 388215.00 | short | ask | 398.6155 | 4.8000 | ["250","300"] | ["1.2946","0.4756"] | [] | ["XCBO"] | 250.0000 | 300.0000 | 8 | 127 | false | false | true | ||||||||||
| 01a08c07-e7c0-7191-8c3f-4721a37be380 | MPC | 2026-09-10 11:55 | call_diagonal_spread | 2 | 1 | 5 | 117565.00 | short | bid | 402.3000 | 6.8000 | ["320","360"] | ["0.4644","0.4221"] | [] | ["XCBO"] | 320.0000 | 360.0000 | 280 | 645 | false | false | true | ||||||||||
| 01a08b86-4c11-7451-bae7-ebf5c30d2a27 | MPC | 2026-09-10 09:33 | put_vertical_spread | 2 | 1 | 362 | 303356.00 | unknown | — | 399.9900 | 2.9000 | ["360","390"] | ["0.4995","0.5097"] | [] | ["XISX"] | 360.0000 | 390.0000 | 8 | 8 | false | true | false | true | false | ||||||||
| 01a08682-06a0-7e01-a94d-fd72998b2d2b | MPC | 2026-09-09 10:11 | strangle | 2 | 1 | 16 | 151360.00 | unknown | — | 394.4500 | 2.4000 | ["360","480"] | ["0.4721","0.4414"] | [] | ["XCBO"] | 360.0000 | 480.0000 | 373 | 373 | false | true | false | true | true | mlat | |||||||
| 01a06dfc-d616-7363-9aa8-497f171da9c4 | MPC | 2026-09-04 15:54 | other | 2 | 1 | 4 | 103440.00 | unknown | — | 389.0300 | 7.6000 | ["200","440"] | ["0.5861","0.4259"] | [] | ["XMIO"] | 200.0000 | 440.0000 | 133 | 504 | false | false | true | true | false | mlat | |||||||
| 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 |
| mlat |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:04:54Z"} |
| 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-18T18:31:25Z"} |
| 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-18T18:31:25Z"} |
| 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-18T18:31:25Z"} |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:26:39Z"} |
| 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-18T14:30:33Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:44:33Z"} |
| 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-17T16:05:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:36:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:09:00Z"} |
| 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-15T14:38:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:07:29Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:14:43Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:55:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:33:58Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:11:15Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |