core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0aac0-6c33-76f1-af8c-bcef034a81f2 | CRCL | 2026-09-16 11:05 | put_vertical_spread | 2 | 1 | 647 | 425079.00 | short | bid | 81.0800 | 0.5100 | ["78","81"] | ["0.7998","0.7984"] | ["79.63"] | ["XCBO"] | 78.0000 | 81.0000 | 9 | 9 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:05:53Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa90-6f0b-7e93-bd69-de2797ca8138 | CRCL | 2026-09-16 10:13 | put_vertical_spread | 2 | 2 | 100 | 176600.00 | short | bid | 79.5001 | 0.4500 | ["65","75"] | ["0.7844","0.7853"] | ["70.40"] | ["XISX"] | 65.0000 | 75.0000 | 121 | 121 | false | true | false | ||||||||||
| 01a0a681-4e96-77f0-a4e7-a144e2a10e20 | CRCL | 2026-09-15 15:18 | put_vertical_spread | 2 | 1 | 25 | 374975.00 | short | bid | 88.4099 | 10.7500 | ["155","165"] | ["0.9884","1.0228"] | ["155.57"] | ["XMIO"] | 155.0000 | 165.0000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a577-933e-77d2-9558-20aea09fb35f | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 1 | 30 | 100710.00 | short | bid | 89.8550 | 2.9500 | ["95","106"] | ["0.8081","0.8210"] | ["98.23"] | ["XCBO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-8f56-7fc2-8e70-976a29c13eb9 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 38 | 126958.00 | short | bid | 89.8550 | 2.6000 | ["95","106"] | ["0.8081","0.8071"] | ["98.39"] | ["ARCO","XPHO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-8f56-7fc2-8e70-975a9d7e1da4 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 100 | 334050.00 | short | bid | 89.8550 | 2.6000 | ["95","106"] | ["0.8081","0.8066"] | ["98.40"] | ["ARCO","XISX"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-8f56-7fc2-8e70-974673bb1cd4 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 36 | 120276.00 | short | bid | 89.8550 | 2.6000 | ["95","106"] | ["0.8081","0.8071"] | ["98.39"] | ["ARCO","XISX"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-8f56-7fc2-8e70-9731ffdd1c45 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 80 | 267240.00 | short | bid | 89.8550 | 2.6000 | ["95","106"] | ["0.8081","0.8066"] | ["98.40"] | ["ARCO","XPHO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-8786-7662-ada3-74a9a21df443 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 40 | 134080.00 | short | bid | 89.8550 | 3.0000 | ["95","106"] | ["0.8124","0.8118"] | ["98.39"] | ["ARCO","XPHO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-8786-7662-ada3-7492eba71ebc | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 30 | 100875.00 | short | bid | 89.8550 | 3.0000 | ["95","106"] | ["0.8172","0.8157"] | ["98.40"] | ["ARCO","XPHO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-839e-7f82-85ed-580dbea87471 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 32 | 107504.00 | short | bid | 89.8550 | 3.0500 | ["95","106"] | ["0.8160","0.8144"] | ["98.40"] | ["ARCO","XPHO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-7fb6-7221-84c9-037ff015f532 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 32 | 107504.00 | short | bid | 89.8550 | 3.0500 | ["95","106"] | ["0.8160","0.8144"] | ["98.40"] | ["ARCO","XPHO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-77e6-71f2-adad-7b170971b5f5 | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 2 | 122 | 412604.00 | short | bid | 89.8300 | 3.0500 | ["95","106"] | ["0.8198","0.8273"] | ["98.30"] | ["ARCO","EMLD"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a577-77e6-71f2-adad-7b0bb2492c2c | CRCL | 2026-09-15 10:27 | put_vertical_spread | 2 | 7 | 124 | 416580.00 | short | bid | 89.8300 | 3.1806 | ["95","106"] | ["0.8120","0.8163"] | ["98.33"] | ["ARCO","BATO","EMLD","MCRY","XCBO","XMIO","XPHO"] | 95.0000 | 106.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a0a54c-31c6-75d2-81d5-ac226ec5674a | CRCL | 2026-09-15 09:40 | put_vertical_spread | 2 | 4 | 293 | 946275.00 | short | bid | 90.1600 | 6.6119 | ["95","105"] | ["0.8045","0.8102"] | ["98.10"] | ["AMXO","ARCO","C2OX"] | 95.0000 | 105.0000 | 45 | 45 | true | false | false | ||||||||||
| 01a0a0e8-8a51-7892-a9ab-7c38b7f828c8 | CRCL | 2026-09-14 13:13 | put_vertical_spread | 2 | 1 | 10 | 138120.00 | short | bid | 95.0700 | 5.4000 | ["155","165"] | ["0.9197","0.9435"] | ["155.82"] | ["XCBO"] | 155.0000 | 165.0000 | 123 | 123 | false | false | false | ||||||||||
| 01a0a08e-6430-7560-858f-cc6cbe288907 | CRCL | 2026-09-14 11:34 | put_vertical_spread | 2 | 1 | 32 | 127212.00 | short | bid | 93.7700 | 2.8500 | ["101","115"] | ["0.8043","0.8202"] | ["104.65"] | ["XPHO"] | 101.0000 | 115.0000 | 46 | 46 | false | false | false | ||||||||||
| 01a0a08d-4af0-7103-afc8-9984291bd30c | CRCL | 2026-09-14 11:33 | put_vertical_spread | 2 | 2 | 78 | 315315.00 | short | bid | 93.6806 | 3.1000 | ["101","115"] | ["0.8257","0.8442"] | ["104.64"] | ["AMXO","ARCO"] | 101.0000 | 115.0000 | 46 | 46 | false | false | false | ||||||||||
| 01a0a08d-4709-76e1-8ee0-5e852d7acf39 | CRCL | 2026-09-14 11:33 | put_vertical_spread | 2 | 2 | 114 | 458052.00 | short | bid | 93.6806 | 3.6000 | ["101","115"] | ["0.8170","0.8330"] | ["104.66"] | ["ARCO","C2OX"] | 101.0000 | 115.0000 | 46 | 46 | true | false | false | ||||||||||
| 01a08c86-a510-72f1-9a5a-ac4cb56ec17d | CRCL | 2026-09-10 14:13 | put_vertical_spread | 2 | 1 | 50 | 101400.00 | short | bid | 90.4451 | 1.1000 | ["100","101"] | ["1.1542","1.1498"] | ["100.04"] | ["XCBO"] | 100.0000 | 101.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a08191-c630-77e3-833c-0c0aef23fd3d | CRCL | 2026-09-08 11:10 | put_vertical_spread | 2 | 1 | 59 | 121068.00 | short | bid | 98.3495 | 1.9500 | ["92","102"] | ["0.7984","0.8129"] | ["96.54"] | ["XPHO"] | 92.0000 | 102.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a08191-b691-7862-9ffc-9291c85104f0 | CRCL | 2026-09-08 11:10 | put_vertical_spread | 2 | 1 | 61 | 125660.00 | short | bid | 98.2900 | 1.8000 | ["92","102"] | ["0.8007","0.8130"] | ["96.56"] | ["XPHO"] | 92.0000 | 102.0000 | 45 | 45 | false | false | false | ||||||||||
| 01a08189-5221-7451-856a-b8eb90c4d947 | CRCL | 2026-09-08 11:00 | put_vertical_spread | 2 | 3 | 398 | 267257.00 | short | bid | 98.1200 | 1.2400 | ["76","84"] | ["0.8070","0.7888"] | ["82.00"] | ["ARCO","XISX","XPHO"] | 76.0000 | 84.0000 | 45 | 45 | true | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:13:13Z"} |
| 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-15T19:18:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:28:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:40:48Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:13:38Z"} |
| 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-14T15:34:40Z"} |
| 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-14T15:33:38Z"} |
| 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-14T15:33:38Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:14:12Z"} |
| 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-08T15:10:17Z"} |
| 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:10:17Z"} |
| 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:01:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |