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 | 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 |
|---|
| 01a0d9d4-fe0f-7770-bd7a-3218fb893043 | GEMI | 2026-09-25 14:30 | call_vertical_spread | 2 | 1 | 300 | 258000.00 | unknown | — | 5.5650 | 0.6000 | ["1","1.5"] | ["9.8041","7.4865"] | [] | ["XCBO"] | 1.0000 | 1.5000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T18:30:26Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9ba-b396-7261-9062-5a6af9a48be0 | GEMI | 2026-09-25 14:01 | call_vertical_spread | 2 | 1 | 194 | 131920.00 | unknown | — | 5.5800 | 0.6000 | ["2","2.5"] | ["3.5312","2.8334"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a0d9b7-96b7-7a22-b2b7-6b43c0d362ec | GEMI | 2026-09-25 13:58 | call_vertical_spread | 2 | 1 | 200 | 136000.00 | unknown | — | 5.5850 | 0.6000 | ["2","2.5"] | ["3.4707","2.7835"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a0d9b5-73d7-7b53-86dc-61eae6f6d7bd | GEMI | 2026-09-25 13:55 | call_vertical_spread | 2 | 1 | 192 | 165120.00 | unknown | — | 5.5750 | 0.6000 | ["1","1.5"] | ["6.7736","5.1728"] | [] | ["XCBO"] | 1.0000 | 1.5000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a0d9b5-2d87-7a13-8ece-41e1e058c527 | GEMI | 2026-09-25 13:55 | call_vertical_spread | 2 | 1 | 200 | 172000.00 | unknown | — | 5.5750 | 0.6000 | ["1","1.5"] | ["6.7736","5.1728"] | [] | ["XCBO"] | 1.0000 | 1.5000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a0d960-a0ff-7723-a76a-e310d882a7f4 | GEMI | 2026-09-25 12:23 | call_vertical_spread | 2 | 1 | 180 | 127620.00 | long | ask | 5.5610 | 1.4000 | ["2","2.5"] | ["4.9655","4.0828"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 14 | 14 | false | false | false | ||||||||||
| 01a0d960-7dd6-7dc2-9ab6-736efc7556b0 | GEMI | 2026-09-25 12:22 | call_vertical_spread | 2 | 1 | 180 | 127620.00 | long | ask | 5.5610 | 1.4000 | ["2","2.5"] | ["4.9655","4.0828"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 14 | 14 | true | false | false | ||||||||||
| 01a0d952-220e-7503-954a-e736c4f1f045 | GEMI | 2026-09-25 12:07 | call_vertical_spread | 2 | 1 | 248 | 216008.00 | long | ask | 5.5750 | 0.5000 | ["1","1.5"] | ["6.6546","5.4380"] | ["1.49"] | ["XISX"] | 1.0000 | 1.5000 | 7 | 7 | true | false | false | ||||||||||
| 01a0d94c-e637-7ae1-b871-bafe3e6c53df | GEMI | 2026-09-25 12:01 | call_vertical_spread | 2 | 1 | 343 | 192080.00 | unknown | — | 5.5850 | 0.5000 | ["2.5","3"] | ["30.0117","20.7963"] | [] | ["XCBO"] | 2.5000 | 3.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a0d4f2-0fc7-7360-8cad-419d8f0a8eb3 | GEMI | 2026-09-24 15:43 | call_vertical_spread | 2 | 1 | 368 | 253920.00 | unknown | — | 5.6900 | 0.4000 | ["2","2.5"] | ["9.4016","7.5198"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0d4e1-71df-7261-8487-2d7f0cfd18ca | GEMI | 2026-09-24 15:25 | call_vertical_spread | 2 | 1 | 188 | 129532.00 | long | ask | 5.7050 | 0.5000 | ["2","2.5"] | ["14.5656","11.7876"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d4e1-3f17-78f0-9e01-bdc9b847a620 | GEMI | 2026-09-24 15:25 | call_vertical_spread | 2 | 1 | 180 | 124020.00 | long | ask | 5.7050 | 0.5000 | ["2","2.5"] | ["14.5656","11.7876"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 1 | 1 | true | false | false | ||||||||||
| 01a0cfcb-cb37-7fa1-87e3-6694bd6f2445 | GEMI | 2026-09-23 15:43 | call_vertical_spread | 2 | 1 | 130 | 113100.00 | unknown | — | 5.6550 | 0.4000 | ["1","1.5"] | ["4.9454","3.7908"] | [] | ["XCBO"] | 1.0000 | 1.5000 | 16 | 16 | false | false | false | true | false | ||||||||
| 01a0cfa0-a83e-7d92-88ca-fc8e02acd99f | GEMI | 2026-09-23 14:56 | call_vertical_spread | 2 | 1 | 283 | 189610.00 | unknown | — | 5.6200 | 0.4000 | ["2","2.5"] | ["4.5866","3.6927"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 9 | 9 | false | false | false | true | false | ||||||||
| 01a0ca72-5cff-75a1-ad70-230c2b403493 | GEMI | 2026-09-22 14:48 | call_vertical_spread | 2 | 1 | 179 | 162174.00 | long | ask | 5.8850 | 3.5000 | ["1","1.5"] | ["11.7542","8.8660"] | ["1.5"] | ["XCBO"] | 1.0000 | 1.5000 | 24 | 24 | false | false | false | ||||||||||
| 01a0ca6d-e08f-72b1-84d5-ef09ac441845 | GEMI | 2026-09-22 14:43 | put_vertical_spread | 2 | 1 | 193 | 129310.00 | unknown | — | 5.8850 | 0.4000 | ["9","9.5"] | ["1.9077","2.0768"] | [] | ["XCBO"] | 9.0000 | 9.5000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0ca2f-be4f-7732-bb07-7095a5eb4218 | GEMI | 2026-09-22 13:35 | call_vertical_spread | 2 | 1 | 303 | 251490.00 | unknown | — | 5.9450 | 0.4000 | ["1.5","2"] | ["9.4483","7.5747"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0ca2d-60d7-70a1-a5d9-dd1a6a034413 | GEMI | 2026-09-22 13:32 | call_vertical_spread | 2 | 1 | 187 | 117810.00 | unknown | — | 5.9350 | 0.4000 | ["2.5","3"] | ["6.3837","5.1950"] | [] | ["XCBO"] | 2.5000 | 3.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a0ca26-67af-7a93-a3ec-c9c3b25d30a1 | GEMI | 2026-09-22 13:25 | call_vertical_spread | 2 | 1 | 249 | 206421.00 | long | ask | 5.9300 | 0.5000 | ["1.5","2"] | ["9.9572","7.9840"] | ["1.99"] | ["XISX"] | 1.5000 | 2.0000 | 3 | 3 | true | false | false | ||||||||||
| 01a09201-7df8-7053-b3f1-985ffe854e58 | GEMI | 2026-09-11 15:46 | call_vertical_spread | 2 | 1 | 300 | 135000.00 | unknown | — | 4.4800 | 0.4000 | ["2","2.5"] | ["3.2306","2.4180"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a091f4-7220-7440-b4ec-178a6ac08be9 | GEMI | 2026-09-11 15:31 | call_vertical_spread | 2 | 1 | 203 | 110838.00 | short | bid | 4.4800 | 0.3500 | ["1.5","2"] | ["123.4062","81.3152"] | ["2"] | ["XCBO"] | 1.5000 | 2.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a091f4-04c0-7ae2-a5b3-3f6c0d109b10 | GEMI | 2026-09-11 15:31 | call_vertical_spread | 2 | 1 | 200 | 109200.00 | short | bid | 4.4800 | 0.3500 | ["1.5","2"] | ["122.3970","80.6502"] | ["2"] | ["XCBO"] | 1.5000 | 2.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a091b7-b740-7093-bb05-3a450ee63cce | GEMI | 2026-09-11 14:25 | call_vertical_spread | 2 | 1 | 188 | 102460.00 | unknown | — | 4.4677 | 0.1500 | ["1.5","2"] | ["32.6673","30.9587"] | [] | ["XISX"] | 1.5000 | 2.0000 | 0 | 0 | true | false | false | true | false | ||||||||
| 01a06e00-44fd-73f0-aa62-26a5dc26f6e4 | GEMI | 2026-09-04 15:58 | put_vertical_spread | 2 | 1 | 208 | 192608.00 | long | ask | 4.6900 | 0.7000 | ["9","9.5"] | ["239.5987","253.7120"] | ["0","9"] | ["XCBO"] | 9.0000 | 9.5000 | 0 | 0 | false | false | false | ||||||||||
| 01a06df9-c4ed-7f31-958c-b4c064ee4780 | GEMI | 2026-09-04 15:51 | put_vertical_spread | 2 | 1 | 200 | 185200.00 | long | ask | 4.7001 | 0.7000 | ["9","9.5"] | ["106.1337","112.3177"] | ["0","9"] | ["XCBO"] | 9.0000 | 9.5000 | 0 | 0 | false | false | false | ||||||||||
| 01a06de2-ba7d-76b1-8302-274f9e40fcbb | GEMI | 2026-09-04 15:26 | put_vertical_spread | 2 | 1 | 188 | 173148.00 | long | ask | 4.7400 | 0.7000 | ["9","9.5"] | ["56.0377","57.8336"] | ["9.01"] | ["XISX"] | 9.0000 | 9.5000 | 0 | 0 | false | false | false | ||||||||||
| 01a06dc1-4415-7db3-b02e-0a5824567013 | GEMI | 2026-09-04 14:49 | put_vertical_spread | 2 | 1 | 220 | 204380.00 | long | ask | 4.6650 | 0.6000 | ["9","9.5"] | ["35.9793","36.8188"] | ["9.01"] | ["XISX"] | 9.0000 | 9.5000 | 0 | 0 | true | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:01:32Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:58:14Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:55:48Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:55:48Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:23:02Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:23:02Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:07:17Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:01:49Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:44:01Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:25:52Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:25:52Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:44:19Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:57:30Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:48:52Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:43:34Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:35:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:32:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:25:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:46:18Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:32:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:31:32Z"} |
| 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-11T18:25:43Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:58:25Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:51:34Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:26:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:49:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |