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 |
|---|
| 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 |
|---|
| 01a0c975-866f-77c2-8bbd-185ab7db326b | XOP | 2026-09-22 10:11 | put_vertical_spread | 2 | 1 | 50 | 136000.00 | long | ask | 183.6900 | 3.1000 | ["185","190"] | ["0.3491","0.3501"] | ["187.20"] | ["XPHO"] | 185.0000 | 190.0000 | 87 | 87 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:11:58Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c975-3c37-7bd2-80cd-9155b89c07e4 | XOP | 2026-09-22 10:11 | call_vertical_spread | 2 | 1 | 50 | 105000.00 | long | ask | 183.5800 | 2.6500 | ["185","190"] | ["0.3193","0.3188"] | ["187.20"] | ["XISX"] | 185.0000 | 190.0000 | 87 | 87 | false | true | |||||||||||
| 01a0c96f-ae57-77b3-aa14-ba52af91981f | XOP | 2026-09-22 10:05 | put_vertical_spread | 2 | 3 | 93 | 109957.00 | unknown | bid | 182.7200 | 0.8800 | ["170","190"] | ["0.3455","0.3209"] | ["178.18"] | ["AMXO","XCBO","XISX"] | 170.0000 | 190.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c434-3fcf-7e60-a843-e14aa052f1e2 | XOP | 2026-09-21 09:42 | call_diagonal_spread | 2 | 2 | 211 | 258264.00 | long | ask | 186.1200 | 1.4500 | ["190","195"] | ["0.3340","0.3393"] | [] | ["EMLD","SPHR"] | 190.0000 | 195.0000 | 25 | 60 | false | true | |||||||||||
| 01a0c434-3fcf-7e60-a843-e13faf46f708 | XOP | 2026-09-21 09:42 | call_diagonal_spread | 2 | 5 | 109 | 135300.00 | long | ask | 186.1200 | 1.7110 | ["190","195"] | ["0.3369","0.3442"] | [] | ["AMXO","EMLD","SPHR","XBOX"] | 190.0000 | 195.0000 | 25 | 60 | false | true | |||||||||||
| 01a0c434-3fcf-7e60-a843-e1205cd124a2 | XOP | 2026-09-21 09:42 | call_diagonal_spread | 2 | 2 | 115 | 143750.00 | long | ask | 186.1200 | 2.0000 | ["190","195"] | ["0.3384","0.3467"] | [] | ["ARCO"] | 190.0000 | 195.0000 | 25 | 60 | false | true | |||||||||||
| 01a0b0c3-6c93-7323-bd66-ef7c171784d0 | XOP | 2026-09-17 15:06 | call_vertical_spread | 2 | 1 | 48 | 239472.00 | unknown | — | 192.8100 | 3.0000 | ["165","170"] | ["1.8302","1.5419"] | [] | ["MCRY"] | 165.0000 | 170.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0aa87-a50b-73b0-b33a-a1bfa0bd7ec2 | XOP | 2026-09-16 10:03 | call_vertical_spread | 2 | 1 | 50 | 177800.00 | short | bid | 194.5700 | 3.6000 | ["185","190"] | ["0.3314","0.3332"] | ["187.80"] | ["XMIO"] | 185.0000 | 190.0000 | 93 | 93 | false | false | |||||||||||
| 01a0a689-bad6-7bc0-9b7d-dd981e5967c6 | XOP | 2026-09-15 15:27 | call_vertical_spread | 2 | 1 | 43 | 167485.00 | short | bid | 199.2300 | 4.9000 | ["220","250"] | ["0.2911","0.2971"] | ["228.50"] | ["ARCO"] | 220.0000 | 250.0000 | 493 | 493 | true | true | |||||||||||
| 01a0a056-3d31-7733-8cba-63a412d36130 | XOP | 2026-09-14 10:33 | call_calendar | 2 | 5 | 40 | 204608.00 | short | bid | 198.2400 | 6.1500 | ["245"] | ["0.2964"] | [] | ["AMXO","C2OX","EMLD","XMIO","XPHO"] | 245.0000 | 245.0000 | 823 | 858 | false | true | |||||||||||
| 01a0a056-3561-7fb1-af81-93fb26ae0f7e | XOP | 2026-09-14 10:33 | other | 2 | 6 | 40 | 204088.00 | unknown | — | 198.2400 | 6.3300 | ["245"] | ["0.2959"] | [] | ["AMXO","C2OX","EMLD","XMIO","XPHO"] | 245.0000 | 245.0000 | 823 | 858 | true | true | true | false | |||||||||
| 01a0a055-8d68-7fb1-b435-47bb7df1ef8e | XOP | 2026-09-14 10:32 | call_calendar | 2 | 5 | 40 | 193280.00 | short | bid | 198.2100 | 5.7200 | ["250"] | ["0.2961"] | [] | ["ARCO","C2OX","EMLD","XMIO","XPHO"] | 250.0000 | 250.0000 | 823 | 858 | true | true | |||||||||||
| 01a0a054-7fe0-7a62-9caa-ef9978742119 | XOP | 2026-09-14 10:31 | call_calendar | 2 | 11 | 80 | 371274.00 | short | bid | 198.3300 | 5.4500 | ["255"] | ["0.2985"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 255.0000 | 255.0000 | 823 | 858 | true | true | |||||||||||
| 01a090d8-9240-7a60-b359-1c14988c71a8 | XOP | 2026-09-11 10:21 | call_vertical_spread | 2 | 1 | 56 | 112896.00 | unknown | — | 195.9500 | 3.1000 | ["185","190"] | ["0.4462","0.3997"] | [] | ["XPHO"] | 185.0000 | 190.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a08caf-e790-7113-a672-9cea45aaa532 | XOP | 2026-09-10 14:58 | call_vertical_spread | 2 | 1 | 23 | 133998.00 | unknown | — | 196.5500 | 5.9000 | ["225","230"] | ["0.2795","0.2798"] | [] | ["XMIO"] | 225.0000 | 230.0000 | 827 | 827 | false | true | false | true | |||||||||
| 01a086a4-c529-7050-9525-98693945cbba | XOP | 2026-09-09 10:48 | call_diagonal_spread | 2 | 3 | 321 | 1686612.00 | long | bid | 194.2200 | 4.8000 | ["180","190"] | ["0.3178","0.3086"] | [] | ["BATO","C2OX","XCBO"] | 180.0000 | 190.0000 | 191 | 281 | false | false | |||||||||||
| 01a086a4-c529-7050-9525-9851d523d029 | XOP | 2026-09-09 10:48 | other | 2 | 2 | 164 | 878860.00 | unknown | — | 194.2200 | 4.8043 | ["180","190"] | ["0.3287","0.3166"] | [] | ["XBOX","XPHO"] | 180.0000 | 190.0000 | 191 | 281 | false | false | true | true | |||||||||
| 01a086a4-c529-7050-9525-984ae2073651 | XOP | 2026-09-09 10:48 | call_diagonal_spread | 2 | 3 | 279 | 1466145.00 | short | ask | 194.2200 | 4.9333 | ["180","190"] | ["0.3181","0.3085"] | [] | ["EMLD","SPHR","XPHO"] | 180.0000 | 190.0000 | 191 | 281 | false | false | |||||||||||
| 01a086a4-c529-7050-9525-983936b838a9 | XOP | 2026-09-09 10:48 | other | 2 | 5 | 236 | 1234430.00 | unknown | — | 194.2200 | 5.0000 | ["180","190"] | ["0.3156","0.3066"] | [] | ["EMLD","SPHR","XBOX","XPHO"] | 180.0000 | 190.0000 | 191 | 281 | false | false | true | true | |||||||||
| 01a081d4-f181-7e82-8713-36bdc8af3044 | XOP | 2026-09-08 12:23 | call_condor | 4 | 3 | 10 | 139840.00 | unknown | — | 193.9600 | 13.7000 | ["190","205","210","220"] | ["0.2659","0.2706","0.2767","0.2765"] | [] | ["AMXO"] | 190.0000 | 220.0000 | 829 | 829 | false | false | false | true | |||||||||
| 01a08181-e7b1-72b1-afbe-9246c7d429eb | XOP | 2026-09-08 10:52 | call_vertical_spread | 2 | 6 | 12 | 101970.00 | unknown | — | 194.5451 | 3.1833 | ["150","155"] | ["0.8940","0.7972"] | [] | ["ARCO","EMLD","SPHR","XBOX","XISX","XPHO"] | 150.0000 | 155.0000 | 10 | 10 | false | false | false | true | |||||||||
| 01a0813b-eda1-7c40-a947-e834abcd6942 | XOP | 2026-09-08 09:36 | call_vertical_spread | 2 | 3 | 12 | 102958.00 | unknown | — | 195.1500 | 1.0000 | ["150","155"] | ["0.7186","0.6345"] | [] | ["BATO","C2OX","EDGO"] | 150.0000 | 155.0000 | 10 | 10 | false | false | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:11:38Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:05:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:42:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:42:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:42:38Z"} |
| 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-17T19:06:31Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:03:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:27:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:33:19Z"} |
| 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-14T14:33:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:32:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:31:49Z"} |
| 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-11T14:22:03Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:59:46Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:49:29Z"} |
| 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-09T14:49:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:49:29Z"} |
| 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-09T14:49:29Z"} |
| 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-08T16:24:15Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:52:51Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:36:32Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |