core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d93a-3127-7801-994b-0bd75af0c8e0 | GLW | 2026-09-25 11:41 | call_calendar | 2 | 1 | 18 | 291330.00 | short | bid | 155.5500 | 5.8000 | ["75"] | ["7.6936"] | [] | ["XMIO"] | 75.0000 | 75.0000 | 0 | 35 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T15:41:04Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d921-4e0f-7e32-8200-c5eb552332f6 | GLW | 2026-09-25 11:13 | call_diagonal_spread | 2 | 1 | 200 | 173800.00 | long | bid | 155.6350 | 0.4500 | ["165","200"] | ["0.5637","0.6392"] | [] | ["XISX"] | 165.0000 | 200.0000 | 21 | 56 | false | true | |||||||||||
| 01a0d910-b40f-7f30-9087-ce78147b6180 | GLW | 2026-09-25 10:55 | call_diagonal_spread | 2 | 1 | 40 | 522240.00 | unknown | bid | 155.3500 | 6.3500 | ["90","135"] | ["15.2664","0.6139"] | [] | ["XMIO"] | 90.0000 | 135.0000 | 0 | 847 | true | false | |||||||||||
| 01a0d8fe-1287-76b2-aa46-c4f323d9e365 | GLW | 2026-09-25 10:35 | call_diagonal_spread | 2 | 1 | 38 | 613814.00 | short | bid | 155.3800 | 4.1500 | ["75","105"] | ["15.7983","0.6101"] | [] | ["AMXO"] | 75.0000 | 105.0000 | 0 | 847 | true | false | |||||||||||
| 01a0d39d-8417-7803-94cd-49705c1a4bb8 | GLW | 2026-09-24 09:31 | other | 4 | 1 | 15 | 116370.00 | unknown | bid | 150.3600 | 8.8500 | ["160","165","170","175"] | ["0.6076","0.6423","0.6177","0.6968"] | [] | ["C2OX"] | 160.0000 | 175.0000 | 8 | 22 | false | false | |||||||||||
| 01a0c47b-1887-7c92-a2d3-12436b1baa88 | GLW | 2026-09-21 10:59 | call_diagonal_spread | 2 | 3 | 50 | 145124.00 | short | bid | 157.9200 | 1.9000 | ["150","155"] | ["0.5841","0.6414"] | [] | ["AMXO","XCBO","XISX"] | 150.0000 | 155.0000 | 25 | 39 | false | false | |||||||||||
| 01a0c456-8156-7880-a97c-d0a8925f29af | GLW | 2026-09-21 10:19 | call_backspread | 2 | 1 | 30 | 105555.00 | long | bid | 156.9000 | 1.8500 | ["130","160"] | ["0.6013","0.6080"] | ["191.47"] | ["XPHO"] | 130.0000 | 160.0000 | 88 | 88 | false | false | |||||||||||
| 01a0c456-6dcf-7a52-8289-04b897fa9935 | GLW | 2026-09-21 10:19 | call_backspread | 2 | 1 | 122 | 424804.00 | long | bid | 156.8700 | 3.9000 | ["130","160"] | ["0.5965","0.5987"] | ["191.00"] | ["ARCO"] | 130.0000 | 160.0000 | 88 | 88 | false | false | |||||||||||
| 01a0b532-4ba7-7ad1-8896-16cfd087ba46 | GLW | 2026-09-18 11:46 | call_vertical_spread | 2 | 1 | 105 | 276465.00 | short | bid | 151.2200 | 1.3600 | ["125","175"] | ["4.0224","2.9099"] | ["151.25"] | ["XISX"] | 125.0000 | 175.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b4d1-bce8-7362-a730-a97d0bafc2d8 | GLW | 2026-09-18 10:00 | call_diagonal_spread | 2 | 1 | 28 | 521668.00 | unknown | bid | 150.9650 | 4.8000 | ["28","75"] | ["33.7484","0.6240"] | [] | ["XPHO"] | 28.0000 | 75.0000 | 0 | 854 | true | false | |||||||||||
| 01a0afaa-ff83-77c2-927c-a23f29c832df | GLW | 2026-09-17 10:00 | call_diagonal_spread | 2 | 1 | 100 | 234800.00 | short | bid | 153.3200 | 1.3500 | ["142","150"] | ["0.8802","0.5880"] | [] | ["XCBO"] | 142.0000 | 150.0000 | 1 | 29 | false | false | |||||||||||
| 01a0ab2c-b6db-7d11-b110-20198a2f8335 | GLW | 2026-09-16 13:03 | call_diagonal_spread | 2 | 1 | 14 | 236544.00 | long | bid | 145.6300 | 5.2500 | ["70","85"] | ["0.6514","0.6300"] | [] | ["XCBO"] | 70.0000 | 85.0000 | 492 | 856 | false | false | |||||||||||
| 01a0aa78-b0eb-70d1-b172-9e08cdf8b35c | GLW | 2026-09-16 09:47 | put_diagonal_spread | 2 | 2 | 18 | 151068.00 | long | bid | 147.1100 | 4.4111 | ["160","207.5"] | ["0.6496","2.5000"] | [] | ["EMLD","XISX"] | 160.0000 | 207.5000 | 2 | 65 | false | false | |||||||||||
| 01a0a67f-a0e5-7d52-9c17-b1e4cfdfe3e3 | GLW | 2026-09-15 15:16 | put_calendar | 2 | 1 | 100 | 306500.00 | short | bid | 143.5482 | 0.7000 | ["157.5"] | ["0.6581"] | [] | ["C2OX"] | 157.5000 | 157.5000 | 3 | 17 | false | false | |||||||||||
| 01a0a658-5e1e-7970-92a6-8481470d0cb7 | GLW | 2026-09-15 14:33 | call_calendar | 2 | 1 | 164 | 518732.00 | short | bid | 143.9399 | 3.1500 | ["130"] | ["0.7572"] | [] | ["SPHR"] | 130.0000 | 130.0000 | 3 | 31 | false | false | |||||||||||
| 01a0a5f1-66be-7a21-9dd9-c59d387996c9 | GLW | 2026-09-15 12:40 | call_vertical_spread | 2 | 5 | 51 | 126539.00 | short | bid | 143.5000 | 1.6480 | ["125","165"] | ["0.5891","0.5950"] | ["143.27"] | ["BATO","MCRY","XBOX","XCBO"] | 125.0000 | 165.0000 | 31 | 31 | false | false | |||||||||||
| 01a0a5a4-c976-72d3-b234-53d5d27c7265 | GLW | 2026-09-15 11:17 | call_backspread | 2 | 1 | 148 | 145706.00 | long | bid | 143.7400 | 0.9500 | ["185","300"] | ["0.6272","0.6851"] | ["192.41","407.59"] | ["ARCO"] | 185.0000 | 300.0000 | 185 | 185 | false | true | |||||||||||
| 01a0a159-af28-71a3-9dc3-0ee880179262 | GLW | 2026-09-14 15:16 | call_vertical_spread | 2 | 1 | 50 | 135300.00 | short | bid | 144.4200 | 2.5000 | ["160","260"] | ["0.6392","0.6815"] | ["176"] | ["XMIO"] | 160.0000 | 260.0000 | 186 | 186 | false | true | |||||||||||
| 01a0a070-a300-7c63-988e-a8f7804ce604 | GLW | 2026-09-14 11:02 | put_diagonal_spread | 2 | 1 | 10 | 128370.00 | long | bid | 145.4000 | 5.7000 | ["200","210"] | ["0.6589","0.6772"] | [] | ["XCBO"] | 200.0000 | 210.0000 | 67 | 186 | false | false | |||||||||||
| 01a0a025-6930-7f92-acb1-efafaac57015 | GLW | 2026-09-14 09:39 | call_vertical_spread | 2 | 2 | 100 | 305500.00 | short | bid | 149.6100 | 6.9000 | ["160","260"] | ["0.6383","0.6736"] | ["178"] | ["XMIO","XPHO"] | 160.0000 | 260.0000 | 186 | 186 | false | true | |||||||||||
| 01a0915a-4178-74f2-b9eb-dcc319dc3aed | GLW | 2026-09-11 12:43 | put_diagonal_spread | 2 | 3 | 116 | 173304.00 | short | bid | 167.1500 | 1.0000 | ["165","170"] | ["0.5858","0.5785"] | [] | ["EDGO","XCBO","XPHO"] | 165.0000 | 170.0000 | 7 | 21 | false | false | |||||||||||
| 01a08661-3448-7360-9b0c-22eea53272e7 | GLW | 2026-09-09 09:35 | put_vertical_spread | 2 | 1 | 25 | 131200.00 | short | bid | 169.5500 | 3.2500 | ["120","130"] | ["0.6701","0.6688"] | ["125.40"] | ["XMIO"] | 120.0000 | 130.0000 | 646 | 646 | false | true | |||||||||||
| 01a0828b-7fe0-7da2-8529-711ad1a58212 | GLW | 2026-09-08 15:42 | call_diagonal_spread | 2 | 1 | 100 | 374200.00 | long | bid | 167.6300 | 2.0000 | ["150","160"] | ["0.6893","0.6447"] | [] | ["XCBO"] | 150.0000 | 160.0000 | 10 | 38 | false | false | |||||||||||
| 01a0825a-84d1-7741-b019-41fd86768105 | GLW | 2026-09-08 14:49 | call_diagonal_spread | 2 | 1 | 36 | 251136.00 | short | bid | 168.0300 | 5.4500 | ["135","145"] | ["0.8581","0.6630"] | [] | ["XCBO"] | 135.0000 | 145.0000 | 10 | 101 | false | false | |||||||||||
| 01a06dd2-1c95-7b83-8190-72c536fcd2d9 | GLW | 2026-09-04 15:07 | call_vertical_spread | 2 | 1 | 10 | 107900.00 | short | bid | 152.0800 | 6.3000 | ["150","155"] | ["0.6374","0.6366"] | ["151.76"] | ["XMIO"] | 150.0000 | 155.0000 | 651 | 651 | false | false | |||||||||||
| 01a06d23-4e95-7012-875d-5bdadb2a92bf | GLW | 2026-09-04 11:57 | call_vertical_spread | 2 | 4 | 150 | 111469.00 | short | bid | 152.9400 | 1.6199 | ["149","150"] | ["1.0712","0.9978"] | ["149.90"] | ["EDGO","MCRY","XCBO","XISX"] | 149.0000 | 150.0000 | 0 | 0 | false | false | |||||||||||
| 01a06d23-42dd-7640-86c1-eba6a68c468d | GLW | 2026-09-04 11:57 | call_vertical_spread | 2 | 5 | 154 | 113707.00 | short | bid | 152.9100 | 1.7200 | ["149","150"] | ["1.0769","0.9966"] | ["149.90"] | ["AMXO","ARCO","BATO","XCBO","XISX"] | 149.0000 | 150.0000 | 0 | 0 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:14:11Z"} |
| 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-25T14:55:53Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:35:45Z"} |
| 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-24T13:31:53Z"} |
| 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-21T15:00:05Z"} |
| 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-21T14:20:07Z"} |
| 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-21T14:20:07Z"} |
| 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-18T15:46:07Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:00:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:00:20Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:04:28Z"} |
| 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-16T13:47:28Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:16:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:33:28Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:41:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:17:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:16:44Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:02:41Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:40:01Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:43:26Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:35:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:42:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:49:49Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:08:26Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:57:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:57:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |