core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg508,354 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 |
|---|
| 01a0d914-943f-7ac0-9100-aff8b50dda30 | RTX | 2026-09-25 10:59 | call_diagonal_spread | 2 | 1 | 42 | 259014.00 | short | ask | 188.0800 | 5.5500 | ["180","210"] | ["0.2656","0.2534"] | [] | ["ARCO"] | 180.0000 | 210.0000 | 483 | 847 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T15:00:17Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d900-25c7-7d93-ab20-86d362187d99 | RTX | 2026-09-25 10:37 | other | 4 | 2 | 32 | 153723.00 | unknown | ask | 188.4900 | 2.9700 | ["155","195","202.5","230"] | ["0.2527","0.5930","0.2340","0.3108"] | [] | ["AMXO","XISX"] | 155.0000 | 230.0000 | 0 | 483 | false | false | true | ||||||||||
| 01a0d8c2-615c-7ac1-b6ef-cf3a113e38be | RTX | 2026-09-25 09:30 | call_calendar | 2 | 1 | 25 | 320500.00 | long | bid | 187.9050 | 7.4000 | ["125"] | ["0.5311"] | [] | ["XISX"] | 125.0000 | 125.0000 | 56 | 112 | false | false | true | ||||||||||
| 01a0d4fa-7437-73b1-8113-79f0ffa253fa | RTX | 2026-09-24 15:52 | put_vertical_spread | 2 | 2 | 15 | 100016.00 | unknown | ask | 188.9300 | 5.9500 | ["220","225"] | ["0.3500","0.3991"] | ["189.16"] | ["AMXO","XPHO"] | 220.0000 | 225.0000 | 22 | 22 | false | false | false | ||||||||||
| 01a0cfd9-d4f6-7f22-b282-383e7c890839 | RTX | 2026-09-23 15:59 | call_vertical_spread | 2 | 3 | 105 | 164467.00 | short | bid | 192.1950 | 3.8500 | ["190","195"] | ["0.3107","0.3063"] | ["192.55"] | ["C2OX","XISX","XMIO"] | 190.0000 | 195.0000 | 37 | 37 | true | false | |||||||||||
| 01a0cec7-efc7-7a91-870e-8ba99adc8a96 | RTX | 2026-09-23 11:00 | call_diagonal_spread | 2 | 1 | 15 | 254250.00 | short | bid | 193.4900 | 5.9500 | ["110","115"] | ["0.6232","0.3200"] | [] | ["XISX"] | 110.0000 | 115.0000 | 114 | 485 | false | false | true | ||||||||||
| 01a0b612-2457-7c73-bde6-80eb4d693b3f | RTX | 2026-09-18 15:50 | call_diagonal_spread | 2 | 1 | 15 | 273375.00 | unknown | — | 193.7600 | 6.8000 | ["100","120"] | ["0.4512","0.1787"] | [] | ["XPHO"] | 100.0000 | 120.0000 | 490 | 854 | false | false | true | true | false | ||||||||
| 01a0b5ae-bf07-7890-aa1c-7923474c74cc | RTX | 2026-09-18 14:02 | put_vertical_spread | 2 | 2 | 167 | 158521.00 | long | ask | 192.3200 | 1.3329 | ["190","195"] | ["0.2292","0.2273"] | ["192.55"] | ["XISX"] | 190.0000 | 195.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0b50a-d22f-7f40-ab2a-acaee5ee72ee | RTX | 2026-09-18 11:02 | put_vertical_spread | 2 | 1 | 206 | 216300.00 | short | bid | 191.4700 | 0.5500 | ["190","195"] | ["0.2404","0.2247"] | ["192.70"] | ["C2OX"] | 190.0000 | 195.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0b0b4-39f3-7d32-99f0-d0c1e63eaadf | RTX | 2026-09-17 14:49 | put_diagonal_spread | 2 | 1 | 19 | 107920.00 | unknown | — | 193.2901 | 5.4000 | ["210","230"] | ["1.7045","0.5640"] | [] | ["XBOX"] | 210.0000 | 230.0000 | 1 | 29 | false | false | true | true | false | ||||||||
| 01a0b0b2-da63-7662-b077-151e383968e2 | RTX | 2026-09-17 14:48 | other | 4 | 1 | 186 | 1082970.00 | unknown | — | 193.2951 | 10.1000 | ["202.5","205","210","220"] | ["1.2178","1.3891","1.7060","0.4601"] | [] | ["XBOX"] | 202.5000 | 220.0000 | 1 | 29 | true | false | true | true | false | ||||||||
| 01a0afa0-12a4-7db3-8891-c283010919ad | RTX | 2026-09-17 09:48 | other | 4 | 1 | 55 | 141900.00 | unknown | — | 196.2900 | 4.6100 | ["185","220"] | ["0.4705","0.5325"] | [] | ["SPHR"] | 185.0000 | 220.0000 | 1 | 29 | false | false | true | true | false | ||||||||
| 01a0aa7d-a674-7f83-80c4-df410558ffee | RTX | 2026-09-16 09:52 | call_calendar | 2 | 1 | 5 | 100845.00 | short | ask | 195.5050 | 6.1000 | ["100"] | ["0.4421"] | [] | ["XMIO"] | 100.0000 | 100.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0a5ec-03d6-7cd1-b36e-f9b3634e08f0 | RTX | 2026-09-15 12:35 | call_diagonal_spread | 2 | 1 | 29 | 291450.00 | long | bid | 196.6950 | 6.2000 | ["150","190"] | ["0.2266","0.2460"] | [] | ["XMIO"] | 150.0000 | 190.0000 | 493 | 857 | false | false | true | ||||||||||
| 01a0a5a0-0a9d-7b91-bd0f-62155fd96264 | RTX | 2026-09-15 11:12 | put_diagonal_spread | 2 | 2 | 866 | 515270.00 | unknown | — | 193.9500 | 0.5100 | ["180","195"] | ["0.2872","0.2870"] | [] | ["AMXO"] | 180.0000 | 195.0000 | 3 | 66 | false | false | true | true | false | ||||||||
| 01a08c98-1db8-7302-a18b-1ff4cd0ba354 | RTX | 2026-09-10 14:32 | other | 3 | 1 | 124 | 433440.00 | unknown | — | 197.2299 | 8.1000 | ["205","210","220"] | ["0.9169","1.3748","0.6741"] | [] | ["XBOX"] | 205.0000 | 220.0000 | 1 | 8 | true | false | true | true | false | ||||||||
| 01a08c92-2a48-7d43-892e-cd4286979aa9 | RTX | 2026-09-10 14:26 | call_diagonal_spread | 2 | 1 | 34 | 153238.00 | short | ask | 197.2850 | 3.4500 | ["175","195"] | ["0.4535","0.2665"] | [] | ["ARCO"] | 175.0000 | 195.0000 | 8 | 280 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:37:43Z"} |
| 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-25T13:30:06Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:53:07Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:59:16Z"} |
| 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-23T15:00:22Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:50:46Z"} |
| 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-18T18:02:12Z"} |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:49:56Z"} |
| 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:48:46Z"} |
| 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-17T13:48:31Z"} |
| 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-16T13:52:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:12:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:33:02Z"} |
| 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-10T18:26:51Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |