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 | directiontext | net_side |
|---|
| 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 |
|---|
| 01a06da8-786d-74b1-99a9-07c12e4fc68d | KLAC | 2026-09-04 14:22 | call_vertical_spread | 2 | 2 | 34 | 200175.00 | long | ask | 185.5700 | 4.6206 | ["172","224"] | ["0.5745","0.5824"] | ["191.01"] | ["ARCO","XPHO"] | 172.0000 | 224.0000 | 196 | 196 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:22:41Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06daf-eaad-7133-9e3f-adc0626fbe1c | KLAC | 2026-09-04 14:30 | call_vertical_spread | 2 | 1 | 21 | 123816.00 | long | ask | 185.6750 | 1.7000 | ["174","222"] | ["0.5790","0.5859"] | ["191.54"] | ["AMXO"] | 174.0000 | 222.0000 | 196 | 196 | false | false | false | true | |||||||||
| 01a06db0-0605-7cc1-80e7-f06d757ea862 | KLAC | 2026-09-04 14:30 | call_vertical_spread | 2 | 1 | 20 | 118020.00 | long | ask | 185.6700 | 1.7000 | ["174","222"] | ["0.5801","0.5860"] | ["191.59"] | ["EDGO"] | 174.0000 | 222.0000 | 196 | 196 | false | false | false | true | |||||||||
| 01a06ddb-8e8d-7d73-8ccd-22dbde57eb5e | KLAC | 2026-09-04 15:18 | call_diagonal_spread_bearish | 2 | 1 | 10 | 220450.00 | long | ask | 184.5250 | 23.5000 | ["76","84"] | ["0.9066","0.6140"] | [] | ["BATO"] | 76.0000 | 84.0000 | 105 | 504 | false | false | true | true | |||||||||
| 01a06dfe-4d15-7de1-a0b5-113fac32f16b | KLAC | 2026-09-04 15:56 | call_diagonal_spread_bullish | 2 | 2 | 286 | 606606.00 | long | ask | 186.1700 | 4.0000 | ["260","390"] | ["0.5792","0.5997"] | [] | ["ARCO","C2OX"] | 260.0000 | 390.0000 | 196 | 286 | false | true | true | true | |||||||||
| 01a08691-29a0-7ba2-80f5-9ea868970c99 | KLAC | 2026-09-09 10:27 | put_diagonal_spread | 2 | 2 | 70 | 199395.00 | long | ask | 184.4350 | 1.5000 | ["182.5","185"] | ["0.6111","0.6072"] | [] | ["ARCO","C2OX"] | 182.5000 | 185.0000 | 9 | 100 | false | false | true | true | |||||||||
| 01a08691-25b8-7be1-969c-7720d62b4dbc | KLAC | 2026-09-09 10:27 | put_diagonal_spread | 2 | 2 | 80 | 228160.00 | long | ask | 184.4400 | 1.6000 | ["182.5","185"] | ["0.6126","0.6078"] | [] | ["ARCO","C2OX"] | 182.5000 | 185.0000 | 9 | 100 | true | false | true | true | |||||||||
| 01a086f9-6538-7071-8cd0-19f50355f6ad | KLAC | 2026-09-09 12:21 | call_diagonal_spread | 2 | 1 | 10 | 215720.00 | long | ask | 181.4850 | 29.6000 | ["76","84"] | ["1.0187","0.6406"] | [] | ["XCBO"] | 76.0000 | 84.0000 | 100 | 499 | false | false | true | true | |||||||||
| 01a08b99-dbe1-78a1-b627-804510399a24 | KLAC | 2026-09-10 09:55 | straddle | 2 | 1 | 40 | 178400.00 | long | ask | 174.3050 | 2.6000 | ["185"] | ["0.5960"] | ["140.40","229.60"] | ["ARCO"] | 185.0000 | 185.0000 | 99 | 99 | false | false | false | false | |||||||||
| 01a08b99-e798-7942-9314-ee2d372e0ab5 | KLAC | 2026-09-10 09:55 | straddle | 2 | 1 | 40 | 179080.00 | long | ask | 174.4000 | 1.8000 | ["185"] | ["0.5984"] | ["140.23","229.77"] | ["ARCO"] | 185.0000 | 185.0000 | 99 | 99 | false | false | false | false | |||||||||
| 01a08c21-f3b8-7562-a06f-194812d2682d | KLAC | 2026-09-10 12:23 | call_diagonal_spread | 2 | 1 | 13 | 269230.00 | long | ask | 179.8200 | 16.4000 | ["76","84"] | ["1.0787","0.5615"] | [] | ["XMIO"] | 76.0000 | 84.0000 | 99 | 498 | false | false | true | true | |||||||||
| 01a0aab3-2d93-7821-b361-844d18219111 | KLAC | 2026-09-16 10:51 | call_diagonal_spread | 2 | 1 | 20 | 140200.00 | long | ask | 170.2800 | 3.1000 | ["200","250"] | ["0.5745","0.5907"] | [] | ["XPHO"] | 200.0000 | 250.0000 | 274 | 856 | false | true | true | true | |||||||||
| 01a0ab3a-3fb3-74a0-9a61-0c5f37b62a25 | KLAC | 2026-09-16 13:18 | call_vertical_spread | 2 | 1 | 30 | 139470.00 | long | ask | 169.8900 | 1.8000 | ["250","300"] | ["0.5853","0.5903"] | ["257.65"] | ["BATO"] | 250.0000 | 300.0000 | 492 | 492 | false | true | false | true | |||||||||
| 01a0b083-f67a-7101-81c1-eae15607cd8d | KLAC | 2026-09-17 13:57 | call_vertical_spread | 2 | 1 | 5 | 126560.00 | long | ask | 168.6900 | 9.2000 | ["42","43"] | ["12.7061","12.6011"] | ["42.98"] | ["XCBO"] | 42.0000 | 43.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0b4c3-a770-7da2-b075-0ee9c1aa5e69 | KLAC | 2026-09-18 09:45 | call_vertical_spread | 2 | 1 | 90 | 114480.00 | long | ask | 172.3500 | 7.7000 | ["164","166"] | ["1.9939","1.8271"] | ["165.88"] | ["XISX"] | 164.0000 | 166.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0c450-7677-74a2-a048-132351002859 | KLAC | 2026-09-21 10:13 | call_vertical_spread | 2 | 1 | 60 | 180060.00 | long | ask | 179.8400 | 1.6000 | ["184","188"] | ["0.5897","0.5888"] | ["185.65"] | ["BATO"] | 184.0000 | 188.0000 | 60 | 60 | false | true | false | true | |||||||||
| 01a0c521-e3bf-7452-8e1f-0fc2130f1728 | KLAC | 2026-09-21 14:02 | call_vertical_spread | 2 | 3 | 31 | 203371.00 | long | ask | 184.1600 | 4.2000 | ["190","200"] | ["0.5532","0.5530"] | ["193.75"] | ["ARCO","EMLD","SPHR"] | 190.0000 | 200.0000 | 269 | 269 | false | true | false | true | |||||||||
| 01a0c954-8537-7af3-9ec9-ad674c2ff62d | KLAC | 2026-09-22 09:35 | call_diagonal_spread | 2 | 7 | 7 | 138377.00 | long | bid | 182.2650 | 11.1857 | ["80","95"] | ["0.6358","0.4749"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 80.0000 | 95.0000 | 268 | 360 | false | false | true | true | |||||||||
| 01a0ca3f-9ccf-7ae1-9d0f-87a369b3344f | KLAC | 2026-09-22 13:52 | call_diagonal_spread | 2 | 3 | 23 | 297153.00 | long | bid | 185.7700 | 10.8000 | ["122","130"] | ["0.4733","0.5298"] | [] | ["ARCO","XCBO","XMIO"] | 122.0000 | 130.0000 | 115 | 178 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:31:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:31:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:18:22Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:56:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:27:55Z"} |
| 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:27:55Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:22:02Z"} |
| 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-10T13:55:20Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:55:20Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:24:06Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:51:28Z"} |
| 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-16T17:19:01Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:57:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:45:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:13:33Z"} |
| 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-21T18:02:34Z"} |
| 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-22T13:36:07Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:52:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |