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 |
|---|
| 01a0c53a-e9ff-75f3-8a64-43d874f0ffff | CRM | 2026-09-21 14:29 | call_vertical_spread | 2 | 1 | 4 | 104272.00 | long | ask | 237.3703 | 2.9000 | ["105","110"] | ["3.7442","3.5713"] | ["109.98"] | ["XPHO"] | 105.0000 | 110.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:29:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b050-8a6b-7b01-bed0-372fb0cba8af | CRM | 2026-09-17 13:01 | call_vertical_spread | 2 | 1 | 10 | 147370.00 | long | ask | 243.3250 | 5.9500 | ["240","260"] | ["0.4547","0.4517"] | ["247.75"] | ["BATO"] | 240.0000 | 260.0000 | 855 | 855 | false | false | false | ||||||||||
| 01a0afa8-926b-7680-9f24-f600546defcd | CRM | 2026-09-17 09:57 | call_vertical_spread | 2 | 1 | 65 | 900510.00 | long | ask | 241.9700 | 4.7500 | ["200","350"] | ["0.4590","0.4510"] | ["250"] | ["XISX"] | 200.0000 | 350.0000 | 855 | 855 | true | false | false | ||||||||||
| 01a0afa2-54c3-7473-811c-a9ff156d1d7a | CRM | 2026-09-17 09:50 | call_vertical_spread | 2 | 1 | 65 | 953940.00 | short | bid | 243.2900 | 6.5000 | ["170","260"] | ["0.4604","0.4550"] | ["216"] | ["XMIO"] | 170.0000 | 260.0000 | 491 | 491 | false | false | false | ||||||||||
| 01a0aba1-e2f3-7d92-b291-f83903c5a166 | CRM | 2026-09-16 15:11 | call_vertical_spread | 2 | 1 | 20 | 161560.00 | short | bid | 251.1300 | 3.6000 | ["210","212.5"] | ["1.4433","1.3527"] | [] | ["ARCO"] | 210.0000 | 212.5000 | 2 | 2 | false | false | false | ||||||||||
| 01a0ab34-09db-7712-9ebd-22e6f5ab90f4 | CRM | 2026-09-16 13:11 | call_vertical_spread | 2 | 1 | 6 | 141624.00 | long | ask | 250.6150 | 2.9000 | ["130","135"] | ["4.5154","4.4007"] | ["134.98"] | ["XMIO"] | 130.0000 | 135.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0aa99-19cb-7760-a7f1-28e2e8167f2d | CRM | 2026-09-16 10:22 | call_vertical_spread | 2 | 1 | 34 | 110976.00 | long | ask | 253.5925 | 1.2000 | ["250","310"] | ["0.4472","0.4441"] | ["268.90"] | ["XCBO"] | 250.0000 | 310.0000 | 93 | 93 | false | false | false | ||||||||||
| 01a0a5b9-dbfe-7c41-8352-e5db7ec43235 | CRM | 2026-09-15 11:40 | call_vertical_spread | 2 | 1 | 14 | 110600.00 | unknown | — | 259.5000 | 1.6000 | ["210","230"] | ["1.1879","0.8116"] | [] | ["XPHO"] | 210.0000 | 230.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0a0f4-c720-7650-b6c1-94db98234984 | CRM | 2026-09-14 13:26 | call_vertical_spread | 2 | 1 | 30 | 147240.00 | unknown | — | 258.2200 | 2.2500 | ["380","390"] | ["0.4569","0.4570"] | [] | ["XISX"] | 380.0000 | 390.0000 | 494 | 494 | false | true | false | true | false | ||||||||
| 01a0a0f3-c551-7233-bead-2d9c90660883 | CRM | 2026-09-14 13:25 | call_vertical_spread | 2 | 1 | 35 | 171675.00 | unknown | — | 258.1400 | 2.2500 | ["380","390"] | ["0.4569","0.4572"] | [] | ["BATO"] | 380.0000 | 390.0000 | 494 | 494 | false | true | false | true | false | ||||||||
| 01a0a0ad-8cc0-76d2-8efc-1bf57888c1a5 | CRM | 2026-09-14 12:08 | call_vertical_spread | 2 | 1 | 300 | 1366800.00 | long | ask | 257.0200 | 0.9000 | ["225","245"] | ["0.6974","0.5118"] | ["243.62"] | ["EDGO"] | 225.0000 | 245.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0a0ac-3501-71f0-a2bf-f9580edd0bcf | CRM | 2026-09-14 12:07 | call_vertical_spread | 2 | 5 | 338 | 196079.00 | long | ask | 257.1100 | 0.3400 | ["270","290"] | ["0.4075","0.4198"] | ["273.34"] | ["AMXO","EDGO","XCBO","XMIO","XPHO"] | 270.0000 | 290.0000 | 18 | 18 | false | true | false | ||||||||||
| 01a0a092-82e0-7c52-9fec-f5f7163fc65c | CRM | 2026-09-14 11:39 | call_vertical_spread | 2 | 1 | 20 | 167120.00 | unknown | — | 256.4500 | 2.3000 | ["205","225"] | ["1.0504","0.7128"] | [] | ["XPHO"] | 205.0000 | 225.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a091f2-c088-70f0-b171-209790b7ac3d | CRM | 2026-09-11 15:29 | call_vertical_spread | 2 | 2 | 10 | 100011.00 | unknown | — | 248.4200 | 5.3000 | ["200","240"] | ["0.4509","0.4395"] | [] | ["XCBO","XISX"] | 200.0000 | 240.0000 | 189 | 189 | false | false | false | true | false | ||||||||
| 01a090ea-3db1-7433-a72b-5bb65f82e26f | CRM | 2026-09-11 10:41 | call_vertical_spread | 2 | 2 | 10 | 119900.00 | short | bid | 247.7800 | 2.5000 | ["185","190"] | ["5.9330","5.4618"] | [] | ["EMLD","XISX"] | 185.0000 | 190.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a08bf5-d2d8-7190-adc2-67d20755e63d | CRM | 2026-09-10 11:35 | call_vertical_spread | 2 | 1 | 12 | 142536.00 | unknown | — | 245.5750 | 2.1500 | ["185","187.5"] | ["2.0933","2.1060"] | [] | ["XPHO"] | 185.0000 | 187.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a08bf5-c721-7a70-b0a0-6b3295ddbf0d | CRM | 2026-09-10 11:35 | call_vertical_spread | 2 | 1 | 12 | 142536.00 | unknown | — | 245.6000 | 2.1500 | ["185","187.5"] | ["1.8584","1.9697"] | [] | ["XISX"] | 185.0000 | 187.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a08bf5-bf50-7490-bb7f-00f00c9effb9 | CRM | 2026-09-10 11:35 | call_vertical_spread | 2 | 1 | 12 | 142536.00 | unknown | — | 245.6000 | 2.1500 | ["185","187.5"] | ["1.8584","1.9697"] | [] | ["XISX"] | 185.0000 | 187.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0824d-f5f9-7e73-a210-482be5b16eb9 | CRM | 2026-09-08 14:35 | call_vertical_spread | 2 | 1 | 30 | 108780.00 | short | bid | 245.9900 | 4.8000 | ["227.5","230"] | ["0.6970","0.6480"] | ["229.9"] | ["XISX"] | 227.5000 | 230.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0819f-fed0-73e2-8d82-8294e6cd70b9 | CRM | 2026-09-08 11:25 | call_vertical_spread | 2 | 1 | 12 | 307104.00 | unknown | — | 250.2900 | 5.1500 | ["120","125"] | ["3.3181","3.2009"] | [] | ["XISX"] | 120.0000 | 125.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0819f-f700-7242-8f1e-4292be15779b | CRM | 2026-09-08 11:25 | call_vertical_spread | 2 | 1 | 12 | 307104.00 | unknown | — | 250.2900 | 5.1500 | ["120","125"] | ["3.3181","3.2009"] | [] | ["XISX"] | 120.0000 | 125.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0819f-dba9-7c20-b2f6-41bb3829f7df | CRM | 2026-09-08 11:25 | call_vertical_spread | 2 | 1 | 12 | 307080.00 | long | ask | 250.2900 | 5.2000 | ["120","125"] | ["3.2850","3.1724"] | ["124.98"] | ["XMIO"] | 120.0000 | 125.0000 | 3 | 3 | false | false | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:01:34Z"} |
| 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-17T13:57:40Z"} |
| 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-17T13:50:47Z"} |
| 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-16T19:11:47Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:12:21Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:22:39Z"} |
| 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-15T15:40:26Z"} |
| 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-14T17:26:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:25:44Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:08:50Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:07:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:39:13Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:30:18Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:41:04Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:36:00Z"} |
| 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-10T15:36:00Z"} |
| 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-10T15:36:00Z"} |
| 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-08T18:36:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:25:45Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:25:45Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:25:45Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |