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 | directiontext |
|---|
| 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 |
|---|
| 01a0a11e-24f8-7f70-9185-fde228f86931 | NMAX | 2026-09-14 14:11 | call_vertical_spread | 2 | 1 | 88 | 102168.00 | long | ask | 11.4800 | 0.8000 | ["5.5","6"] | ["4.2114","3.8799"] | ["5.99"] | ["XCBO"] | 5.5000 | 6.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:12:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08ce1-d8b8-7f40-846c-93529bcd2cf2 | NMAX | 2026-09-10 15:53 | put_vertical_spread | 2 | 1 | 262 | 293440.00 | unknown | — | 10.9300 | 0.4000 | ["16","17"] | ["3.8842","4.3727"] | [] | ["XCBO"] | 16.0000 | 17.0000 | 1 | 1 | false | false | false | true | false | mlat | |||||||
| 01a08cdf-ec88-7ab3-abcf-0b05eac8a14b | NMAX | 2026-09-10 15:51 | put_vertical_spread | 2 | 1 | 276 | 469200.00 | unknown | — | 10.9500 | 0.4000 | ["19","20"] | ["5.6606","6.0708"] | [] | ["XCBO"] | 19.0000 | 20.0000 | 1 | 1 | false | false | false | true | false | mlat | |||||||
| 01a08cbb-9ba8-7ea2-8243-25f8795fbe9c | NMAX | 2026-09-10 15:11 | put_vertical_spread | 2 | 1 | 188 | 322420.00 | long | ask | 10.9100 | 0.5000 | ["19","20"] | ["6.5895","7.0358"] | ["19.01"] | ["XISX"] | 19.0000 | 20.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08cbb-0350-7490-b410-483b43de3f99 | NMAX | 2026-09-10 15:10 | put_vertical_spread | 2 | 1 | 88 | 147752.00 | long | ask | 10.9100 | 1.4000 | ["19","20"] | ["6.5895","8.1023"] | ["19.01"] | ["XMIO"] | 19.0000 | 20.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08cba-8a38-7263-8a69-def08a7eaf4e | NMAX | 2026-09-10 15:10 | put_vertical_spread | 2 | 1 | 88 | 130944.00 | short | bid | 10.9100 | 1.2000 | ["18","19"] | ["7.1007","6.5895"] | ["0","18"] | ["XCBO"] | 18.0000 | 19.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08cb9-fd98-7ff1-b3d1-893c52d0bef6 | NMAX | 2026-09-10 15:09 | put_vertical_spread | 2 | 1 | 88 | 132264.00 | long | ask | 10.9050 | 4.6000 | ["18","19"] | ["16.5043","6.5318"] | ["18.01"] | ["XCBO"] | 18.0000 | 19.0000 | 1 | 1 | true | false | false | true | |||||||||
| 01a08cb9-8098-7f83-8c0d-3f3f3c45a25a | NMAX | 2026-09-10 15:09 | put_vertical_spread | 2 | 1 | 88 | 164736.00 | short | bid | 10.9050 | 1.5000 | ["20","21"] | ["8.0612","7.3906"] | ["0","20"] | ["XCBO"] | 20.0000 | 21.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08cb8-f7e0-7532-812e-313658f2fe8d | NMAX | 2026-09-10 15:08 | put_vertical_spread | 2 | 1 | 88 | 172568.00 | long | ask | 10.9050 | 3.6000 | ["20","21"] | ["8.1532","8.5091"] | ["20.01"] | ["XCBO"] | 20.0000 | 21.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08cb8-8e68-71b0-b76d-8ea7f23edd10 | NMAX | 2026-09-10 15:08 | put_vertical_spread | 2 | 1 | 88 | 212608.00 | short | bid | 10.9050 | 3.8000 | ["22","23"] | ["11.1292","11.5650"] | ["0","22"] | ["XCBO"] | 22.0000 | 23.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08cb8-5ba0-79c0-84b5-0aef91387c64 | NMAX | 2026-09-10 15:08 | put_vertical_spread | 2 | 1 | 88 | 209000.00 | short | bid | 10.9050 | 3.8000 | ["22","23"] | ["9.6509","9.9746"] | ["22.01"] | ["XISX"] | 22.0000 | 23.0000 | 1 | 1 | true | false | false | true | |||||||||
| 01a08679-8ea8-76e0-8bb3-01198eec0189 | NMAX | 2026-09-09 10:01 | put_vertical_spread | 2 | 1 | 90 | 197100.00 | unknown | — | 10.4700 | 1.8000 | ["21","22"] | ["7.3498","7.6652"] | [] | ["XCBO"] | 21.0000 | 22.0000 | 2 | 2 | false | false | false | true | false | mlat | |||||||
| 01a08677-aa48-7953-8825-229c29101d17 | NMAX | 2026-09-09 09:59 | put_vertical_spread | 2 | 1 | 88 | 192456.00 | long | ask | 10.4553 | 1.9000 | ["21","22"] | ["7.2825","7.5963"] | ["21.01"] | ["XCBO"] | 21.0000 | 22.0000 | 2 | 2 | true | false | false | true | |||||||||
| 01a06df8-f5e5-79d3-85eb-bde748c13178 | NMAX | 2026-09-04 15:50 | put_vertical_spread | 2 | 1 | 170 | 399500.00 | unknown | — | 10.6650 | 2.6000 | ["22","23"] | ["4.5476","4.7161"] | [] | ["XCBO"] | 22.0000 | 23.0000 | 7 | 7 | false | false | false | true | false | mlat | |||||||
| 01a06df8-d6a6-79c3-99e3-3461649deb55 | NMAX | 2026-09-04 15:50 | put_vertical_spread | 2 | 1 | 80 | 188000.00 | unknown | — | 10.6650 | 2.6000 | ["22","23"] | ["4.5476","4.7161"] | [] | ["XCBO"] | 22.0000 | 23.0000 | 7 | 7 | false | false | false | true | false | mlat | |||||||
| 01a06df6-5dd5-7b11-a784-209c7afc72ad | NMAX | 2026-09-04 15:47 | put_vertical_spread | 2 | 1 | 249 | 584901.00 | unknown | — | 10.6600 | 2.7000 | ["22","23"] | ["4.5379","4.7064"] | [] | ["XISX"] | 22.0000 | 23.0000 | 7 | 7 | true | false | false | true | false | mlat | |||||||
| 01a06df4-2f3d-7f92-8e0c-75da90811f50 | NMAX | 2026-09-04 15:45 | call_vertical_spread | 2 | 1 | 321 | 590640.00 | unknown | — | 10.6600 | 0.4000 | ["1","2"] | ["9.0201","6.2771"] | [] | ["XCBO"] | 1.0000 | 2.0000 | 7 | 7 | false | false | false | true | false | mlat | |||||||
| 01a06df3-8b2d-7360-b228-1e6ca706e1ac | NMAX | 2026-09-04 15:44 | call_vertical_spread | 2 | 1 | 80 | 147120.00 | long | ask | 10.6700 | 0.6000 | ["1","2"] | ["8.0387","5.9791"] | ["1.99"] | ["XISX"] | 1.0000 | 2.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a06df3-15fd-7c00-8381-cbbcd4939542 | NMAX | 2026-09-04 15:43 | call_vertical_spread | 2 | 1 | 240 | 441360.00 | long | ask | 10.6700 | 0.6000 | ["1","2"] | ["8.0387","5.9791"] | ["1.99"] | ["XISX"] | 1.0000 | 2.0000 | 7 | 7 | true | false | false | true | |||||||||
| 01a06de3-b096-7cc0-a594-c79527aeb0d3 | NMAX | 2026-09-04 15:27 | put_vertical_spread | 2 | 1 | 188 | 115244.00 | long | ask | 10.7601 | 1.1500 | ["13.5","14"] | ["21.0952","22.7603"] | ["13.51"] | ["XISX"] | 13.5000 | 14.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06dde-49c5-7833-981d-c5fbcdc436e4 | NMAX | 2026-09-04 15:21 | put_vertical_spread | 2 | 1 | 188 | 115244.00 | long | ask | 10.7510 | 1.1500 | ["13.5","14"] | ["18.9077","20.3566"] | ["13.51"] | ["XISX"] | 13.5000 | 14.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06ddc-fdbd-7381-b186-c27dfd0f0298 | NMAX | 2026-09-04 15:19 | put_vertical_spread | 2 | 1 | 144 | 221616.00 | long | ask | 10.7750 | 3.0000 | ["18","19"] | ["65.1576","65.4560"] | ["18.01"] | ["XISX"] | 18.0000 | 19.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06ddb-965d-7c82-aad1-a0aaab8b19ec | NMAX | 2026-09-04 15:18 | put_vertical_spread | 2 | 1 | 248 | 381672.00 | long | ask | 10.7800 | 3.0000 | ["18","19"] | ["64.0629","64.3675"] | ["18.01"] | ["XISX"] | 18.0000 | 19.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06dda-59f5-7291-b4f3-337146820b10 | NMAX | 2026-09-04 15:16 | call_vertical_spread | 2 | 1 | 188 | 165628.00 | long | ask | 10.7700 | 1.1000 | ["6","6.5"] | ["46.9836","48.8834"] | ["6.49"] | ["XISX"] | 6.0000 | 6.5000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06dd9-f465-7221-a918-ddc8e6ce3ae5 | NMAX | 2026-09-04 15:16 | put_vertical_spread | 2 | 1 | 188 | 439732.00 | long | ask | 10.7700 | 4.6000 | ["22","23"] | ["87.3112","87.0906"] | ["22.01"] | ["XISX"] | 22.0000 | 23.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06dd9-aa2e-7073-a776-71f74644ae76 | NMAX | 2026-09-04 15:16 | call_vertical_spread | 2 | 1 | 188 | 165628.00 | long | ask | 10.7700 | 1.1000 | ["6","6.5"] | ["46.5883","48.4721"] | ["6.49"] | ["XISX"] | 6.0000 | 6.5000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06da6-1edd-7bb3-8ee2-a3ff62bdfbd9 | NMAX | 2026-09-04 14:19 | put_vertical_spread | 2 | 1 | 222 | 519258.00 | long | ask | 10.7246 | 4.6000 | ["22","23"] | ["56.9261","56.7419"] | ["22.01"] | ["XISX"] | 22.0000 | 23.0000 | 0 | 0 | false | false | false | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:53:34Z"} |
| 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-10T19:51:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:12:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:11:34Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:10:54Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:10:14Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:09:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:09:11Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:08:31Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:08:31Z"} |
| 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-09T14:02:05Z"} |
| 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-09T14:00:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:50:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:50:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:47:46Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:45:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:44:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:44:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:27:33Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:21:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:20:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:17:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:17:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:16:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:20:35Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |