core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0a58a-966e-72f0-a732-619a4ffc9ded | SPOT | 2026-09-15 10:48 | other | 4 | 1 | 100 | 391600.00 | unknown | — | 554.2400 | 6.2800 | ["540","580","630"] | ["0.4804","0.4284","0.3752"] | [] | ["EDGO"] | 540.0000 | 630.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:48:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a141-1261-7482-9cc8-c66aa457ad59 | SPOT | 2026-09-14 14:49 | call_vertical_spread | 2 | 3 | 17 | 130417.00 | short | bid | 557.6800 | 3.8000 | ["500","600"] | ["0.4159","0.3855"] | ["554.85"] | ["ARCO","XMIO"] | 500.0000 | 600.0000 | 32 | 32 | false | false | |||||||||||
| 01a0a0bd-9638-7031-9eed-910d14bbd53f | SPOT | 2026-09-14 12:26 | call_diagonal_spread | 2 | 1 | 12 | 118272.00 | long | bid | 553.6150 | 8.4500 | ["500","520"] | ["0.6870","0.3795"] | [] | ["BATO"] | 500.0000 | 520.0000 | 4 | 32 | false | false | true | ||||||||||
| 01a0a05e-18e8-7bb1-8758-f8bfb57debb7 | SPOT | 2026-09-14 10:41 | other | 2 | 2 | 14 | 589120.00 | unknown | — | 545.7700 | 9.0000 | ["340"] | ["1.3980"] | [] | ["XCBO","XISX"] | 340.0000 | 340.0000 | 4 | 123 | false | false | true | false | false | ||||||||
| 01a0a05e-18e8-7bb1-8758-f8a3d3e16ad7 | SPOT | 2026-09-14 10:41 | call_calendar | 2 | 5 | 20 | 841600.00 | long | ask | 545.7700 | 9.0450 | ["340"] | ["1.3980"] | [] | ["AMXO","ARCO","EDGO","XCBO","XISX"] | 340.0000 | 340.0000 | 4 | 123 | false | false | true | ||||||||||
| 01a0a05e-18e8-7bb1-8758-f8999f8529f7 | SPOT | 2026-09-14 10:41 | call_calendar | 2 | 2 | 10 | 420280.00 | long | ask | 545.7700 | 12.2750 | ["340"] | ["1.3206"] | [] | ["XPHO"] | 340.0000 | 340.0000 | 4 | 123 | false | false | true | ||||||||||
| 01a091e7-9cf8-7ed0-82e7-28d4e80c692a | SPOT | 2026-09-11 15:17 | put_vertical_spread | 2 | 1 | 39 | 1379040.00 | unknown | — | 526.4500 | 13.5500 | ["690","720"] | ["1.4587","1.6210"] | [] | ["XBOX"] | 690.0000 | 720.0000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a091e5-7630-7d70-a969-804b4b4b8fe9 | SPOT | 2026-09-11 15:15 | other | 3 | 1 | 47 | 1744720.00 | unknown | — | 526.3300 | 20.4000 | ["690","720","760"] | ["1.4508","1.6125","1.8121"] | [] | ["XBOX"] | 690.0000 | 760.0000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a08ce1-2508-7951-a363-33791379c652 | SPOT | 2026-09-10 15:52 | other | 3 | 1 | 74 | 2924216.00 | unknown | — | 521.5250 | 16.2500 | ["690","720","760"] | ["1.1959","0.7649","0.9980"] | [] | ["XPHO"] | 690.0000 | 760.0000 | 8 | 8 | false | false | false | true | false | ||||||||
| 01a08c9a-9e58-7181-8de7-1ceb9b58d008 | SPOT | 2026-09-10 14:35 | other | 4 | 1 | 100 | 3781750.00 | unknown | — | 521.8200 | 26.0500 | ["690","720","740","760"] | ["1.1630","1.3056","1.4415","1.6696"] | [] | ["XBOX"] | 690.0000 | 760.0000 | 8 | 8 | true | false | false | true | false | ||||||||
| 01a08c94-8ba8-74a2-aece-58894bfe1bc3 | SPOT | 2026-09-10 14:28 | other | 2 | 2 | 100 | 550000.00 | unknown | — | 522.1150 | 7.2500 | ["390","430"] | ["0.4754","0.4650"] | [] | ["AMXO"] | 390.0000 | 430.0000 | 280 | 498 | false | true | true | true | false | ||||||||
| 01a08c94-2a00-7841-86f9-88030b903169 | SPOT | 2026-09-10 14:28 | put_vertical_spread | 2 | 1 | 39 | 1394250.00 | unknown | — | 521.8200 | 12.5500 | ["690","720"] | ["1.1630","1.3056"] | [] | ["XBOX"] | 690.0000 | 720.0000 | 8 | 8 | false | false | false | true | false | ||||||||
| 01a08ba0-34e0-7e92-986c-d36b1f04dd26 | SPOT | 2026-09-10 10:02 | other | 3 | 1 | 60 | 182820.00 | unknown | — | 523.9500 | 4.8000 | ["480","520","570"] | ["0.4103","0.3908","0.3762"] | [] | ["EDGO"] | 480.0000 | 570.0000 | 36 | 36 | false | true | false | true | true | ||||||||
| 01a08b8a-8a00-70c1-a3fe-cf4bcc6e781a | SPOT | 2026-09-10 09:38 | put_vertical_spread | 2 | 1 | 200 | 130000.00 | unknown | — | 520.0400 | 6.7000 | ["507.5","510"] | ["0.7136","0.7019"] | [] | ["XISX"] | 507.5000 | 510.0000 | 1 | 1 | false | true | false | true | false | ||||||||
| 01a087bc-d861-7cd1-8a37-4bbb36dc500b | SPOT | 2026-09-09 15:54 | put_vertical_spread | 2 | 3 | 7 | 240366.00 | short | bid | 523.4400 | 9.9000 | ["690","700"] | ["0.9615","1.0062"] | [] | ["EMLD","SPHR","XBOX"] | 690.0000 | 700.0000 | 9 | 9 | false | false | false | ||||||||||
| 01a08748-7b50-7b11-8abc-3078632aaa19 | SPOT | 2026-09-09 13:47 | put_diagonal_spread | 2 | 2 | 38 | 188119.00 | short | bid | 527.1100 | 4.2500 | ["430","450"] | ["0.4541","0.4264"] | [] | ["XCBO","XPHO"] | 430.0000 | 450.0000 | 128 | 281 | false | true | true | ||||||||||
| 01a08716-6700-7d01-a4da-835e0b6f346b | SPOT | 2026-09-09 12:53 | put_vertical_spread | 2 | 1 | 6 | 512292.00 | short | bid | 524.9100 | 16.0500 | ["900","1000"] | ["0.5567","0.6175"] | ["904.68"] | ["XCBO"] | 900.0000 | 1000.0000 | 499 | 499 | false | false | false | ||||||||||
| 01a086ef-f728-78d1-ba64-4dea7bdafd2e | SPOT | 2026-09-09 12:11 | straddle | 2 | 1 | 10 | 167740.00 | short | bid | 526.6950 | 9.7500 | ["560"] | ["0.4499"] | ["392.26","727.74"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | ||||||||||
| 01a086ea-da90-7711-a231-67dba9222760 | SPOT | 2026-09-09 12:05 | straddle | 2 | 1 | 10 | 167900.00 | long | ask | 528.4900 | 5.1500 | ["560"] | ["0.4499"] | ["392.10","727.90"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | ||||||||||
| 01a086e5-bdf9-7ec0-abbc-792cbc259ba7 | SPOT | 2026-09-09 11:59 | straddle | 2 | 1 | 12 | 201600.00 | long | ask | 529.5500 | 4.0500 | ["560"] | ["0.4498"] | ["392","728.00"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | ||||||||||
| 01a08695-34c8-7753-92b4-489fea09f526 | SPOT | 2026-09-09 10:31 | straddle | 2 | 2 | 19 | 318798.00 | short | bid | 531.5200 | 8.3000 | ["560"] | ["0.4486"] | ["392.21","727.79"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | ||||||||||
| 01a08275-8eb0-76a3-baec-a94a86588df9 | SPOT | 2026-09-08 15:18 | put_vertical_spread | 2 | 1 | 39 | 1343160.00 | unknown | — | 529.2000 | 12.0500 | ["690","720"] | ["1.0950","1.1592"] | [] | ["XBOX"] | 690.0000 | 720.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0826c-7690-78b2-a412-96f471a39174 | SPOT | 2026-09-08 15:08 | put_vertical_spread | 2 | 1 | 36 | 1239840.00 | unknown | — | 529.3050 | 12.5000 | ["690","720"] | ["1.1019","1.1678"] | [] | ["XBOX"] | 690.0000 | 720.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a081e9-40b8-72a1-b7e2-0ac2b0f31d0b | SPOT | 2026-09-08 12:45 | call_diagonal_spread | 2 | 1 | 5 | 187615.00 | short | ask | 529.3675 | 14.2000 | ["340","350"] | ["1.0453","0.4854"] | [] | ["ARCO"] | 340.0000 | 350.0000 | 10 | 101 | false | false | true | ||||||||||
| 01a081e8-5a40-7331-830a-e586fbe73b5a | SPOT | 2026-09-08 12:44 | call_calendar | 2 | 1 | 3 | 110379.00 | long | bid | 529.4150 | 13.5500 | ["350"] | ["0.8018"] | [] | ["XMIO"] | 350.0000 | 350.0000 | 10 | 129 | false | false | true | ||||||||||
| 01a081e8-5a40-7331-830a-e570e39310ff | SPOT | 2026-09-08 12:44 | call_calendar | 2 | 2 | 5 | 192315.00 | long | bid | 529.4150 | 14.1000 | ["340"] | ["1.1632"] | [] | ["ARCO"] | 340.0000 | 340.0000 | 10 | 101 | false | false | true | ||||||||||
| 01a06dfc-d616-7363-9aa8-48f42a696fbb | SPOT | 2026-09-04 15:54 | put_vertical_spread | 2 | 1 | 39 | 1260246.00 | long | ask | 542.6900 | 12.9000 | ["690","720"] | ["0.5413","0.6348"] | ["0","690"] | ["XPHO"] | 690.0000 | 720.0000 | 14 | 14 | false | false | false | ||||||||||
| 01a06df0-e37d-76a0-acf2-d7c7562770f2 | SPOT | 2026-09-04 15:41 | put_vertical_spread | 2 | 1 | 5 | 225440.00 | unknown | — | 543.9700 | 11.1500 | ["760","780"] | ["0.7818","0.8433"] | [] | ["ARCO"] | 760.0000 | 780.0000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a06df0-e37d-76a0-acf2-d7b3d6aac0b4 | SPOT | 2026-09-04 15:41 | put_vertical_spread | 2 | 3 | 3 | 134698.00 | unknown | — | 543.9700 | 11.1833 | ["760","780"] | ["0.8742","0.9379"] | [] | ["ARCO","XBOX"] | 760.0000 | 780.0000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a06dd6-857d-7760-beb3-4acdf50a94f2 | SPOT | 2026-09-04 15:12 | put_vertical_spread | 2 | 1 | 39 | 1214460.00 | long | ask | 545.6800 | 15.0000 | ["690","720"] | ["0.8934","1.0100"] | ["0","690"] | ["XBOX"] | 690.0000 | 720.0000 | 14 | 14 | false | false | false | ||||||||||
| 01a06dd3-030d-7f00-9725-5edfd2121ea0 | SPOT | 2026-09-04 15:08 | put_vertical_spread | 2 | 1 | 74 | 206460.00 | unknown | — | 546.3800 | 1.6000 | ["440","450"] | ["0.4298","0.4282"] | [] | ["XISX"] | 440.0000 | 450.0000 | 133 | 133 | false | true | false | true | false | ||||||||
| 01a06dd1-97c6-7211-b40e-57fa1fcbd42f | SPOT | 2026-09-04 15:07 | call_diagonal_spread_bearish | 2 | 1 | 26 | 189660.00 | long | ask | 545.6400 | 8.9000 | ["510","515"] | ["5.6685","0.3501"] | [] | ["XMIO"] | 510.0000 | 515.0000 | 0 | 21 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:50:02Z"} |
| 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:26:41Z"} |
| 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-14T14:41:56Z"} |
| 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-14T14:41:56Z"} |
| 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-14T14:41:56Z"} |
| 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:18:02Z"} |
| 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-11T19:15:51Z"} |
| 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-10T19:52:53Z"} |
| 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-10T18:36:02Z"} |
| 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-10T18:29:15Z"} |
| 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-10T18:29:15Z"} |
| 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-10T14:02:13Z"} |
| 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-10T13:38:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:55:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:47:50Z"} |
| 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-09T16:53:42Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:11:49Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:06:11Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:00:05Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:32:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:19:15Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:09:34Z"} |
| 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-08T16:46:34Z"} |
| 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-08T16:44:55Z"} |
| 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-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:48Z"} |
| 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:41:37Z"} |
| 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:41:37Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:12:56Z"} |
| 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:09:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:07:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |