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 |
|---|
| 01a0cfc2-499f-74b0-bf31-7c5f51ee5f60 | SPY | 2026-09-23 15:33 | box_spread | 4 | 1 | 5 | 130490.00 | short | bid | 767.9000 | 0.9400 | ["730","840"] | ["0.1948","0.1715"] | [] | ["XMIO"] | 730.0000 | 840.0000 | 450 | 450 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T19:34:03Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cfc1-f3ae-7303-81af-e4b56854c802 | SPY | 2026-09-23 15:33 | box_spread | 4 | 3 | 11 | 286814.00 | short | bid | 767.8100 | 0.9900 | ["730","840"] | ["0.1942","0.1717"] | [] | ["ARCO","EMLD","XMIO"] | 730.0000 | 840.0000 | 450 | 450 | false | false | false | true | |||||||||
| 01a0ca9a-575f-7612-a39e-c51a29b800f0 | SPY | 2026-09-22 15:31 | box_spread | 4 | 7 | 46 | 583234.00 | short | bid | 774.3950 | 0.5000 | ["725","775"] | ["0.1761","0.1437"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XPHO"] | 725.0000 | 775.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0c46d-1e67-7353-ae61-a23e1100ac9a | SPY | 2026-09-21 10:44 | box_spread | 4 | 1 | 7 | 375739.00 | short | bid | 768.9250 | 7.7800 | ["500","510"] | ["0.4751","0.4613"] | [] | ["EMLD"] | 500.0000 | 510.0000 | 60 | 60 | false | false | false | true | |||||||||
| 01a0c46d-1697-7632-bcaf-3ed2e73651d1 | SPY | 2026-09-21 10:44 | box_spread | 4 | 1 | 3 | 161031.00 | short | bid | 768.9200 | 7.7800 | ["500","510"] | ["0.4753","0.4615"] | [] | ["EMLD"] | 500.0000 | 510.0000 | 60 | 60 | false | false | false | true | |||||||||
| 01a0c464-0647-77c0-9fe4-ecf7d3777049 | SPY | 2026-09-21 10:34 | box_spread | 4 | 2 | 4 | 214774.00 | short | bid | 769.1050 | 5.6100 | ["500","510"] | ["0.4694","0.4573"] | [] | ["ARCO","EMLD"] | 500.0000 | 510.0000 | 60 | 60 | false | false | false | true | |||||||||
| 01a0b5e7-d837-7ac0-b93f-ba0fd2cd5e51 | SPY | 2026-09-18 15:04 | box_spread | 4 | 1 | 3 | 27429.00 | short | bid | 761.3450 | 0.7200 | ["735","795"] | ["0.1617","0.1240"] | [] | ["EMLD"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | |||||||||
| 01a0b5e7-d837-7ac0-b93f-b9f5349c0c7c | SPY | 2026-09-18 15:04 | box_spread | 4 | 3 | 7 | 63975.00 | short | bid | 761.3450 | 0.7200 | ["735","795"] | ["0.1618","0.1237"] | [] | ["ARCO","EMLD","XMIO"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | |||||||||
| 01a0b5e6-651f-7711-8c6c-14092417d4f4 | SPY | 2026-09-18 15:02 | box_spread | 4 | 2 | 9 | 82317.00 | short | bid | 761.1800 | 0.4133 | ["735","795"] | ["0.1620","0.1238"] | [] | ["ARCO","EMLD"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | |||||||||
| 01a0b5bd-ab57-7e43-8f1b-296b8302c1da | SPY | 2026-09-18 14:18 | box_spread | 4 | 1 | 5 | 107920.00 | short | bid | 759.9450 | 0.7900 | ["755","775"] | ["0.1809","0.1741"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 364 | 364 | false | false | false | true | |||||||||
| 01a0b5ba-1d2f-79b0-be3e-ffbace5f7ded | SPY | 2026-09-18 14:14 | box_spread | 4 | 1 | 5 | 107910.00 | short | bid | 759.8700 | 0.7900 | ["755","775"] | ["0.1809","0.1741"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 364 | 364 | false | false | false | true | |||||||||
| 01a0b080-be43-7e73-8e5a-e5ea95ea4827 | SPY | 2026-09-17 13:53 | box_spread | 4 | 1 | 3 | 64860.00 | short | bid | 762.3050 | 3.6400 | ["755","775"] | ["0.1748","0.1676"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 365 | 365 | false | false | false | true | |||||||||
| 01a0afe4-b8db-7000-9519-7678248feae9 | SPY | 2026-09-17 11:03 | box_spread | 4 | 2 | 4 | 53472.00 | short | bid | 760.8000 | 1.9300 | ["705","790"] | ["0.1850","0.1354"] | [] | ["EMLD","XMIO"] | 705.0000 | 790.0000 | 120 | 120 | false | false | false | true | |||||||||
| 01a0afe4-b8db-7000-9519-76696aa807f1 | SPY | 2026-09-17 11:03 | box_spread | 4 | 2 | 5 | 66840.00 | short | bid | 760.8000 | 1.9300 | ["705","790"] | ["0.1850","0.1354"] | [] | ["EMLD","XMIO"] | 705.0000 | 790.0000 | 120 | 120 | false | false | false | true | |||||||||
| 01a0afdc-6bdb-7543-b35a-8b13acdcc888 | SPY | 2026-09-17 10:54 | box_spread | 4 | 1 | 3 | 43422.00 | short | bid | 760.6900 | 3.4500 | ["720","800"] | ["0.1780","0.1439"] | [] | ["ARCO"] | 720.0000 | 800.0000 | 162 | 162 | false | false | false | true | |||||||||
| 01a0aaee-d703-7290-9e02-af226eee3fc4 | SPY | 2026-09-16 11:56 | box_spread | 4 | 1 | 10 | 215620.00 | short | bid | 760.8100 | 1.0200 | ["755","775"] | ["0.1789","0.1731"] | [] | ["XPHO"] | 755.0000 | 775.0000 | 366 | 366 | false | false | false | true | |||||||||
| 01a0a691-198e-7712-ba20-4a21b431c079 | SPY | 2026-09-15 15:35 | box_spread | 4 | 1 | 30 | 641940.00 | short | bid | 756.9200 | 0.9700 | ["755","775"] | ["0.1789","0.1731"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | |||||||||
| 01a0a683-9886-7403-b427-4d01994d7059 | SPY | 2026-09-15 15:20 | box_spread | 4 | 2 | 30 | 642084.00 | short | bid | 757.1900 | 1.3700 | ["755","775"] | ["0.1789","0.1729"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | |||||||||
| 01a0a676-3aa6-7e93-b7e9-3ee5d51bd583 | SPY | 2026-09-15 15:05 | box_spread | 4 | 1 | 10 | 214200.00 | short | bid | 757.3300 | 0.9700 | ["755","775"] | ["0.1789","0.1731"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | |||||||||
| 01a0a5f9-4275-7ad1-9b79-3fd94a08365f | SPY | 2026-09-15 12:49 | box_spread | 4 | 1 | 10 | 214720.00 | short | bid | 757.3700 | 1.0300 | ["755","775"] | ["0.1793","0.1736"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | |||||||||
| 01a0a5f5-e32e-7661-b767-1fe2de5a8b70 | SPY | 2026-09-15 12:45 | box_spread | 4 | 1 | 10 | 214840.00 | short | bid | 757.7000 | 1.0000 | ["755","775"] | ["0.1794","0.1734"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | |||||||||
| 01a0a5e9-8b06-7d91-9af7-df317787d367 | SPY | 2026-09-15 12:32 | box_spread | 4 | 1 | 7 | 150472.00 | short | bid | 757.6400 | 1.0500 | ["755","775"] | ["0.1794","0.1737"] | [] | ["XISX"] | 755.0000 | 775.0000 | 367 | 367 | false | false | false | true | |||||||||
| 01a091cc-25b8-7b20-a896-772a67e76dfc | SPY | 2026-09-11 14:47 | box_spread | 4 | 1 | 6 | 58164.00 | short | bid | 765.2400 | 0.3100 | ["735","795"] | ["0.1647","0.1297"] | [] | ["SPHR"] | 735.0000 | 795.0000 | 80 | 80 | false | false | false | true | |||||||||
| 01a091cc-25b8-7b20-a896-77124aa331a7 | SPY | 2026-09-11 14:47 | box_spread | 4 | 2 | 9 | 87362.00 | short | bid | 765.2400 | 0.5778 | ["735","795"] | ["0.1656","0.1294"] | [] | ["ARCO","EMLD"] | 735.0000 | 795.0000 | 80 | 80 | false | false | false | true | |||||||||
| 01a08c7c-2d60-7a33-9bc0-4de65df1faa9 | SPY | 2026-09-10 14:02 | box_spread | 4 | 1 | 10 | 182220.00 | short | bid | 758.0350 | 0.5700 | ["755","775"] | ["0.1753","0.1679"] | [] | ["AMXO"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true | |||||||||
| 01a08c50-2bc0-7133-954f-fa7ffe70604b | SPY | 2026-09-10 13:14 | box_spread | 4 | 1 | 9 | 164142.00 | short | bid | 759.1700 | 0.3600 | ["755","775"] | ["0.1750","0.1676"] | [] | ["XISX"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true | |||||||||
| 01a08bfc-81c9-7852-8caf-146561fcb453 | SPY | 2026-09-10 11:42 | box_spread | 4 | 1 | 18 | 328464.00 | short | bid | 759.2850 | 0.2100 | ["755","775"] | ["0.1751","0.1677"] | [] | ["XISX"] | 755.0000 | 775.0000 | 280 | 280 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:33:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:31:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:44:52Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:44:52Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:34:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:04:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:04:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:02:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:18:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:14:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:54:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:03:22Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:03:22Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:54:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:56:33Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:35:42Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:20:52Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:06:34Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:49:47Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:46:29Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:32:25Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:48:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:48:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:02:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:14:37Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:43:11Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |